1

Installed latest mysql version 5.7.10 . When I tried to create new users it's giving me error. Tried different ways provided in the mysql documents. but it's still giving me error

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user'

Could anyone help me out regarding this .Thanks.

Arav
  • 4,957
  • 23
  • 77
  • 123
  • Did u restart mysql? – devpro Jan 16 '16 at 12:45
  • Was this an upgrade from a previous version? Also, *"Tried different ways provided in the mysql documents"* would be more helpful if you explained what you are talking about. – Michael - sqlbot Jan 16 '16 at 15:16
  • In MYSQL 5.7 the user changed a bit : _MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password._ For more information [See this page in the manual](http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html) – RiggsFolly Jan 16 '16 at 16:57
  • 1
    Thanks a lot for the info. Ran mysql_upgrade , it fixed the tables and now create user is working now. – Arav Jan 18 '16 at 12:31

1 Answers1

1

Thanks a lot for the info. Ran mysql_upgrade , it fixed the tables and now create user is working now.

Arav
  • 4,957
  • 23
  • 77
  • 123