Pardon my jumping into the middle of this thread without reading the
previous, but this problem is well-documented (check google). With MySQL
4.1, you can't connect using DBI. The authentication method changed and
the DBD::MySQL module hasn't caught up yet. I went through this a couple
of weeks ago. The fix is to create a password using the OLD_PASSWORD
function. I'm looking at a note on the mysql site that indicates
DBD-mysql-2.9004 may support the new password hashing, but I wasn't able
to get it to work. OLD_PASSWORD worked for me.
HTH,
Dave
On Dec 2, Hardy Merrill scribed:
> Michael, note here that it's been years since I used MySQL, but I think
> I remember MySQL authentication being "host" based. That's not the
> right term, but connecting locally with mysql user "user1" is *NOT* the
> same as connecting remotely to the same server with mysql user "user1".
> There is a way to specify on the server that you want to allow remote
> connections as "user1" - as I remember it is very flexible in the way
> that it allows you to specify a specific IP address to allow from, or a
> portion (subnet) of an IP address, etc.
>
> Sorry I can't be more help. Without my "MySQL" book by Paul Dubois I
> can't get any more specific. If you don't have a book, go to the MySQL
> website and read up authentication.
>
> HTH.
>
> Hardy Merrill
>
> >>> "Michael David" <[EMAIL PROTECTED]> 12/02/04 12:06AM
> >>>
> Hello,
>
> I have a script that is connecting to two different databases , one is
> local
> and the other remote.
> The local Informix DBI connection works a treat but I am having trouble
>
> getting the remote mysql connection to work.
>
> I keep get error: Client does not support authentication protocol
> requested
> by server.
> I have checked and upgraded, and now both local and remote machines are
>
> running mysql 4.1, and the same client.
> I have also checked and the mysql port is open on the remote server.
>
> All the search results I could find regarding this error said to
> upgrade the
> the mysql server, which I have done and now
> there should be no protocol barriers since they are running the same
> version.....
>
> Does anyone have any ideas what may be causing this error other than
> different versions of the server. Or probably even better, some
> instructions
> on how to really "turn up" or "tweak" my dbh debugging so that I can
> get
> more details on the failed connection attempt.
>
> this is my connection statement:
> my $db2 = "dbname";
> my $dbhMysql = DBI->connect("DBI:mysql:$db2:xxx.xxx.xxx.xxx", 'uname',
>
> 'pword') || die print "Could not connect to database($db2): $!\n";
> this being the same as my local connection (minus the host IP address)
> which
> does work.
>
>
> Thanks,
> mike
>
