Error: Fantastico is unable to connect to your MySQL server at this time.

If you are trying to access your Fantastico instance and are not able to access it, there are several things you can try;

This problem can be caused by a wide variety of issues, please run through the following checklist:

1.) Restart MySQL on your server. Watch for errors. If MySQL doesn’t restart successfully, skip to #5 and try that next. (Note that in some rare instances, clients report the need to restart their server to get MySQL working properly.)
2.) The cPanel account is out of disk space or out of available mysql slots. Increase one or both of these and try again.
3.) The cPanel account account reports plenty of available disk space and mysql slots, but the user data/plan assignment is corrupt. Try assigning the account to a new featureset/hosting plan and see if that resolves it. If so, you may need to recreate or reassign the original plan to get things working again.
4.) The server itself is out of disk space on one or more partitions. Clean out unneeded files or accounts in this case.
5.) MySQL is malfunctioning on the server or the Perl DBD module is corrupt or missing. Run /scripts/mysqlup –force via SSH as root and watch for errors if any.
6.) The backend version of PHP is corrupt. Check the items here for a resolution:
http://netenberg.com/forum/viewtopic.php?t=1960.0
7.) If this only affects a single account, the account data may be corrupt. Do a full backup of the account, terminate it and then use the full backup to restore the account.
8.) Ensure your server is running Perl 5.8.8 (or whatever the latest approved version from cPanel Inc. happens to be — see http://layer1.cpanel.net/ ). Fantastico does not use Perl, but cPanel uses it extensively and if Perl isn’t a recent version, cPanel and thus Fantastico will have problems.
9.) Ensure you’re using the latest version of cPanel for your preferred build track. Run /scripts/upcp –force (or force the cPanel update from WHM) to make sure all files are installed and are the latest versions. If you run EDGE, try backing down to Current, Release or Stable and see if that helps.
10.) If all else fails, try removing Fantastico:
http://www.netenberg.com/forum/index.php?topic=3164.0
and reinstalling it:
http://www.netenberg.com/forum/index.php?topic=950.0

HOWEVER!!!!!!!

Before you try any of those recomended fixes, simply SSH to the server and goto /usr/local/cpanel/3rdparty/fantastico/includes/mysqlconfig.php and look for the following;

if ( ‘mysqlconfig.php’ == basename ( $_SERVER['PHP_SELF'] ) ) { die ( __FILE__ ) ; }

$MYSQLHOST = “127.0.0.1″ ;
$MYSQLPATH = “mysql” ;
If the path shows $MYSQLHOST = “localhost” , it needs to be changed to $MYSQLHOST = “127.0.0.1″ and save it in the file and also into a file called mysqlconfig.local.php (if doesn’t exist, create it).

Once you do this, you can restart mysql and Fantastico should connect again.