1.跳过密码登陆
配置 /etc/my.cnf 跳过密码登陆 skip-grant-tables
vi /etc/my.cnf
重启mysql
/etc/init.d/mysql restart
2.依次进行下一步
mysql -u root –p (直接多次回车)
use mysql;
update user set authentication_string = '' where user = 'root';(清空密码)
quit
3.配置 /etc/my.cnf 删除刚才的配置 并重启
mysql -u root –p (无需输入密码,直接按回车键进入)
use mysql
ALTER USER 'root'@'%' IDENTIFIED BY 'password';
结束