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 |