"Authentication plugin 'caching_sha2_password' cannot be loaded. The specific module can not be found"

Question

I am new to SQL and keep getting an error "Authentication plugin 'caching_sha2_password' cannot be loaded. The specific module can not be found" while connecting.

Answer 1

1. In your text editor of choice, open (or create) the /usr/local/etc/my.cnf file and add the following to the [mysqld] section of the file:

   default-authentication-plugin=mysql_native_password

2. Open a terminal window, open an SSH session to your naked Mac Mini Server, and enter the following at the shell prompt:

   mysql -u root -p ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'NEWPASSWORD';

Where NEWPASSWORD is the password you want to assign to the MySQL root user.

1. exit
2. Reboot your Mac.

Contents of this post is taken from farces.com