自己整理,以便查看。
第一步:偏好设置->找到MySQL,点进去 Stop MySQL Server
第二步:打开终端,输入命令 sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
第三步:打开一个新的终端,输入命令 sudo /usr/local/mysql/bin/mysql -u root,然后输入命令
UPDATE mysql.user SET authentication_string=PASSWORD('111111') WHERE User='root';(注意后面的分号不能忘)
第四步:FLUSH PRIVILEGES; 然后 quit; 退出。
如果出现错误:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
第五步: SET PASSWORD=PASSWORD('111111');
PS:
MySQL命令行停止、启动、重启命令如下:
sudo /usr/local/MySQL/support-files/mysql.server stop
sudo /usr/local/MySQL/support-files/mysql.server start
sudo /usr/local/MySQL/support-files/mysql.server restart