Mysql5.7.14 the perfect solution for forgetting the linux Password is mysql5.7.14linux

Mysql5.7.14 the perfect solution for forgetting the linux Password is mysql5.7.14linux

Add the last line under [mysqld] in the/etc/my. conf file:Skip-grant-tables

Remember that at the end of [mysqld], do not add it [Mysqld_safe] Below

After saving, restart Mysql and run the following command on the linux Command Line: mysql press ENTER

OK

Change Password:

Update mysql. user set password = password ('root') where user = 'root'

Error:

Mysql> select host, user, password from user; ERROR 1054 (42S22): Unknown column 'Password' in 'field list' desc user;

No password field is found.Authentication_stringField

Update mysql. user set authentication_string = password ('root') where user = 'root ';

OK

Delete skip-grant-tables under [mysqld] in the/etc/my. conf file

Restart mysql

Summary

The above is the perfect solution for forgetting the password of Mysql5.7.14 linux introduced by Alibaba Cloud. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!