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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

I’m Mike

Welcome to my blog, which I have maintained for several years, off and on, to share things that I’ve learned from numerous projects and various problem solving escapades. This is my way of giving something back to the online communities that have helped me learn more about a wide variety of topics.