Req #60844 [NEW]: mysqlnd does not work with non-native pluggable authentication

From: Operating system: Debian 6.0.3 PHP version: 5.3.9 Package: MySQL related Bug Type: Feature/Change Request Bug description:mysqlnd does not work with non-native pluggable authentication 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 bug report at https://bugs.php.net/bug.php?id=60844&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=60844&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=60844&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=60844&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=60844&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=60844&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=60844&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=60844&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=60844&r=needscript Try newer version: https://bugs.php.net/fix.php?id=60844&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=60844&r=support Expected behavior: https://bugs.php.net/fix.php?id=60844&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=60844&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=60844&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=60844&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=60844&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=60844&r=dst IIS Stability: https://bugs.php.net/fix.php?id=60844&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=60844&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=60844&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=60844&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=60844&r=mysqlcfg