MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
I had the following solution:
change my.ini in a [mysqld]
section like this:
#default_authentication_plugin=caching_sha2_password (comment line!)
default_authentication_plugin=mysql_native_password (new line)
Connect to your MySQL under root in a command line client and execute:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxx';
Where xxx
is your current password.
Try to connect your MySQL use terminal, and use this.
mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
See:
Changes in MySQL Workbench 8.0.11 (2018-04-19, Release Candidate)
...
- MySQL Workbench now supports the caching_sha2_password authentication plugin introduced in MySQL 8.0 (see Caching SHA-2 Pluggable Authentication). A user account can be reset to use the other available authentication types for making a connection.
...