MySQL Lists are EOL. Please join:

List:MySQL and Perl« Previous MessageNext Message »
From:lshen Date:December 3 2003 1:39pm
Subject:How to open a Mysql server to connect with client PC?
View as plain text  
I am trying to get connect my mysql (in linux) server to my Navicat mysql
client (from PC). But it always come with a error - 'not allow to connect to
the mysql server' . Dose anyone know what happen?

Brian
----- Original Message ----- 
From: "Peter Selinger" <selinger@stripped>
To: <perl@stripped>
Sent: Wednesday, December 03, 2003 12:18 AM
Subject: can DBD::mysql handle the new mysql-4.1.0 authentication method?


> Hi,
>
> according to its changelog, mysql 4.1.0 introduced a "New more secure
> client authentication based on 45-byte passwords in the user table."
>
> I am dealing with a server which accepts *only* this new
> authentication method; all old methods have been disabled because they
> were not secure (unencrypted password was sent over the network, as
> far as I know).
>
> My problem is: I cannot get DBI / DBD::mysql to use this new method. I
> have upgraded everything to the newest version, and I still get this
> error message:
>
> DBI connect('database=xxxx;host=yyyy,'zzzz',...) failed: Client does
> not support authentication protocol requested by server. Consider
> upgrading MySQL client at ./test.pl line 8
>
> Can anyone tell me whether this new authentication method is supported
> by DBD::mysql, and if yes, what I need to do to get it to work? Or if
> it is going to be supported in the future? Or where I can locate the
> source code, libraries, protocol specs, or whatever is needed to fix
> this myself? I could not find the documentation of the MySQL
> client/server authentication protocol anywhere.
>
> Presumably many users don't have this problem because their client
> will simply fall back to some older method, if it is still enabled.
>
> Thanks, -- Peter
>
> -- 
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=1
>
>

Thread
can DBD::mysql handle the new mysql-4.1.0 authentication method?Peter Selinger3 Dec
  • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Jochen Wiedmann3 Dec
    • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Peter Selinger3 Dec
      • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Jochen Wiedmann3 Dec
      • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Rudy Lippan3 Dec
        • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Peter Selinger3 Dec
          • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Rudy Lippan4 Dec
            • Re: can DBD::mysql handle the new mysql-4.1.0 authentication method?Peter Selinger17 Jan
  • How to open a Mysql server to connect with client PC?lshen3 Dec