Authentication plugin 'caching_sha2_password' cannot be loaded #5
Description
Unable to connect to host 127.0.0.1, or the request timed out.
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
mysqld version is mysql:8.0.31, I'm using mysql:8.0.31 docker image.
I've checked my host server, there's no /usr/local/mysql/lib/plugin/ exists, and I've checked the docker container(inside the container), there's no /usr/local/mysql/lib/plugin/ too.
I tried using Navicat Premium, it works, mysql-server can successfully be connected, no errors.