Jamie: I don't think your problem has anything to do with version 5.0 ... though there have been some enhancements in security and user privs, the fundamentals (IMHO) have not changed.
The problem is most likely with the application itself ... it needs to pass the user ID and password, and the user ID needs to have been granted the correct privs. G. R. Jensen ----- Original Message ----- From: "jamie murray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, January 04, 2004 9:22 AM Subject: mysql 5.0 Hi guys, I posted a similar question on this the other day but received no answers. I'm running 5.0 and have a possible security/password problem. If i run from command line all users work with or without passwords. If I try and connect to mysql through php,perl,python or odbc with a user that has a password I get "client authentication protocol error". If I connect with any of the above with a user who has no password everything works fine. Does this have to do with 5.0 change to the password hash. If you have advice to offer it would be greatly appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
