Bug 991070

Description of problem:

I installed MariaDB on a Fedora 19 system recently and I cannot connect to it using PHP scripts.  Both existing users from a previous upgrade, and users I newly create are not available to the PHP script.  The mysql_connect() function returns "The server requested authentication method umknown to the client" (note the mis-spelling).

Note that the same 
Version-Release number of selected component (if applicable):

php-5.5.0-2.fc19.x86_64
php-mysqlnd-5.5.0-2.fc19.x86_64
mariadb-5.5.31-4.fc19.x86_64

How reproducible:

Always

Steps to Reproduce:
1. start up a MariaDB instance
2. create a new user
3. connect using e.g. mysql or Python
4. connect using 'php -a'

Actual results:

Other connect methods (mysql, python-MySQL) work correctly. PHP is unable to connect.

Expected results:


Additional info:

Here is a sample session:

MariaDB [(none)]> create user 'testuser'@'localhost' identified by 'testpass';
MariaDB [(none)]> select * from mysql.user where User LIKE 'testuser' \G
  *************************** 1. row ***************************
                        Host: localhost
                        User: testuser
                    Password: 7dcda0d57290b453
...
         max_connections: 0
        max_user_connections: 0
                      plugin:
       authentication_string:
      1 row in set (0.00 sec)

 $ mysql -utestuser -ptestpass

      MariaDB [(none)]> select 1;
      +---+
      | 1 |
      +---+
      | 1 |
      +---+
      1 row in set (0.00 sec)

 $ php -a
      php > $link = @mysql_connect("localhost", "testuser", "testpass");
      $link = @mysql_connect("localhost", "testuser", "testpass");
      php > print $link;
      print $link;
      php > print mysql_error();
      print mysql_error();
      The server requested authentication method umknown to the client
      php >

I'm attaching the output of 'show global variables'; see there that I turned off secure_auth and turned on old_passwords.  The "new" passwords (41 character hashes) also do not work with PHP.