上干货: (持续记录中...)
1.上篇文章有写到mysql_secure_installation,直接运行输入旧密码(没有不用输入)
2.mysql --user=root --password连到MySQL server,
ALTER USER USER() IDENTIFIED BY 'neW%P@ssw0rd';
3.
mysqladmin --user=root --password password
4.ALTER USER 'backup'@'localhost' IDENTIFIED BY 'password'; 'backup'@'localhost'/'password'对应账号和新密码,与方法三基本相同;方法三为当前账号修改密码,这里可以指定其他账号
5.SET PASSWORD FOR 'backup'@'localhost' = PASSWORD('password');
6.UPDATE mysql.user SET authentication_string=PASSWORD("1234") WHERE user='root';
更改密码后刷新缓存,flush privileges \g
===========End============