Passwords and ODBC - what am I missing
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
RE: Passwords and ODBC - what am I missing
I've did some more checking - I cannot set passwords anywhere (that is if I want to connect with the account) There are no logs as to why its not working. I can only presume 4.1.1 is in the middle of a security overhaul and that's why its now working here but perhaps someone could advise otherwise - or at the very least how to switch on a security log Ken -Original Message- From: Ken Brown [mailto:[EMAIL PROTECTED] Sent: 31 January 2004 15:56 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Passwords and ODBC - what am I missing 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Passwords and ODBC - what am I missing
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Passwords and ODBC - what am I missing
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]
