search

alexcheng1982 / docker-magento2

Docker image for Magento Open Source 2
MIT License
382 stars 256 forks source link

Database access denied #10

Closed gktrainer closed 6 years ago

gktrainer commented 6 years ago

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 commented 6 years ago

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

On Thu, Dec 21, 2017 at 7:36 AM, Anderson Antonio Lopes Rodrigues < notifications@github.com> 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 https://github.com/alexcheng1982/docker-magento2/issues/10, or mute the thread https://github.com/notifications/unsubscribe-auth/ABHgEPPq7Zx7xbI94VfNgz_bf3rm6vspks5tCVObgaJpZM4RIy-D .

-- Regards Alex Cheng

gktrainer commented 6 years ago

Hi Alex!

With MySQL default settings, it's worked!

Best Regards!

alexcheng1982 commented 6 years ago

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" < notifications@github.com> 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 https://github.com/alexcheng1982/docker-magento2/issues/10#issuecomment-353360904, or mute the thread https://github.com/notifications/unsubscribe-auth/ABHgEG4QpN4AVXqnrPOk5tbBxwBjiSBPks5tCme6gaJpZM4RIy-D .

gktrainer commented 6 years ago

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

alexcheng1982 commented 6 years ago

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 commented 5 years ago

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