Mysql5.7.14 Linux version password forgotten perfect solution

In the /etc/my.conf file, add the following line under [mysqld]: skip-grant-tables

Remember to add it last under [mysqld], not under [ mysqld_safe ]

After saving, restart Mysql and execute directly in the Linux command line: mysql Enter

OK

To change your password:

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

Result error:

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

Check the fields and find that there is no password field, but there is an authentication_string field

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

Summarize

The above is the perfect solution for forgetting the password of Mysql5.7.14 Linux version introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!