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