Question
Docker MySQL access denied while having a configured MYSQL_ROOT_PASSWORD
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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
when you try to access mysql through docker container for the first time use a blank password as your default root password
then hit enter without providing a password.
Works for me