Got it thanks - "set-variable=old-passwords=1" in the ini file -----Original Message----- From: Randy Chrismon [mailto:[EMAIL PROTECTED] Sent: 31 January 2004 21:11 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: Re: Passwords and ODBC - what am I missing
Oh, and one other thing, you have to create the passwords AFTER you use the switch! That was probably obvious to you but it took me a while to figure out. Randy Randy Chrismon wrote: > Ken Brown wrote: > >> Just installed 4.1.1 on windows 2000 with current odbc layer >> >> Connects fine with root and no password >> >> But if I set a password on root or create a user with a password odbc >> fails >> with >> >> >> >> "Client does not support authentication protocol requested by the >> server - >> consider upgrading MYSql Client" >> >> >> >> So what have I done wrong? >> >> >> >> Ken >> >> >> >> > Ken: > > You will have to look up the exact switch in the MySQL manual but the > problem is that the OBDC driver is sending the "old" style password > hash to MySQL 4.1.1 which is expecting the new -- longer -- password > hash. You can easily find the switch by searching the MySQL > documentation at their site. > > Randy > -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ------------------------------------------------------------ Mail was checked for spam by the Freeware Edition of No Spam Today! The Freeware Edition is free for personal and non-commercial use. You can remove this notice by purchasing a full license! To order or to find out more please visit: http://www.no-spam-today.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]