Edit report at https://bugs.php.net/bug.php?id=60844&edit=1
ID: 60844 Updated by: johan...@php.net Reported by: FM_Silver at gmx dot de Summary: mysqlnd does not work with non-native pluggable authentication -Status: Open +Status: Bogus Type: Feature/Change Request Package: MySQL related Operating System: Debian 6.0.3 PHP Version: 5.3.9 Block user comment: N Private report: N New Comment: Pluggable authentication support was added to PHP 5.4. The auth_socket plugin works there: mysql> CREATE USER 'johannes'@'localhost' IDENTIFIED WITH auth_socket; mysql> exit $ whoami johannes $ php54 -r '$mysqli = new mysqli("localhost", "johannes", "", "test", 0, "/tmp/mysql55.sock"); echo $mysqli->query("show grants")->fetch_row()[0];' GRANT USAGE ON *.* TO 'johannes'@'localhost' Previous Comments: ------------------------------------------------------------------------ [2012-01-23 01:00:16] FM_Silver at gmx dot de Description: ------------ Using mysql 5.5.19, loaded auth_socket plugin and created a user to auth with it: mysql> INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; mysql> CREATE USER 'someuser'@'localhost' IDENTIFIED WITH auth_socket; Also assume an existing database 'website'. Trying to auth with user someuser works, when using the mysql client, but fails with mysqlnd as shown below. Test script: --------------- <?php $mysqli = new mysqli("localhost", "someuser", "", "website"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } printf("Host information: %s\n", $mysqli->host_info); $mysqli->close(); ?> Expected result: ---------------- Host information: Localhost via UNIX socket Actual result: -------------- PHP Warning: mysqli::mysqli(): (08004/1251): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/someuser/mysql.php on line 2 PHP Stack trace: PHP 1. {main}() /home/someuser/mysql.php:0 PHP 2. mysqli->mysqli() /home/someuser/mysql.php:2 Connect failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=60844&edit=1