Portal Home > Knowledgebase > Databases


How do I add a user to a MySQL database?


Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases" category. Locate the "Add User To Database" heading. Select the user you want to add the database, and then select the database you want to add the user to. Click "Add". Select the privileges you want the user to have in the database (All privileges is OK for most applications). Click "Make Changes".

How do I create a MySQL database?


Login to cPanel. Locate and click on the "MySQL Databases" icon in the "Databases" category. Under the "Create a New Database" heading, enter a name for your database. Click the "Create Database" button.

How do I delete a MySQL database?


Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases" category. Under the "Current Databases" heading, select the database you want to delete and click on the "Delete Database"  link. On the next screen, click the "Delete Database" to confirm that you wish to delete the database.

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 the red "x" next to the user's name. On the next page, click the "Delete User" button to permanently delete the MySQL user.

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 the left. Click on the "Export" tab and select an export option: Quick - Export the entire database using the default options. Custom - Select specific tables within the database to export, or...

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 your .SQL file. Click on the "Go" button and your MySQL database will import.

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 to the user you wish to remove from the database. On the next page, click the "Delete User from Database" button to confirm you wish to remove their permissions from the database.

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 always "localhost" Username - The user assigned to the database with adequate permissions to manipulate it. Password - The password for the user assigned to the database. Database Name - The name of...

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 "Databases" category. cPanel will then direct you to phpMyAdmin, where you can select a database to manage.