Re: help with mysql connect error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tim McGeary wrote:
Oh, duh!  Ok.  I wrote this:

<?php
        $hostname = "localhost";
        $username = "softread";
        $password = "XXXXXXX";
        $dbname = "software";

mysql_connect($hostname, $username, $password) or die(mysql_error());
        mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT * FROM Requestor_type") or die(mysql_error());
        while($row = mysql_fetch_array( $result )) {
echo '<input name="requestor_type" type="radio" value="'.$row['description'].'">'.$row['description']."&nbsp;";
        }
?>

And got this as output:

<br />
<b>Warning</b>: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in <b>/var/www/html/mysql_test.php</b> on line <b>7</b><br /> Client does not support authentication protocol requested by server; consider upgrading MySQL client

I'm not sure I understand it. Maybe my CLI PHP script is not correct? I'm returning to PHP after 5 years of not writing in it.

This basically means that you're trying to access a MySQL 5 server with MySQL 4 client. You have two choices...

1) Rebuild PHP with the MySQL 5 client libs
2) Use the old password mechanism in MySQL

See here for more info...

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

-Stut

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux