MySQL database access denied

koel / docker

A minimal docker image for the koel music streaming server.

https://hub.docker.com/r/phanan/koel/

MIT License

178 stars 54 forks source link

MySQL database access denied #128

Closed xeruf closed 2 years ago

xeruf commented 2 years ago

After having no success with postgres I now tried mysql, but despite MYSQL_USER and PASSWORD being the same as the DB values for koel in docker-compose.mysql.yml, koel is unable to access the mysql database in the container:

SQLSTATE[HY000] [1045] Access denied for user 'koel'@'172.19.0.3' (using password: YES)

I have recreated the containers multiple times, and have no idea how to debug this...

xeruf commented 2 years ago

Solved, I did not recreate the containers fully as their volumes were kept... https://stackoverflow.com/a/59839180/6723250

Hyzual commented 2 years ago

Hi @xeruf glad you found out the solution, thanks for posting it back here :) Indeed volumes will keep the database configuration including users and passwords.