Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Canot connect to the remote mysql server through those lines

by snopal (Pilgrim)
on Jul 01, 2007 at 20:20 UTC ( [id://624337]=note: print w/replies, xml ) Need Help??


in reply to Canot connect to the remote mysql server through those lines

From 'perldoc DBI'
Examples of $data_source values are: dbi:DriverName:database_name dbi:DriverName:database_name@hostname:port dbi:DriverName:database=database_name;host=hostname;port=port

Try as I might, I don't see how: 'DBI:mysql:nikkou6_db:mysql3.freehostia.com' is following that specification.

Assuming (big assumption) that user 'nikkou6_db' has exactly the same permissions as 'root' from the first connect sequence, you may still also have some 'non-local' permission issues for that user within your MySQL permission table. Otherwise, if you intended to connect using 'root' (very bad idea), you also have an incorrect user component in your call.

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://624337]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (5)
As of 2024-03-29 15:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found