Knowledgebase  //  Databases

Articles

How do I delete a MySQL user?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases" category. Locate the "Current Users" heading and find the user you want to permanently delete. Click...


How do I export a MySQL Database?

Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category. Once phpMyAdmin loads, select a database from the left that you wish to export from the list on...


How do I import a MySQL Database?

Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category. After phpMyAdmin loads, click on the "Import" tab. Click on the "Choose File" button and select...


How do I remove a MySQL user from a database?

Login to cPanel. Locate and click on the "MySQL Databases" icon within the "Databases" category. Under the "Current Databases" heading, find the "Users" column. Click on the red "x" next...


How to create a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. In "New Database: Username_" field enter a name for the new database you wish to create in...


My application is asking for database information - where do I get it?

Nearly all web applications have a database back-end that require a MySQL database. During the application's installation, you will be asked for these database details: MySQL Host - This is...


What is phpMyAdmin?

phpMyAdmin is a graphical user interface (GUI) used for managing data within a MySQL database. To access phpMyAdmin:   Login to cPanel. Locate and click on the "phpMyAdmin" icon under the...


How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Under "Current Databases", You can see list of your all databases. Locate the Database and...


How to delete a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Under "Current Databases" you can see a list of all your databases. Locate the Database you...


How to Create a Database Username in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Under "MySQL Users" in the "Username" field enter the new username you wish to create.4....


How to add a user to a database and add privileges?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases" Icon. 3. Scroll down to the end of the page and under "Add User to Database", select a user from the...