This problem drove me crazy until I figured it out. I stumbled upon the solution in a forum post but, unfortunately, I didn’t save the link to share in this post
It seems that when setting passwords for MySQL when using a Docker Compose script in Portainer that the passwords must not contain any special characters.
This seemed to apply to any accounts – not just root.
I don’t know if it’s specific to Portainer or Docker Compose.
Removing any special characters worked and I was then able to login to the new MySQL instance.

Leave a comment