Can not connect to the xampp mysql database from the remote server:
I have developed an e commerce site. I created a mysql database using xampp as e cart 5 directed me in doing so. My site works great and connects to my mysql database when I perform transactions on my local xampp server. I have to Manuely start my mysql and Apache servers on my xampp control panel in order to launch my site on the local server. I have recently uploaded my site onto a remote server. My remote server is godaddy and I'm using a Linux hosting account and I run on a windows platform. The site is in php format. The site works great on the on the remote testing server except for one thing. The site is not connecting to the mysql xampp database. After I fill out the form page I get an error on the confirm page. The error says this:
"Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/77/6349877/html/Connections/MyConnection.php on line 9
Fatal error: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/77/6349877/html/Connections/MyConnection.php on line 9"
The error says I have an error in the php coding in the MyConnection.php page on line 9. Here is the code on the MyConnections.php page. I have blanked out the username and password in the code.
$hostname_MyConnection = "localhost";
$database_MyConnection = "mysql";
$username_MyConnection = "root";
$password_MyConnection = "azusa";
$MyConnection = mysql_pconnect($hostname_MyConnection, $username_MyConnection, $password_MyConnection) or trigger_error(mysql_error(),E_USER_ERROR);
I am able to connect to the database when I am on the local server, I'm just having trouble connecting to the database when I'm on the godaddy remote server.
This is the last step I need to take to be finished with the site. I have to be done with the site in this week so much help would be appreciated!
The url to the error is confirm.php and the sites url is www.rvproductsnow.com