Knowledgebase

How To Remotely Connect to MySQL Database with cPanel

This is done to enable access to a database from your personal computer. For this purpose, you need a MySQL client like phpMyAdmin, Workbench.

   1. Log in to cPanel.

   2. Under the Databases section, click on Remote MySQL® icon.

cPanel - Remote MySQL

   3. Enter the connecting IP address

   4. Click on Add Host.

Remote MySQL - Add IP Address

To remove a host from accessing databases on your server

1. Click the Remote MySQL icon under the cPanel's Databases section.

2. Locate the IP address you wish to remove.

3. Click the Delete icon on the right-hand side of the IP address.

 

  • Database, Remote, Remote Database, MySQl
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

SQL injection

SQL injection is an attack where malicious code is passed to an SQL Server for execution. The attack can result in unauthorized access to confidential data or the destruction of critical data....

MySQL Database Limit

There is no limit for the size of databases. MySQL is only limited to the size of your cPanel's disk space. As long as there is still some free space in your cpanel disk, you are good to go.

MySQL Variable Types

MySQL database has three (3) main data types: text, numbers and dates/times. Text Types CHAR( ) A fixed section from 0 to 255 characters long. VARCHAR( ) A variable section from 0...

cPanel MySQL Database Wizard

This instructions guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user. To create...

phpMyAdmin Glossary

phpMyAdmin is a free open source tool written in PHP language. This tool handles the administration of MySQL and MSSQL over the web, performing various tasks such as creating, modifying or deleting...