Adam Rubin wrote:
>
> Hi all,
>
> I have TWO copies of mysql running on one box. Not just two ports, but
> two completely different distributions. The first copy is running on the
> default port. The second copy is running on port 3400.
>
> I'm trying to use DBI to connect to the second copy (3400), but I just
> can't get it to connect. I'm wondering if I have to specify somewhere
> that it should be using the second copy of mysql instead of the default.
> I'm guessing that if it's trying to use the default, it's going to choke
> because that one doesn't have anything running on port 3400.
>
> Make any sense? Any suggestions?
>
> Here's my connection attempt:
>
> use DBI;
> $host="localhost";
> $port="3400";
> $database="alrdi";
> $user="xxx";
> $password="xxx";
It seems that DBI has got some problems connecting to a different port
than the standard port when using 'localhost'. I've got the same
problem,
and using the ip (not loopback) instead of localhost solved that.
> Access denied for user: 'xxx@localhost' (Using password: YES) at ./foo.pl line 12.
>
> Any help would be GREATLY appreciated.
--
Helios de Creisquer
mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
