How to open a Mysql server to connect with client PC?

#1

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 (AT) mathstat (DOT) uottawa.ca>
To: <perl (AT) lists (DOT) mysql.com>
Sent: Wednesday, December 03, 2003 12:18 AM
Subject: can DBD::mysql handle the new mysql-4.1.0 authentication method?

Quote:

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=ls... gsfc.nasa.gov

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to open a Mysql server to connect with client PC?

mailing.database.msql-mysql-modules mailing.database.msql-mysql-modules

How to open a Mysql server to connect with client PC? - 12-03-2003 , 07:39 AM