how to find out server name of mySQL

xinyi

I had been trying to connect to mySQL using php, but i have this error code

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Program Files\Apache Group\Apache2\htdocs\connect.php on line 13
Error connecting to mysql

But i do not have any idea where went wrong..

Anyone knows?

thanks

bpat1434

So what is your code? What does it look like?

~Brett

xinyi

my code for connect look like this :

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '4D0DD2673C1DE57138354E81A957460B774C4BC2';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die

('Error connecting to mysql');

$dbname = 'test';
mysql_select_db($dbname);
?>

Sxooter

Sounds like you're trying to use a 3.x client against a 4.x/5.x server.

Won't work. The error message is telling you to upgrade whatever client you're using. I.e. you need to be using the 4.x and above client modules.

xinyi

Is client referring to php?
So i must change the php verison ?
Currently i am using php verison 4.3, which verison is recommended to the server i am using?

DoctorWho

I just switched to the Old Password stuff myself. But you need not do that, there are other options.

Yeah it's just more BS you have to deal with when upgrading.

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

*

  Tell the server to use the older password hashing algorithm:
     1.

        Start mysqld with the --old-passwords option.
     2.

        Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:

mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;

        For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.

PHP-
Note: In older versions of PHP, the mysql extension does not support the authentication protocol in MySQL 4.1.1 and higher. This is true regardless of the PHP version being used. If you wish to use the mysql extension with MySQL 4.1 or newer, you may need to follow one of the options discussed above for configuring MySQL to work with old clients. The mysqli extension (stands for "MySQL, Improved"; added in PHP 5) is compatible with the improved password hashing employed in MySQL 4.1 and higher, and no special configuration of MySQL need be done in order to use this MySQL client library. For more information about the mysqli extension, see http://php.net/mysqli.