How to configure remote MySQL access in cPanel

 In Blog, Internet, Network, Security, Softwares

MySQL Remote Access -When remote host access is enabled, you can use remote client applications to connect to your databases directly.

Screenshot from 2015-05-29 17:09:21

Adding host access

To add remote host access for MySQL, follow these steps:

  1. In the Databases section of the cPanel home screen, click Remote MySQL.
  2. In the Host text box, type the domain name or IP address of the host that you want to add,Now Question is How to Find your IP.
    It’s As simple as we can – just ask google, Google have ability to tell your IP.You can use the % wildcard to specify a block of addresses. For example, to allow all IP addresses that begin with 10.0.1, type 10.0.1.%.Screenshot from 2015-05-29 17:11:57
  3. Click Add Host.

Accessing your database remotely

After you enable host access, you can connect to your MySQL databases remotely by using a MySQL client application.

MySQL client applications

MySQL provides several GUI (graphical user interface) client applications that you can use:

  • MySQL Workbench: This integrated tools environment enables you to manage databases, run queries, and much more. It replaces the older MySQL GUI Tools application bundle.
  • MySQL GUI Tools: This application bundle includes the MySQL Administrator and MySQL Query Browser. MySQL Administrator has graphical traffic and health-monitoring features and optimization tools. You can also complete database backups. MySQL Query Browser is a graphical database browser and SQL query builder. You can view data, add and drop columns and rows, change values, and more.

Both of these application suites are free to download and use. There are versions for Microsoft Windows, Mac OS X, Linux, and other operating systems.

MySQL Workbench

MySQL Workbench enables you to quickly and securely connect to your MySQL databases using an SSH tunnel. To do this, follow these steps:

  1. Start MySQL Workbench.
  2. From the workspace page, click New Connection. The Setup New Connection dialog appears.
  3. In the Connection Name text box, type a name for the connection.
  4. In the Connection Method list box, select Standard (TCP/IP) over SSH.
  5. In the SSH Hostname text box, type example.com:7822, where example.com represents your domain name.
  6. In the SSH Username text box, type your A2 Hosting (cPanel) account username.
  7. In the MySQL Hostname text box, type localhost.
  8. Confirm that the MySQL Server Port text box is set to 3306.
  9. In the Username text box, type your A2 Hosting (cPanel) account username.
  10. Click Test Connection. The Open SSH Tunnel dialog box appears.
  11. In the Password text box, type your password.
  12. To have MySQL Workbench remember your password, select the Save password in vault check box.
  13. Click OK. The Connect to MySQL Server dialog box appears.
  14. In the Password text box, type your password.
  15. To have MySQL Workbench remember your password, select the Save password in vault check box.
  16. Click OK. If the connection is successful, you receive a Connection parameters are correct message. If you do not receive this message, check the values you specified in steps 3 to 9, and then try again.
  17. On the Setup New Connection dialog box, click OK.
  18. You can now run queries, create tables, and more. For example, from the workspace page, under Open Connection to Start Querying, double-click the connection name you specified in step 3. MySQL Workbench connects to your account and displays all of your databases.

Removing host access

You can remove host access when you no longer want a host to be able to access your MySQL databases remotely.

To remove host access, follow these steps:

  1. In the Databases section of the cPanel home screen, click Remote MySQL.
  2. Under Access Hosts, locate the host that you want to delete, and then click the red X icon.
  3. Click Remove Access Host to confirm the deletion.

References

www.wikipedia.com

Recommended Posts

Leave a Comment

Start typing and press Enter to search