How to change the root password of Mysql5.7.10 on MAC

First, start MySQL in skip-grant-tables mode: mysqld --skip-grant-tables &

From now on, you will step into the first pit, if you use the wrong modification method posted everywhere on the Internet:

mysql> UPDATE mysql.user SET authentication_string=PASSWORD('your_new_password') WHERE User='root';

(Note that after 5.7, password is changed to authentication_string) Congratulations, you have successfully modified it, but you will find that when you use a GUI tool such as navicat to connect, the following error will be reported:

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

At the same time, you will find that the command line can use mysql -u root -p to log in, but you can't use mysql, and you can't even use the database. What the hell?

The following command will save you:

mysql> SET PASSWORD = PASSWORD('your_new_password');

After execution, shut down mysqld using the command mysqladmin -u root -p shutdown

Start mysql again with mysql.server start and everything will be ok~

The above is the method I introduced to you to change the root password of Mysql5.7.10 version under MAC. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!