初学mysql 那些记不住的命令

修改密码:

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

 

MySQL 5.7.6 之后:

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

MySQL 5.7.5 之前:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');