How to enable Remote MySQL Usage/Management

If you need to connect to your databases remotely through MySQL management software such as MySQL Administrator or similar, you can do this easily by enabling Remote MySQL connections.

How do I enable Remote MySQL?

  • Login to cPanel
  • Click on Remote MySQL
  • Provide one of two items, the IP of the remote computer accessing the database or, the domain name
  • Click Add Host

After doing so, that remote IP or domain will be able to access your databases using valid MySQL connection information including:

  • Your remote MySQL Servername: sql.byethostXX.org (replace XX with your server number shown in your cPanel on the left eg: sv12)
  • Port 3306
  • A valid database name (eg. webuser_myforum)
  • A valid MySQL username (eg. webuser_forumdb)
  • A valid MySQL password for the above MySQL user

How do I remove a remote location from Remote MySQL?

  • Login to cPanel
  • Click on Remote MySQL
  • In the table below where you add hosts is a list of currently enabled locations, click the circled X next to the remote location to remove remote access

I have a dynamic IP, how do I enable Remote MySQL for me?

Simply put, for security it requires an IP, if you have an IP in the same range consistently (eg. 192.168.1XX.XXX) you could put 192.168.1% to enable the entire range for remote access.

What's the IP of my computer Internet connection?

Your IP as detected by this server: 114.130.65.21

SECURITY WARNING:

You can place a single % to whitelist every computer, IP or domain connected to the Internet however doing so can mean you open yourself to a security risk by opening the gate to access your databases. You should only do this if and when absolutely necessaryand make it temporary or if permanent have very strong passwords for MySQL users that rates 80 or above on the strength scale.

Was this answer helpful?

Related Articles

Using FTP to Manage Files

To use FTP to manage files you will need three key pieces of information... Your Username (eg....

Managing MySQL User Accounts

For security, you have the ability to create individual MySQL users to use with one or more...

Managing Database Data with phpMyAdmin

phpMyAdmin is a de facto standard for administrating databases in an easy point-n-click manner...

How to transfer your accounts from your old host

- login to cPanel- click backups- click 'Home Directory' under Partial Backups- choose a location...

How to manage files via cPanel File Manager

You can also use the built-in File Manager capabilities of your cPanel which is easy and doesn't...