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.
Problem Connecting to MySQL Server with PHP
in PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition)
Posted
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.