View source

<seo title="Remote MySQL" metakeywords="Remote MySQL,remote access mysql,mysql connect remote" metadescription="Remote MySQL access" />

<div align=justify>Databases in your MyIdealHost [http://myidealhost.com/hosting.shtml web hosting account] can be accessed remotely. It could be useful if you want to share the same database between a few applications installed on other servers.
This tutorial will explain how to use remote MySQL.

By default remote MySQL access is disabled for security reasons. If you want to connect to your database using Remote MySQL connection then you need to enable remote mysql connections for the IP of your local machine.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such as ''phpMyAdmin, Navicat, MySQLFront or MySQL-Admin'' follow the below steps:

'''1'''. Log into your '''[[cPanel]]''' at ''www.yourdomain.com/cpanel''

'''2'''. Click on '''Remote MySQL''' under the '''Databases''' menu

'''3'''. You may enter a fully qualified domain name or an IP address in the '''Host field'''. Alternatively you may use '''%''' as a wildcard.

'''4'''. Click on '''Add Host'''

 {{#icon: Remote MySQL.png|Remote MySQL}}

You should now be able to connect successfully.</div>

Return to Remote MySQL.

Retrieved from "http://myidealhost.com/tutorials/Remote_MySQL"

Navigation

Search