MySQL upgrade (5.5 to 5.7)

Posted on

Question :

I upgraded my MySQL version from 5.5 to 5.7 and in phpmyadmin I get this error message. I tried to reinstall and reconfigure it but I have still this problem. Can you help me? I am using Linux Mint. Thank you

enter image description here

Answer :

It takes two steps. You must upgrade from 5.5 to 5.6 and run mysql_upgrade, then do 5.6 to 5.7.

When you are upgrading best practice is to upgrade to the next available version i.e just upgrade from 5.5 to 5.6 using mysql_upgrade , you can do in place upgrade or you can take entire database dump and install a new service and restore the backed up database there.
and once you move to 5.6 upgrade it to 5.7 version.

Leave a Reply

Your email address will not be published. Required fields are marked *