help using perl dbi with mysql to query a remote database

Question

I need help figuring out this configuration and the use of mysql perl DBI.

My local connection works fine, but once I try to query a remote host db I am getting errors. I know my setup to the remote db works as I can do the following from a shell:

WORKS:

$ mysql -u foo-man -pmypa55w0rd --database abc -h abc123.name.locale --port 3306 -ss -e "select UUID()"

From using the perl DBI, localhost works too:

my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost:port=3306;user=root");

But using perl DBI, querying a remote database, NO luck.

DOESN'T WORK:

my $dbh = DBI->connect("DBI:mysql:database=abc;host=abc123.name.locale;port=3306;user=foo-man,password=mypa55w0rd");

nor using the IP for example:

my $dbh = DBI->connect("DBI:mysql:database=abc;host=123.567.89.10;port=3306;user=foo-man,password=mypa55w0rd");

What error message do you get from $DBI::errstr?

Dancrumb
– Dancrumb

2011-02-25 03:46:36 +00:00
Commented Feb 25, 2011 at 3:46 — Dancrumb
– Dancrumb, Commented Feb 25, 2011 at 3:46

cjm · Accepted Answer · 2011-02-25 04:06:03Z

6

I would use

my $dbh = DBI->connect("DBI:mysql:database=abc;host=abc123.name.locale;port=3306",
                       'foo-man', 'mypa55w0rd');

But it would probably also work if you changed the comma after the username to a semicolon.

answered Feb 25, 2011 at 4:06

cjm

62.2k9 gold badges133 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

help using perl dbi with mysql to query a remote database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related