Installation Error - MySQL

Silverstripe Version: Version 4.1.0

Question:

Trying to install using php7, mysql community 8.0.1 and apache 2.4 on Windows 10

I get the following error when using MySQL PDO:

I couldn’t find a database server on ‘127.0.0.1:3306’: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

I get the following error when I use MySQLi:

I couldn't find a database server on  '127.0.0.1:3306': The server requested authentication method unknown to the client

Tried looking for a similar error on these forums for at least 20 minutes, no joy.

Help?

Did you find a solution to this? I’m guessing that your 8.x install doesn’t have the right password authentication methods configured. Have you tried with an earlier version of MySQL ? (5.7 should work out of the box)