connection

This may be slightly off topic, I am trying to connect to a MySQL database with perl. If I use the IP address in the following connection string:

$dbName = "DBI:mysql:database=<dbName>;host=localhost;port=3306";
$dbUserName = "<uName>";
$dbPassword = "<password>";

$dbh = DBI->connect($dbName, $dbUserName, $dbPassword);

where the vars are actually present and correct. The connection works fine, but if I use localhost it doesn't. I have been searching everywhere for this but can't find anything about it.. any ideas?

You might start by looking at your permissions table. Is the user defined as "user@localhost" or just "user" or otherwise?

Try: