I was having weird issues with my Rails apps on MySQL 5.7+ and getting the error
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded. Basically we need to set the authorization plugin back to
mysql_native_password. What a pain.
In the mysql prompt enter the following lines:
use mysql; update user set plugin="mysql_native_password"; flush privileges;
MySQL upgrades are super frustrating. This is just another sign that I would really love to be able to use MariaDB but maybe just for future projects.
Related External Links: