I have a perl script I’ve brought with me from my last host. It accesses a mySQL database and serves as a dealer locator for businesses. It worked flawlessly on my old host, but here I receive a 500 Internal Server Error. I exported the mySQL database and re-imported it here. All looks well. I update the perl script to match the new username and database location. This is the error I receive in the logs:
DBI connect(‘ziplook.drewperry.com’,‘ziplook’,…) failed: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) at ziplooktest.pl line 11
Can’t connect: at ziplooktest.pl line 11.
And line 11 from ziplooktest.pl is as follows:
$dbh = DBI->connect(“DBI:mysql:ziplook.drewperry.com”, “ziplook”, “ziplook”) ||
die “Can’t connect: $_”;
Can anyone tell me what that line should read? Yes, the username and password are both “ziplook” for simplicity’s sake. Many thanks in advance.