Mysql 5.7 系列命令

官方原文链接mysql set password

操作之前先查看自己MySql的版本号对号入座。

mysql --version

5.7.6版本以上

连接

mysql -u root

修改密码

ALTER USER user IDENTIFIED BY 'new_password';

修改密码与授权远程

ALTER USER `'root'@'localhost'` IDENTIFIED BY 'new_password'

查询表信息

SELECT User, Host, HEX(authentication_string) FROM mysql.user;

5.7.6版本以下

连接

mysql -u root

修改密码

SET PASSWORD FOR user = PASSWORD('new_password');

修改密码与授权远程

SET PASSWORD FOR 'user'@'localhost' = PASSWORD('new_password');

查询表信息

SELECT User, Host, Password FROM mysql.user;