The Ultimate Guide to High Availability with MariaDB

Login Fails After Upgrading to 10.4.6

I run MariaDB in a Docker container (downloaded from Docker Hub) in MacOS 10.14.5. I recently tried to upgrade from MariaDB 10.3.15 to 10.4.6. The new Docker image starts and runs okay until I run 'mysql_upgrade'. After 'mysql_upgrade successfully completes, I can no longer login to MariaDB 10.4.6 with root or any other user. I am completely locked out, even though MariaDB is running in the Docker container.

I have read that 10.4 has changed authentication, but I am completely baffled trying to figure out how to login. Please help -- thanks!

Answer Answered by Richard Dunn in this comment.

My resolution for this was to run mysqldump for all databases on my 10.3.15 instance. I then started a new 10.4.6 image in Docker with a new data volume (instead of trying to run mysql_update on the old data volume). I imported the mysqldump databases, recreated my users and privileges, and all is fine now.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.