Unknown column password_last_changed in ‘mysql.user’ [Solved]

Updated on September 3, 2017

Question: After upgrading MySQL to version 5.7, I’m not able to create a user or set password using GRANT query. Here’s the error message: Unknown column password_last_changed in ‘mysql.user’.

For e.g.,

mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@localhost IDENTIFIED BY 'mypass';
ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user'


Unknown column password_last_changed

The issue was due to the MySQL update. MySQL versions less than 5.7  used column ‘password_last_changed’ and it was subsequently removed in version 5.7. So after the update, you need to run mysql_upgrade command to migrate the tables from old version to newer version.

$ mysql_upgrade

The output should indicate that the tables are being upgraded to the newer version. Once done, you need to restart MySQL server.

$ /etc/init.d/mysqld restart.

That’s it!

You might be interested in solutions for common MySQL errors.

Was this article helpful?

Related Articles

Leave a Comment