This is to change the password of a user. The command found on the Internet is as follows

mysql> update user setPassword =password(" new password ") where user= "username";Copy the code

ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’

The cause of the error is that the mysql database in version 5.7 no longer has the password field. The password field has been changed to authentication_string

So use the following command:

>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.718.-log MySQL Community Server (GPL)


Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c'to clear the current input statement. mysql> use mysql; Database changed mysql> select User from user; # here to query the User command + -- -- -- -- -- -- -- -- -- -- -- + | User | + -- -- -- -- -- -- -- -- -- -- -- + | * * * * * * * | | mysql. The sys | | root | + -- -- -- -- -- -- -- -- -- -- - +3 rows in set (0.00 sec)

mysql> update user set password=password("* * * * * * *") where user="* * * * * * *"; ERROR message displayed when changing password1054 (42S22): Unknown column 'password' in 'field list'
mysql> update mysql.user set authentication_string=password('* * * * * * *') where user='* * * * * * *'; Query OK,1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1mysql> flush privileges; Query OK,0 rows affected (0.00 sec)Mysql > quit Bye n>mysql -u ******* -p # Enter password: * * * * * * * *................................................ mysql>Copy the code