MySQL unknown column 'password_last_changed'

mysql mysql-workbench mysql-error-1054
Ammar Jibarah picture Ammar Jibarah · Apr 5, 2015 · Viewed 17.2k times · Source

When creating a user using this command:

create user 'foo'@localhost';

this error is shown:

ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user'

Using MySQL server version: 5.7.6

I tried to add it but I don't know its data-type How can I fix this?

Answer

Ahmad Tawila picture Ahmad Tawila · Jan 28, 2016

Apparently you upgraded your MySQL to 5.7 from an earlier version.

Column 'password_last_changed' used to exist in MySQL <5.7, but was removed since 5.7

If this is the case, you have to run 'mysql_upgrade' script to migrate some tables from the old version to the new one.

run 

mysql_upgrade -u root -p

and enter your root password.

then you should have your problem solved

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More