Database access denied

[gktrainer]

Hi Alex!

I changed the configurations on env file, but when i execute the command "docker exec", i receive the message "Access denied for user 'magento'@'dockermagento2_web_1.dockermagento2_default' (using password: YES)".

I am a newbie on docker universe, and the solution can be simple, but i can't see this solution.

Best regards!

[alexcheng1982]

If you use the default settings, does it work or not?

…

On Thu, Dec 21, 2017 at 7:36 AM, Anderson Antonio Lopes Rodrigues < ***@***.***> wrote: Hi Alex! I changed the configurations on env file, but when i execute the command "docker exec", i receive the message "Access denied for user 'magento'@ 'dockermagento2_web_1.dockermagento2_default' (using password: YES)". I am a newbie on docker universe, and the solution can be simple, but i can't see this solution. Best regards! — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#10>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABHgEPPq7Zx7xbI94VfNgz_bf3rm6vspks5tCVObgaJpZM4RIy-D> .

-- Regards Alex Cheng

[gktrainer]

Hi Alex!

With MySQL default settings, it's worked!

Best Regards!

[alexcheng1982]

That may be a bug. Honestly, I never tested the case of using other password.

…

On 22 Dec 2017 03:14, "Anderson Antonio Lopes Rodrigues" < ***@***.***> wrote: Hi Alex! With MySQL default settings, it's worked! Best Regards! — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#10 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABHgEG4QpN4AVXqnrPOk5tbBxwBjiSBPks5tCme6gaJpZM4RIy-D> .

[gktrainer]

It's happens, do not worry. I'll use it for a proof of concept.

[alexcheng1982]

The problem is in the MySQL docker container. Its init script doesn't create the db user when the data directory exists. So if you have started the container using the default password, even after you changed the password settings in the env file, MySQL container still use the old password. You need to remove the data volume first using docker volume rm, then start Docker compose again. You can check the output of MySQL container to verify whether it creates new user or not.

[taqvi]

Is there a docker command to remove all volumes at once ?