Re: Still problem with MyODBC :((
I will say it AGAIN :-(
The ODBC drivers (your client if you go through them to access the
database) ARE NOT 4.1+ CLIENTS. The most recent version shows that they
are 3.xx.xx drivers which means that you are using a pre-4.1 client to
access a post 4.1 server. The articles you read describe how to do permit
this kind of access.
I think the easiest work-around is to change the password on the account
you use with the ODBC drivers. Assuming you are connecting with the
account odbcuser and the password fixme you would need a statement
like:
update mysql.user set password = OLD_PASSWORD('fixme') where user =
'odbcuser';
Then you will be able to authenticate.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Danesh Daroui [EMAIL PROTECTED] wrote on 09/11/2004 06:24:17 AM:
Hi all,
I have still problem with MyODBC. When I want to connect to my
Database server which is a Linux machine, it returns an error:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client
I visited MySQL documents but the suggestions were about when a
version prior to 4.1 attempts to connect to a server which runs
MySQL version 4.1 or newer, but this is not my case. Because, both
my client and server use same version of MySQL and they use MySQL
version 4.1 not older releases. Can anyone help ? :((
Yours,
Danesh Daroui
Re: Still problem with MyODBC :((
Danesh Daroui wrote: Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about when a version prior to 4.1 attempts to connect to a server which runs MySQL version 4.1 or newer, but this is not my case. Because, both my client and server use same version of MySQL and they use MySQL version 4.1 not older releases. Can anyone help ? :(( Yours, Danesh Daroui If you are using MyODBC, then the suggestions regarding a 'client prior to 4.1' *DO* apply to you. MyODBC is built against 4.0.x, so you must follow the instructions for connecting with a pre-4.1 client. Either that or downgrade the server to 4.0.x. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Still problem with MyODBC :((
Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about when a version prior to 4.1 attempts to connect to a server which runs MySQL version 4.1 or newer, but this is not my case. Because, both my client and server use same version of MySQL and they use MySQL version 4.1 not older releases. Can anyone help ? :(( Yours, Danesh Daroui
