Docker MySQL access denied while having a configured MYSQL_ROOT_PASSWORD

May 14, 2019 258 views
Docker MySQL Ubuntu 18.04

I have a Ubuntu Docker droplet but I can't access MySQL as root, it will give:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

My docker-compose.yml has a MYSQL_ROOT_PASSWORD setted, locally I can access MySQL, but I can't while on Digital Ocean. Is there any default password that I am missing? How do I find it?

1 Answer

Have you changed the passwords since you first tried running the containers? docker-compose does extra work to preserve volumes between runs (thus preserving the database); you may want to try docker-compose rm -v to delete everything and try starting it up again.

Have another answer? Share your knowledge.