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: | ||
| + | <seo title="Remote MySQL" metakeywords="Remote MySQL,MySQL" metadescription="Remote MySQL" /> | ||
| + | |||
<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. | <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. | This tutorial will explain how to use remote MySQL. | ||
| Line 4: | Line 6: | ||
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. | 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 control panel at www.yourdomain.com/cpanel | '''1'''. Log into your control panel at www.yourdomain.com/cpanel | ||
| 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)
