mysql root 忘记密码

1. 关闭mysql服务器
2. sudo /usr/local/mysql/support-files/mysql.server stop
   也可以在系统偏好里有个MySQL里关闭。
3. cd /usr/local/mysql/bin 进入目录
4. sudo su 获取权限
5. ./mysqld_safe --skip-grant-tables & 重启服务器
6. 重开个终端

cd /usr/local/mysql/bin/mysql

1. 输入mysql 进入mysql命令模式
2. use mysql进入mysql数据库
3. flush privileges;获取权限
4. set password for 'root'@'localhost'=password('新密码'); 完成修改

1. Stop MYSQL Server

2. Open terminal and enter: cd /usr/local/mysql/bin/

3. Enter: sudo su , then enter your mac password

4. Enter: sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

5. Open a new terminal tab and enter: sudo /usr/local/mysql/bin/mysql -u root

6. Enter: UPDATE mysql.user SET authentication_string=PASSWORD('YOUR NEW MYSQL PASSWORD') WHERE User='root';

7. Enter: FLUSH PRIVILEGES;

8.Enter: \q

作者：Xianan Zhang
链接：https://www.zhihu.com/question/41158204/answer/226950881
来源：知乎
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。