mac. mysql 设置root_mac系统修改mysql root密码

mysql启动，停止和重启命令

sudo /usr/local/mysql/support-files/mysql.server start

sudo /usr/local/mysql/support-files/mysql.server stop

sudo /usr/local/mysql/support-files/mysql.server restart

mysql 重置密码

停止 mysql server.

'系统偏好设置' > MySQL > 'Stop MySQL Server'

或者使用上述命令停止mysql服务

如果出现报错MySQL server PID file could not be found!可能是因为之前操作有mysql进程还在

ps -ef|grep mysqld

kill -9 进程号

2.跳过密码验证启动：

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

3.打开新终端输入 /usr/local/mysql/bin/mysql -u root

use mysql;

flush privileges;

alter user 'root'@'localhost' identified by 'yourpassword';

quit

4.重启mysql服务：

sudo /usr/local/mysql/support-files/mysql.server restart

登陆mysql服务

sudo /usr/local/mysql/bin/mysql -u root -p