Problems with Net::MySQL on OS X Server
- From: chriswaltham@xxxxxxxxx
- Date: 10 Nov 2006 16:01:45 -0800
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];
}
$mysql->close;
And this is the error it yields:
[root@csc-web2 admin]# perl test.pl
Access denied for user: '@localhost' to database '!' at test.pl 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?
Thanks,
Chris
.
- Follow-Ups:
- Re: Problems with Net::MySQL on OS X Server
- From: harryfmudd [AT] comcast [DOT] net
- Re: Problems with Net::MySQL on OS X Server
- Prev by Date: Re: building GD using a locally-installed libgd (old libgd also present on system)
- Next by Date: Net::Daemon t/forkm.t issue on Solaris 10 zone?
- Previous by thread: Formatting -- recommended module
- Next by thread: Re: Problems with Net::MySQL on OS X Server
- Index(es):
Relevant Pages
|
|
