Solution to ERROR 1054 (42S22) when changing password in MySQL 5.7

I have newly installed MySQL 5.7. When I log in, I get a message saying that the password is wrong. I did not change the password during installation. Later, I changed the password by logging in without a password. When I enter update mysql.user set password=password('root') where user='root', I get a message saying ERROR 1054 (42S22): Unknown column 'password' in 'field list'. It turns out that there is no password field in the MySQL database. The password field has been changed to authentication_string.

So change the statement to update mysql.user set authentication_string=password('root') where user='root';

My system version is as follows:

The complete procedure for changing the MySQL password is as follows:

1. vim /etc/my.cnf add skip-grant-tables

2. Restart MySQL, /etc/init.d/mysqld restart

3. Enter mysql in the terminal to log in to the MySQL database directly, and then use mysql

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

To change the password in MySQL 5.7, you should use the command ALTER USER 'root'@'localhost'IDENTIFIED BY '********', in which the password naming rule has changed.

The password set for MySQL must contain at least one uppercase letter, one lowercase letter, one special symbol, and one number.
Password must be at least 8 characters long

5. Edit the my.cnf file and delete the skip-grant-tables line, then restart MySQL, /etc/init.d/mysqld restart, otherwise MySQL can still log in without a password

6.mysql -u root -p

Then enter the password to log in to the MySQL database

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.