mysql登录提示ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded解决方法 

1 /etc/init.d/mysql stop
2 3 4 vim /etc/my.cnf
添加
 skip-grant-tables 

5 mysql -u root
6 use mysql;
7 update user set password=PASSWORD("mynewpassword") where User='root';
8 update user set plugin="mysql_native_password";

 

posted @ 2018-12-18 16:54  爱热闹的杨小厨  阅读(4705)  评论(0)  编辑  收藏  举报