MySQL Forums
Forum List  »  Source, Builds, Binaries

Re: upgrade from mysql 5.6 to 5.7
Posted by: Peter Brawley
Date: July 02, 2016 01:47PM

> i use PhpMyadmin, like many people do.

That's fine, and for problems like this oneyou also need to know how to use the mysql commandline client program, in this case so you can determine whether the problem is with MySQL or with phpMyAdmin.

MySQl 5.7 added these three columns to the mysql.user table ...

password_last_changed
password_lifetime
account_locked

... and removed the `password` column. Does the MySQL 57 client program see these changes? Does phpMyAdmin see them? If the answeerrs are yes and no respectively, phpMyAdmin may be looking at your 5.6 MySQL data folder. If that's the case, the question is, did you run mysqldump on your 5,6 installation, then port the data to 5.7, or did you just point the 5.7 installation at your previous mysql data folder?

Options: ReplyQuote


Subject
Views
Written By
Posted
6394
June 23, 2016 02:01PM
Re: upgrade from mysql 5.6 to 5.7
1833
July 02, 2016 01:47PM
1951
July 30, 2016 04:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.