MySQL issue

aisikowi

I've installed php 4x on IIS.
Whenever I try to open the database I get the following message :

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\Projects\ManagementSystem\Menu.php on line 6
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

anybody?

Roger_Ramjet

NTFS file system properties error. Script is an anonymous user and so the directory where the mysql database files are stored needs to have its NTFS filesystem properties set to EVERYONE Allow Full Control. The protocol that is tripping you up is Windows Authentication. Always a problem with IIS as NTFS overrides IIS settings.

aisikowi

so what can be done about it?

I have changes the security properties of the MySQL library to allow full access to everyone' and still the same message.

Roger_Ramjet

Not the library, the actual data files. Depending on IIS version you are into Kerebos, NTLM, etc, and only with IE. Basically MS have it set up that IIS works with ASP and IE on an Intranet and is a pig to anyone else. The problem is that even though you have Mysql set up to run as a Windows user of some sort, IIS automatically works as an anonymous user with no windows authentication going on, except on an Intranet where you can use Integrated Windows Authentication.

Find your mysql data files directory in Windows Explorer and open them up to the world by right-click the directory->properties->security tab->advanced and add EVERYONE with Full Control, make sure you check 'apply to subfolders and files'

aisikowi

i did it and still nothing.

do you anything else in mind?

Roger_Ramjet

Sorry no. Are you still getting the same error message about auth protocol?
I'd go to msdn and search the knowledge base and forums for assistance there.

bradgrafelman

This error sounds like you're using the MySQL extension to connect to a MySQL server version 4.1+. As of MySQL 4.1, there is a new password hashing algorithm, among many other things. As such, a new client library is needed in order to connect and communicate with MySQL servers running versions 4.1 or higher.

Try using the [man]MySQLi[/man] extension, installing the latest MySQL 4.0 version, or by doing this:

Open up the my.ini file (e.g. C:\Program Files\MySQL\MySQL Server 5.0\my.ini for me).
Find the '[mysqld]' section, and directly under it add "old_passwords=1".
Login to your SQL server using the CLI (e.g. C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe for me)

Issue the following command:

SET PASSWORD FOR root@localhost = OLD_PASSWORD('root_password_here');

Restart the MySQL server
Change the passwords for all users on your server. You can "change" it to the same password, but what you're doing is updating the password field in the MySQL privileges table, except now that MySQL was started with the "old_passwords" flag, it is using the old password hashing algorithm allowing older client libraries (e.g. the MySQL extension) to connect.