Enter mysql is error

[sasuke6]

When I enter the mysql container docker exec -it docker_mysql_1 bash,there is no problem.But if I enter the mysql,there is ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).
When I use mysql -u root -p,there is ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
What is the initial password and how to reset it quickly?

[Mahmoudz]

As you can see from the MySQL Dockerfile we barely modify the original image, however if you need a quick solution, I advice you google this problem as if it's heppening on the original MySQL docker image. And I will try to reproduce this error and investigate it during the next week. I really hope someone can debug it and help you soon.

[Mahmoudz]

@sasuke6 Hi again, I found a reason today to work on this project and I tried to reproduce your error.
It's not actual bug you just need to provide some info for MySQL in the command, so try running this command, it should work:

mysql --user=homestead --password=secret homestead

You can find the username and password in the docker-compose.yml file:

        environment:
            MYSQL_DATABASE: homestead
            MYSQL_USER: homestead
            MYSQL_PASSWORD: secret
            MYSQL_ROOT_PASSWORD: root

[sasuke6]

Thanks a lot!

[jakelacey2012]

Hi I had this issue, this fixed it for me.

I'm just wondering if this happens every time for every developer? If so could we add this to the documentation?

[Mahmoudz]

@jakelacey2012 if you feel it needs to be documented, please go ahead and create a new section in the readme about MySQL (example: Use MySQL) and then show all the tips such as how to ssh into that container docker-compose exec mysql bash and how to login to MySQL and see the tables.. show database; use homestead;... Also show some tips on how to access the DB using tools such as Sequel Pro... Just start it and other folks will continue.
Thanks.

[saumya04]

@Mahmoudz How can I change my mysql password. I've tried changing the password from docker-compose.yml file but the changes doesn't seems to be reflected. Can you help me with it.

[appleboy]

@saumya04 Delete your container and rebuild again.

$ docker-compose down
$ docker-compose up

[saumya04]

@appleboy I've tried that already, its not working yet!

[eperiou]

I found this command on another question, related to this topic. Supposedly it deletes the data that normally isn't deleted by deleting the old containers and images

docker-compose rm -v

[francoism90]

This still happens to me, it doesn't update the root password set in docker-compose.xml

[eperiou]

Yes, this is because the mysql image creates a volume storing the password, so it needs to be deleted in the event that everything was not set up correctly the first time you composed.
use
docker volume ls
and you can find it and delete it or:
docker-compose rm -v
to remove the volumes created by the docker-compose before composing again