RE: MySQL version

Does anyone know how to upgrade the client of a MYSQL server.  

I am running php  4.3.4 with mysql 5.  When I attempt to access the database
on the local machine I receive the following error message. 
"Client does not support authentication protocol requested by server;
consider upgrading MySQL client"  

I am not sure how to resolve this. 

The error is generated in response to this simple connection, " 
$db = mysql_connect('dvdserver', $username,$password) or die(mysql_error());


-----Original Message-----
From: Steve Edberg [mailto:[email protected]] 
Sent: Friday, May 25, 2007 16:16
To: Mikhail Berman; [email protected]
Subject: Re: MySQL version

At 3:19 PM -0400 5/25/07, Mikhail Berman wrote:
>Hi everyone,
>
>Is there a way to see in what version of MySQL a table was created?
>
>Your help is greatly appreciated,
>
>Mikhail Berman
>Ives Group
>(508)476-3257 - primary
>(508)476-7007 ext.242 - secondary
>[email protected] <mailto:[email protected]>


You can check the table creation time, engine type and version using the

	show table status like 'table-name';

command; I don't know how closely the database engine version corresponds to
the MySQL version (Eg; I created a MyISAM table this January using MySQL
5.0.15; the version number reported was 10). You could make a guess at the
likely database version using the table creation date.

	steve

-- 
+--------------- my people are the people of the dessert, 
+---------------+
| Steve Edberg                                http://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center                            [email protected] |
| Bioinformatics programming/database/sysadmin             (530)754-9127 |
+---------------- said t e lawrence, picking up his fork 
+----------------+

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/[email protected]




-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]