close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Can not connect to the xampp mysql database from the remote server:

Thread began 6/29/2010 6:37 pm by nathan400860 | Last modified 6/29/2010 8:37 pm by nathan400860 | 3560 views | 2 replies

nathan400860

Can not connect to the xampp mysql database from the remote server:

Hello,
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.

"<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$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

Thanks,
Nate Swan

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...