上幹貨: (持續記錄中...)
1.上篇文章有寫到mysql_secure_installation,直接運作輸入舊密碼(沒有不用輸入)
2.mysql --user=root --password連到MySQL server,
ALTER USER USER() IDENTIFIED BY 'neW%[email protected]';
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============