记录下当时自己的操作,希望对你解决问题有帮助:
首先打开Mac 自带的 terminal:
Go to mysql/bin directory(到该目录下)
$ cd /usr/bin
Start a mysql deamon with this option:
$ sudo mysqld_safe --skip-grant-tables
Open another terminal and open a mysql session to execute this: (再开启一个terminal : 快捷键 command + t)
$ mysql mysql> use mysql;
see Note1 below for next line.
mysql> UPDATE user SET authentication_string=PASSWORD('YOUR_NEW_PASSWORD_HERE') WHERE user = 'root'; //蓝色的就是你要输入的新密码
mysql> exit;
Now kill the mysqld_safe process and restart mysqld normally:
$ sudo service mysqld start
就是这么简单!
Note1: password
is the column name in table mysql.user
prior to version 5.7. After which it became authentication_string
. Change your update statement accordingly.
如果解决了你的问题,打个赏吧
想学习黑客入门,联系QQ392371202.
另外,我这里有破解版的Navicat.dmg
关于我:
90后小码农,毕业于北邮计算机,渣硕,写过ios,做过信息安全,现在在微软STCA做Flink流式处理。希望和大家多多交流!
如何你们看不懂,给我留言,我教你。