Create, Drop/Delete, Alter and access remotely MYSQL Database on cPanel

1. MySQL is a Relational Database management Systems that enables you to manage large volumes of data.

2. cPanel is an online Linux-based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web . There are two ways you can create a MySQL database.The first method of creating a database involves three things

  1. Creating a database
  2. Creating a database user
  3. Giving your database user access to work with your database.

You can create a database using the faster and simpler MySQL wizard.

STEP1  log into your cPanel account and click on the mysql database wizard which will direct you to the wizard page

STEP2 Create a database name

On the page that opens  provide a database name. The limitation is that there cannot be two similar database names. The name you will create here will be the same as the cPanel username. Once you have finished putting the desired username, click the Next Step button

In the next page, if you have created several databases, you will be able to see a list databases that you’ve created. on the actions page click delete to remove completely selected database.

At this point you have to bear in mind that it will be permanently irreversible if the delete action is taken here,  as all  data will be lost!

If it is the desired action, you will be prompted by a confirmation to have deleted the database

The Second method is enabling remote MySQL connections on the cPanel if you are to access the database via SSH but before that you can finish creating a user for the database by simply clicking on create user.

For purposes of security you may be prompted to create a password and you may see warnings about the password security strength. Normally this happens if the the length of the characters are below 65 characters. It is recommended to be above 65 characters for a strong password.

Accessing your database remotely

Adding remote host access for MySQL

Follow these steps if you need to access MySQL remotely:

In the Databases section of the cPanel home screen, click Remote MySQL.

Enter the remote IP address in the Add Access Host section

Click Add Host.

You will then see a message stating the host IP address was added to the access list.

You can use the % wildcard to specify a block of addresses or allow all source IP to access your database. Or you can also specify a sub-net in this manner, from IP 197.77.148.1-197.77.148.254 add 192.77.148.%

After you enable host access, you can connect to your MySQL databases remotely by using a MySQL client applications like MySQL workbench or Secure Socket Layer (SSH). Below are some of the tools you can work with MySQL remotely.

Advertisements
Posted in Linux, MySQL | Comments Off on Create, Drop/Delete, Alter and access remotely MYSQL Database on cPanel