[RESOLVED] MYSQL5.0 PROBLEM with php4.4.7

[kheius]

Hi i successfully installed mysql 5.0 with mysql admin but when i execute a test page if sql is working the only text that appear is

"
Unable to connect to database manager.

Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[laserlight]

What was your test page?

[kheius]

Here

<?PHP
//remember to change the password to whatever you set
//it to in mysql instance configuration

//first parameter is server name, 2nd username 'root', 3rd is password
$rst = @mysql_connect("localhost","root","root");

if (!$rst){
echo( "<p>Unable to connect to database manager.</p>");
die('Could not connect: ' . mysql_error());
exit();
} else {
echo("<p>Successfully Connected to MySQL Database Manager!</p>");
}

if (! @mysql_select_db("mysql") ){
echo( "<p>Unable to connect database...</p>");
exit();
} else {
echo("<p>Successfully Connected to Database 'MYSQL'!</p>");
}
?>

[kheius]

i have local host as my serverhost and root as my username and root as my password 😃

[laserlight]

Oh, I see now. Read the PHP Manual on the MySQL Functions and you will find:

PHP 5+

MySQL is not enabled by default, nor is the MySQL library bundled with PHP.

If you can use PHP 5.2.3, you could well use the MySQLi extension instead, or perhaps the PDO extension.

[kheius]

oh do you know how can i run it for php 4 because only php 4 is required in our school 😃

[laserlight]

heheh, I saw PHP 5+ as "MySQL 5+", so what I wrote earlier is wrong.

I am afraid that I do not know how else to proceed, though I can suggest downgrading MySQL to see if it makes a difference.

[kheius]

i see thanks i just try downgrade my sql 🙂

[bradgrafelman]

No need to downgrade MySQL, just open up your my.cnf/my.ini file, find the [mysqld] section, and add this underneath it:

old_passwords=1

After restarting your server, login via the CLI and execute this command:

SET PASSWORD FOR root@localhost = PASSWORD('your_pass_here');

Also note that you'll need to update the passwords for any previously-created users if you want PHP4 to use those accounts.

Basically, what you're doing is disabling the new hashing algorithm that was implemented into the login protocol as of MySQL 4.1. Then, the SET PASSWORD commands update the user table with differente hashes, because the PASSWORD() command now uses the old hasing algorithm.

EDIT: Besides, if you were going to the extreme of using different versions, I'd recommend upgrading PHP before I recommended downgraded MySQL.