ERROR 1054 (42S22): Unknown column 'password' in 'field list'

mysql> update user set password=PASSWORD("New_Password") where User='root';

ERROR 1054 (42S22): Unknown column 'password' in 'field list'

 

In MySQL 5.7 or higher version the password field in mysql.user table field was removed, now the field name is ‘authentication_string’. In mysql 5.7 or higher version you can use following command to reset the mysql password for a user

mysql> update user set authentication_string=PASSWORD("New_Password");

Query OK, 2 rows affected, 1 warning (0.00 sec)

Rows matched: 2  Changed: 2  Warnings: 1

Comments