Mac modifies MySQL password, navicat connection failure reason

1, cd/usr/local/mysql/bin/
?
2, sudo su
After input will be asked to enter your computer password, enter the time is nothing to display, after the output, enter

3./mysqld_safe--skip-grant-tables &
This step is to cross permission validation?

4,./mysql-u Root

Use another window to log in as root, because the reason for the third step does not require a password.

5. Update user set authentication_string= ' root123 ' where user= ' root ';?

Navicat Connection Error:

The previous step was thought to have been able to log in, but the Navicat connection test appeared:

ERROR 1862 (HY000): Your password has expired. To log on you must
Change it using a client, that supports expired passwords.

So the next two steps are required (I can also log in with the client without the following steps)

To open a new terminal:

1, cd/usr/local/mysql/bin/
?
2, sudo su

3,./mysql-uroot-proot123

4, SET PASSWORD = PASSWORD (' root123 ');

Reference http://blog.csdn.net/jia611/article/details/51553067

Mac modifies MySQL password, navicat connection failure reason