mac初始化密码

停止 mysql server

打开一个终端，进入mysql的bin目录，输入：./mysqld_safe --skip-grant-tables &

再打开另外一个终端，输入

     sudo /usr/local/mysql/bin/mysql -u root
     UPDATE mysql.user SET authentication_string=PASSWORD('新密码') WHERE User='root';
     FLUSH PRIVILEGES;

关闭mysqld_safe

 

不走下面这步骤进入mysql后的任何操作都会报You must reset your password using ALTER USER statement before executing this statement.

异常信息

 

重启mysql，进入mysql的bin

 输入：./mysqladmin -u root -p password
Enter password: 
New password: 
Confirm new password: 

 

重新设置密码成功后，

./mysql -u root -p 

进入mysql，操作正常