MySQL Forums
Forum List  »  Perl

Re: Net::MySQL error
Posted by: krisodb
Date: September 12, 2006 02:21AM

I've got a simular problem.
Installed MySQL 5.0.21.
Through phpMyAdmin I created a user, database and table.
If I now try to write something with Net::MySQL in the table I get the same error.

If I want to read something I get a message: "08S01 Bad handshake" as response.
Logging in itself is not a problem.
Perl version: v5.8.7 built for x86_64-linux-thread-multi
Basic script:
#!/usr/bin/perl -w

use strict;
use Net::MySQL;
my $mysql = Net::MySQL->new(
hostname => '10.0.0.3',
database => 'test',
user => 'test',
password => 'abc123',
debug => '1',
);
$mysql->query(q{
INSERT INTO foo (id, message) VALUES (2, 'Hello World')
});

Options: ReplyQuote


Subject
Written By
Posted
June 16, 2006 11:20AM
June 16, 2006 05:23PM
Re: Net::MySQL error
September 12, 2006 02:21AM
September 12, 2006 08:17AM
September 13, 2006 03:36AM
September 13, 2006 05:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.