SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

I am attempting to install Piwik for the first time and have received the following error when creating the database using PDO/MYSQL:


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


I also receive this when using MYSQLI:


Error while trying to connect to the database server:
The server requested authentication method unknown to the client


How do I fix this?

  • M