Problems with Net::MySQL on OS X Server

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I'm trying to port a web-based application from a Solaris 2.6 box to
Mac OS X Server 10.4.8.

The Solaris box was running perl 5.6.1 and MySQL 4.0.18, the OS X box
is running perl 5.6.2 and MySQL 4.0.18. Both are running Net::MySQL
0.009. The trouble is, the Solaris box will connect successfully to the
MySQL DB but the OS X box will not.

This is the code:

#!/usr/bin/perl -w
use Net::MySQL;

my $mysql = Net::MySQL->new(
database => 'mysql',
user => 'root',
password => '*'

# SLECT example
$mysql->query(q{SELECT * FROM user});
my $record_set = $mysql->create_record_iterator;
while (my $record = $record_set->each) {
printf "First column: %s Next column: %s\n",
$record->[0], $record->[1];

And this is the error it yields:

[root@csc-web2 admin]# perl
Access denied for user: '@localhost' to database '!' at line 5

I am pretty new to perl, so I'm not quite sure how to debug this. The
username and password are definitely correct, but the most troubling
thing is that the error message says that the perl file is trying to
connect to the database named '!', not the database named 'mysql'.
Anyone have any ideas on how I can debug this?



Re: Problems with Net::MySQL on OS X Server wrote:

Quoted text here. Click to load it

Huh? Mac OS 10.4 comes with Perl 5.8.6. Somebody downgraded it?

Tom Wyant

Re: Problems with Net::MySQL on OS X Server

harryfmudd [AT] comcast [DOT] net wrote:
Quoted text here. Click to load it

I downgraded it... well, actually, I just compiled it and installed it
in /usr/local/perl/. Because I'm not the author of the original web
app, I want to try and replicate its environment as much as possible
when I'm porting it.

After I actually get it working, I'll try using perl-5.8.6 against it.
In the meantime, though, I am getting nowhere :-\ FWIW, I've installed
Net::MySQL under 5.8.6 and still haven't had any success.


Site Timeline