Authentication plugin 'caching_sha2_password' cannot be loaded
you can change the encryption of the password like this.
ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';
Note: For MAC OS
- Open MySQL from System Preferences > Initialize Database >
- Type your new password.
- Choose 'Use legacy password'
- Start the Server again.
- Now connect the MySQL Workbench
For Windows 10:
Open the command prompt:
cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"C:\Program Files\MySQL\MySQL Server 8.0\bin> mysql -u root -pEnter password: *********mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newrootpassword';Query OK, 0 rows affected (0.10 sec)mysql> exitAlternatively, you can change the my.ini configuration as the following:
[mysqld]default_authentication_plugin=mysql_native_passwordRestart the MySQL Server and open the Workbench again.