Error- Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance.

Fix - Ssh in to the server and create the link:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock