mysql--ERROR 1524 (HY000): Plugin ‘auth_socket‘ is not loaded

ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded

重置root密码时，还要将auth插件更改为mysql_native_password

免密重置密码
sudo service mysql stop
sudo mysqld_safe --skip-grant-tables&
If error：
sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql  /var/run/mysqld
sudo mysqld_safe --skip-grant-tables&
mysql -u root mysql

修改密码：
update user set authentication_string = PASSWORD('XXXXXX') where user='root';
update user set plugin="mysql_native_password";
FLUSH PRIVILEGES;

重新登录：
mysql -u root -pXXXXXX