>>On Mon, Sep 27, 2010 at 3:06 AM, Eric Robertson <eric...@blueyonder.co.uk>
wrote:

>> 

>>I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState
Perl - I'm using version 5.8.8 at the moment. I did this to make it easier
to install some of the modules I wanted but I'm not sure I wouldn't have
been better just to use >>the Perl that comes with the Mac OS! 

>> 

>>The problem I have is that I can't connect to a MySQL database that I have
on the MacBook, set up using MAMP PRO. When I was running everything under
Windows I used to have the DBD::mysql driver installed but this doesn't seem
to >>be available for this build so I'm using DBD::mysqlPP which I assume
should work in the same way. However the connection string fails when I try
to connect using the following:

>> 

>>        $dsn = "DBI:mysqlPP:host=localhost:database=$database";

 

>From: Angelos Karageorgiou [mailto:ange...@unix.gr] 
>Sent: 28 September 2010 06:48
>To: Eric Robertson
>Cc: activeperl@listserv.ActiveState.com
>Subject: Re: Problem Connecting to MySQL Database

> 

>First things first: 
>a)locate mysql's configuration file my.cnf normally under /etc , make sure
that the lineskip_networking does not appear in it ! 
>b)comment it out if it's in the file.
>c) Restart mysql
>d)telnet to port 3306 manually and see if the server answers the
connection.
>
>if all of the above works then you are go !



Thanks Angelos - you'll see from my other posting that it was the listening
port that was the problem and that there was an easy way of fixing this
using the MAMP control panel.

 

Eric

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.856 / Virus Database: 271.1.1/3163 - Release Date: 09/27/10
18:56:00


_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to