MySQL setup

[ironfoot495]

Installed MySQL ver 5.0 (latest) and kept getting errors so went back and installed ver 4.1 and still get same errors.

They occur when calling the DB via PHP using mysql_connect and are:

Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client,

Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client

and

Warning: MySQL Connection Failed: Host '192.168.6.80' is not allowed to connect to this MySQL server

Having difficulty finding things on the net that address config issues with MySQL. Can run the DB doing the following:

Start + All Programs + MySQL ... MySQL Command Line Client

However when I go to the command line and try to run mysqld it never recognizes >>localhost<<, >>computer name<< or any other host I give it.

I think this is where my problem is in the mysql_connect connect string, but not sure.

All ideas and help are appreciated!!


CMA

 

[dodge20]

Sounds like a password hashing problem

mysql> use mysql;

mysql> SET PASSWORD FOR 'username'@'hostname' = OLD_PASSWORD('password');

mysql> FLUSH PRIVILEGES;


where username is your mysql user that you're trying to connect as, hostname is the host (probably localhost in your case) and the last 'password' is the password you wish your user to use.

This will revert the password back to the older algorithm and should allow php to connect again. To force new accounts to be made with the old style passwords, you can edit /etc/my.cnf and add "old-passwords" as an option under the [mysqld] section and restart mysql...

Dodge20