sameersbn / docker-mysql

A Dockerfile that installs a mysql server
MIT License
247 stars 173 forks source link

Upgrade from very old docker image #44

Open andyinno opened 3 years ago

andyinno commented 3 years ago

I have a very old image that was installed using the :latest tag

I am trying to take it up to something more recent, however with all the tags that I found on docker hub I have this error message (version is different with different tags):

ERROR 3009 (HY000) at line 1: Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50554, now running 50724. Please use mysql_upgrade to fix this error.

I am unable to run the mysql_upgrade command inside the docker container because the image stops.

There is an easy way for recover this situation? Question: shouldn't the mysql_upgrade taken into consideration when mysql version changes?

Thank you in advance