MAC下如何更改Mysql的密码

来源:互联网 发布:域名后缀cc 编辑:程序博客网 时间:2024/04/30 21:04
1.Stop the mysqld server2.sudo mysqld_safe --skip-grant-tables3.change passwordmysql -u rootmysql> USE mysql;mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='root';  or UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD") WHERE User='root';mysql> FLUSH PRIVILEGES;mysql> quit
0 0