Can't Connect to MySQL Server with PHP


#1

I am running MySQL 8.011 and PHP 7.2.6 on Fedora 28 Linux. I tried PHP to connect to the server with the usual command:

$conn = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die('Could not connect to MySQL: ’ . mysqli_connect_error() );

and got the error message:

“Could not connect to MySQL: The server requested authentication method unknown to the client”

The values of DB_HOST, etc are correct and they work when I connect to the server from the command line.

I tried changing default-authentication-plugin to mysql_native_password in my.cnf and restarting the server but I got the same error message.

Your help will be much appreciated. Thank you, JoeH


#2

Check here,


#3

Try removing the @ in your connection. That suppresses some error messages. You might get more info in the error message. (Sometimes it does not change the message, sometimes it logs an error on the server instead of displaying it.)

Might help debugging.