I've written a perl script that I'm using to update a MySQL database. The script runs fine from the command line, but I receive the error message "DBI connect('host=mysql.domain.com;database=xcard','user_name',...) failed: Can't connect to MySQL server on 'mysql.domain.com' (111) at /home/user_name/xcard.pl line 14"
I've tried reading dreamhost's documentation and I've tried changing the cron entry several times. Currently I'm trying to use Dreamhost's Cron GUI. The entry I'm using looks like "/usr/local/bin/perl /home/ikari/user_name/xcard.pl"
I've substituted "user_name" for my user name and "mysql.domain.com" for my mysql subdomain.
Any help would be greatly appreciated.