mac mysql修改密码

转载于 2017-06-13 14:37:26 发布

· 319 阅读

mysql 专栏收录该内容

16 篇文章

订阅专栏

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

MySQL 5.7.6 and later:

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

MySQL 5.7.5 and earlier:


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

If the ALTER USER statement fails to reset the password, try repeating the procedure using the following statements to modify the user table directly:

UPDATE mysql.user
    SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N'
    WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;