Authentication plugin 'caching_sha2_password' cannot be loaded

 Image by  alandsmann  from  Pixabay

This is how to handle the error "Authentication plugin 'caching_sha2_password' cannot be loaded" when linking to MySQL on MacBook.

The cause is that the password processing method has changed since MySQL 8.x and later, but SQLAlchemy is looking at the old method.

If MySQL Community is installed, click “System Settings” and then click MySQL.

Click “Initialize Database”.

Enter a password of appropriate length, select “Use Legacy Password Encryption” and click “OK”.

Click “Start MySQL Server”.

After the MySQL server is running, you can reconnect.

If you do not have MySQL Community, you can change the root password to mysql_native_password.

mysql> alter user 'root'@'localhost' identified with mysql_native_password by ‘new password';