mysql登陆错误:error: 'Plugin '*2A8AF30E682613A2F1CE1E28BA11D8560B294DCE' is not loaded'
http://stackoverflow.com/questions/30680865/mysql-java-sql-sqlexception-plugin-765c23fcc8127a2234dbcfb6e5207d82ed86264e
http://blog.csdn.net/gavinking0110/article/details/53081059
[client] port = 3306 [mysqld] skip-grant-tables
1 在my.ini中添加了skip-grant-tables,然后不用密码登陆root,mysql -u root -p 直接回车,再回车
2、mysql>mysql -u root -p
3、mysql>update user set password=PASSWORD("123456") where user='root';
4、修改成功,再次root加密码登陆,失败,还是同样的问题
5、在my.ini中添加了skip-grant-tables,然后不用密码登陆root。mysql> SELECT Host,User,Password,plugin from user;发现plugin参数不是“mysql_native_password”
6、update user set plugin='mysql_native_password';搞定。