官方原文鏈接mysql set password
操作之前先查看自己MySql的版本號(hào)對(duì)號(hào)入座。
mysql --version
5.7.6版本以上
連接
mysql -u root
修改密碼
ALTER USER user IDENTIFIED BY 'new_password';
修改密碼與授權(quán)遠(yuǎn)程
ALTER USER `'root'@'localhost'` IDENTIFIED BY 'new_password'
查詢(xún)表信息
SELECT User, Host, HEX(authentication_string) FROM mysql.user;
5.7.6版本以下
連接
mysql -u root
修改密碼
SET PASSWORD FOR user = PASSWORD('new_password');
修改密碼與授權(quán)遠(yuǎn)程
SET PASSWORD FOR 'user'@'localhost' = PASSWORD('new_password');
查詢(xún)表信息
SELECT User, Host, Password FROM mysql.user;
