Remotely Connect to a MySQL Database

Remotely Connect to a MySQL Database

Remote MySQL IconIt is possible to connect to your MySQL database remotely. First you will need to allow the IP address access, to do this click the Remote MySQL icon in cPanel.

Then enter the IP address or host you wish to allow in the Add Access Host section. % can be used as a wildcard, so the pre-existing entry of 192.168.1.% allows access from all IPs 192.168.1.0-999. Adding a host of just "%" will allow access to absolutely everyone (who knows the password) so this is not advised.

Now you can connect to the domain name on mysql's standard port using the MySQL username and password.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What are the mailserver ports?

Secure POP3 is on port 995Non-secure POP3 is on port 110Secure SMTP is on port 465Non-secure SMTP...

I can't access cPanel

cPanel uses a secure connection and many proxy filters used in offices and schools block them. If...

What is the path to Perl?

Easy! /usr/bin/perl

What is the server path?

Easy! /home/username/public_html Be sure to replace username with your cPanel Username.

What is the highest CHMOD value?

For security reasons we run suPHP, this means that the highest CHMOD value available on...