- 关闭mysql服务器
- sudo /usr/local/mysql/support-files/mysql.server stop
也可以在系统偏好里有个MySQL里关闭。 - cd /usr/local/mysql/bin 进入目录
- sudo su 获取权限
- ./mysqld_safe --skip-grant-tables & 重启服务器
- 重开个终端
cd /usr/local/mysql/bin/mysql
- 输入mysql 进入mysql命令模式
- use mysql进入mysql数据库
- flush privileges;获取权限
- 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
来源:知乎
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。