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']." ";
}
?>
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
