Error while trying to connect to the database server: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

libresh / compose-matomo

Matomo docker-compose application for libre.sh-v1

GNU Affero General Public License v3.0

180 stars 65 forks source link

Error while trying to connect to the database server: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client #33

Closed lindsaymacvean closed 6 years ago

lindsaymacvean commented 6 years ago

I set up using the instructions on the Readme (including setting the mysql password) and was able to access the Piwik interface. When I tried to enter the details I got "Error while trying to connect to the database server: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client"

Google suggests looking at length of the password and version of PHP, tried changing password but still no luck. Not sure what to do next?

theadityapathak commented 6 years ago

facing same issue, did you get the solution?

lindsaymacvean commented 6 years ago

No luck. I ended up configuring a matomo container manually into my existing compose stack.

timEulitz commented 6 years ago

I have had the same issue. After looking into this, seems like the issue is an incompatibility with MySQL 8. I fixed this problem by specifying MySQL 5.7 as a required image in the docker-compose.yml in line 9:

image: mysql:5.7