View source

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

<div align=justify>Databases in cPanel can be accessed remotely, by other web servers. Remote MySQL access can be useful if you wish to allow applications such as shopping carts or guestbooks on your other servers to access the databases. 
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