m |
m |
||
| Line 1: | Line 1: | ||
| − | <seo title="Remote MySQL" metakeywords="Remote MySQL, | + | <seo title="Remote MySQL" metakeywords="Remote MySQL,remote access mysql,mysql connect remote" metadescription="Remote MySQL access" /> |
| − | <div align=justify>Databases in | + | <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 | ||
.jpg)
