Connecting to MySQL Remotely for GoDaddy Web Hosting Users
The GoDaddy web hosting service has an option to disable remote access to MySQL databases for security reasons. RazorSQL provides a MySQL PHP bridge so that users can connect to their GoDaddy MySQL databases from a remote machine, even if remote access is disabled. If your GoDaddy MySQL database is set up to allow direct connections (i.e., remote access is enabled), you should be able to use RazorSQL to connect directly to the database. If direct connection is not set up, you will need to use the PHP bridge.
Listed below are GoDaddy specific tips to getting connected to MySQL with RazorSQL. The following link contains general information on how the PHP bridge works, how to deploy the bridge PHP page, etc.
The following zip archive contains all of the RazorSQL ASP and PHP bridge pages. The file that needs uploaded to your site for MySQL is the razorsql_mysql_bridge.php file.
The following settings are typical values needed to connect via the bridge for GoDaddy users:
Bridge URL: This is the URL of the razorsql_mysql_bridge.php page
that you deployed either via FTPing the file to your site, or by using your GoDaddy
Hosting Control Center to upload the php page. For example, if your domain name is
www.acme.com, and you uploaded the bridge to the db subdirectory on acme.com, the URL
would be the following:
Host or IP Address: This is the GoDaddy mysql host. This information should be available from GoDaddy in your hosting control panel. GoDaddy servers typically have the [servername].secureserver.net name or the [servername].hostedresource.com or something similar.
You can find the MySQL server name by going to the databases section of the Hosting Control Center, and then clicking the edit button next to the MySQL database. This will display the host name, database name, database version, etc.
Port: The port would generally be the default port of 3306. This can be left blank unless the port is not 3306.
Database Name: If you have already created a MySQL database on your GoDaddy site, enter it here. GoDaddy would typically create the database name to be the same as the user name for the database.