#1251 Errors

[sullise]

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client


Have users getting these. Our da_admin password works correctly, so not the grant problem that we can tell. Any thoughts?

 

[Mik3yZ]

newer versions of mysql user a new password encoding... and most older clients don't support this.

you can have a look at this page on how to solve the problem:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

There is also something else you can do:

- update to PHP 5
- use the mysqli extension (http://nl2.php.net/manual/nl/ref.mysqli.php)

- Mike

 

[sullise]

I'm aware of that. I've ran the appropriate fixes for the da_admin password, etc. But how do we fix the users moving from other servers?

 

[DirectAdmin Support]

Hello,

The usually happens when php is compiled with the 3.x mysql client instead of the installed version of mysql client.

To check, create an info.php with the contents:

<? phpinfo(); ?>

then view it through apache. About 3/4 down the page is the mysql section, which should show you what version of mysql client is isntalled into php. Optimally, it should match the version of mysql you have installed.

Possible causes for not having the correct version, check your:
/usr/local/directadmin/customapache/configure.php
file. It should have either:
--with-mysql=/usr \
or
--with-mysql=/usr/local \
depending on your system. (redhats first, debian/freebsd 2nd version).

If you only have:
--with-mysql \

then it will be including the built in client libs that come with php, which are for mysql 3 (old).

If you've updated your configure.php, the recompile php with:

cd /usr/local/directadmin/customapache
./build clean
./build php n

Another possible reason might be the lack of a MySQL-shared rpm. Type:

rpm -qa  | grep MySQL

.. it should show 4 rpms: MySQL-server, MySQL-client, MySQL-devel and MySQL-shared. All 4 rpms must also be using the same version.

We have rpms available on our files server if you need:
http://files.directadmin.com/services/all/mysql/
or get them from dev.mysql.com as well, if you need other versions. After updating your mysql rpms, recompile php (see above)

John

 

[sullise]

Thanks, John, all fixed.