m (Created page with "<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 ...") |
m |
||
| Line 1: | Line 1: | ||
| − | <div align=justify>Databases in | + | <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. | 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 | + | 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: | + | 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 | + | '''1'''. Log into your '''[[cPanel]]''' at ''www.yourdomain.com/cpanel'' |
'''2'''. Click on '''Remote MySQL''' under the '''Databases''' menu | '''2'''. Click on '''Remote MySQL''' under the '''Databases''' menu | ||
| Line 13: | Line 15: | ||
'''4'''. Click on '''Add Host''' | '''4'''. Click on '''Add Host''' | ||
| + | |||
| + | {{#icon: Remote MySQL.png|Remote MySQL}} | ||
You should now be able to connect successfully.</div> | You should now be able to connect successfully.</div> | ||
.jpg)
