Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
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

RE: Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
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

Re: Passwords and ODBC - what am I missing

2004-01-31 Thread Randy Chrismon
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

Re: Passwords and ODBC - what am I missing

2004-01-31 Thread Randy Chrismon
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

RE: Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
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