MySQL Login Problems on 4.1
Hi guys! I am facing some problems trying to login user to the data base server using --any-- client(except the mysql cli) to the server. Users using no password does not seems to have any problems. It happens that when a client tries to log into the db server using passwords the server doesn't seems to authorize. Even the most recent MyCC client fails to autorize users using passwords. Do I need to compile the clients against the new server's library? The MyCC client was linked againts the 4.0.16 server. was there any change in the auth-protocol? Best Regards -- .. * _ _ __ __ .. * \ \ \ | | __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | || | / \|_| || www.superferreteria.com.ve * /_/_/ |__|_| /_/\_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Login Problems on 4.1
At 14:42 -0400 12/12/03, Victor Medina wrote: Hi guys! I am facing some problems trying to login user to the data base server using --any-- client(except the mysql cli) to the server. Users using no password does not seems to have any problems. It happens that when a client tries to log into the db server using passwords the server doesn't seems to authorize. Even the most recent MyCC client fails to autorize users using passwords. Do I need to compile the clients against the new server's library? The MyCC client was linked againts the 4.0.16 server. was there any change in the auth-protocol? Indeed there was. This is mentioned in the upgrading to 4.1 section in the manual. Some links you may want to check out: http://www.mysql.com/doc/en/Upgrading-from-4.0.html http://www.mysql.com/doc/en/Upgrading-grant-tables.html http://www.mysql.com/doc/en/Password_hashing.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Login Problems on 4.1
At 14:42 -0400 12/12/03, Victor Medina wrote: It happens that when a client tries to log into the db server using passwords the server doesn't seems to authorize. Even the most recent MyCC client fails to autorize users using passwords. Do I need to compile the clients against the new server's library? The MyCC client was linked againts the 4.0.16 server. was there any change in the auth-protocol? 4.1 changed the authentication code. You can tell mysqld to use the old authentication by starting it with the --old-passwords option (or add old-passwords to the [mysqld] group in my.cnf). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]