Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
CPU usage problem by MySQL In a WordPress site Question Question
Create a Droplet from a snapshot using the snapshot's name instead of its id Question Question

Question

Docker MySQL access denied while having a configured MYSQL_ROOT_PASSWORD

Posted May 14, 2019 26.6k views
MySQLDockerUbuntu 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?

Add a comment
victore3f16affbb5f095876d4
By:
victore3f16affbb5f095876d4

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
CPU usage problem by MySQL In a WordPress site Question Question
Create a Droplet from a snapshot using the snapshot's name instead of its id Question Question
Add a comment
1 comment
  • entrepreneurjemmott April 6, 2020
    Reply Report

    when you try to access mysql through docker container for the first time use a blank password as your default root password

    docker exec -it <container_id> -uroot -p

    then hit enter without providing a password.
    Works for me

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.

×
Submit an Answer
1 answer
ludoonline May 15, 2019

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.

Reply Report

Related

Looking for something else?

Ask a new question Search for more help