to help with general and specific hosting issues.
Databases
Remote connections
Clients with a Web Hosting Plan can connect to their database remotely.
Local Settings
Setup your local software to connect to the host using either your domain name or IP address as ...
www.change-domain.co.uk:3306
OR
255.255.255.255:3306
Check your Welcome Mail for confirmation of these settings.
Test Settings
After you have built your database, you may want to check you can access it. To perform such a check, use your html editor to enter the following code ...
$conn = mysql_connect("localhost", "db_user", "db_pass");
mysql_select_db("db_name", $conn);
echo $conn;
mysql_close($conn);
?>
Save the script as "mysqlcheck.php" and upload it to the public_html area of your website. Now access the page from any web browser and you should see something like this ...
Remember to change the following variables from the script ...
db_user = username assigned to the database
db_pass = password assigned to the user
db_name = name of the database itself
If an error exists, PHP will throw up any messages to alert you of where the error is. View these closely as they are very useful when trying to correct your script.
Allow Connections
You then need to tell the mySQL database to allow connections from your local computer. To do this follow these steps ...
- login to your user Control Panel
- click the link to 'remote mysql'
- enter your local IP address and then 'add host'
If you don't know your local IP number you can check it here: IP Checker
All content by Poldings Limited
Web Hosting and Web Development since 2001
Select a different knowledgebase section ...
Home | Billing | Databases | Design | Domains | Email | Getting Started | Hosting | Resellers | Resources | Scripts | SEO | Support | Troubleshooting | Tutorials
Read what our customers have to say: Customer Comments