I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been
running into a problem. When I was running 4.0 the passwords with the
password('password') command where being created like this:
2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the
passwords end up being like this: *A645B7228E54A58C02488027D2FBD96853E7BF8B
When I connect via the command line everything is peachy but when I
connect via PHP I kept getting this error:
*Warning*: mysql_connect() [function.mysql-connect
<http://karma.detroitonline.com/function.mysql-connect>]: Client does
not support authentication protocol requested by server; consider
upgrading MySQL client in */usr/local/vps/karma/apache/htdocs/test.php*
on line *3*
Client does not support authentication protocol requested by server;
consider upgrading MySQL client
So I upgraded to 5.0 and I'm still seeing long passwords and I'm still
getting this error with PHP...can anyone tell me what's going on here? I
upgraded another server to 5.0 and I didn't see this problem at all. I'm
a little screwed right now because this server is replacing one that had
to come out of service due to a bad harddrive and now clients can't make
connections anymore with their scripts. The old server was running
4.0....it's looking like I might have to downgrade until this is fixed...
any help would be greatly appreciated
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
