Database FAQ

knowledge base

How to use the MySQL Database Wizard to create a database

  How to use the MySQL Wizard in cPanel cPanel users can use a wizard to create a database. Log into your cPanel -> MySQL Database Wizard. Enter a database name and hit next. Next, enter your Username and Password and hit Create user. Select ALL PRIVILEGES and...

How to make database backup on my Dedicated Server

To create a backup of a database you need to SSH into the server.ssh -p <portnumber> 'user'@servername.com Then enter the following command replacing DATABASE_NAME with the name of your database in order to generate your backup which will be called BACKUP.sql....

How to Repair database via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In the left side-bar, Click on the expand button to expand the database like "example".           4. Under your cPanel username, you can see a list...

How to optimize the database via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like "example".           4. Under your cPanel username, you can see a list of...

How to delete database table via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon.   3. In left side-bar, Click on the expand button to expand the database like "example".           4. Under your cPanel username, you can see a...

How to export database table via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like "example".           4. Under your cPanel username, you can see a list of...

How to edit database table via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like "example".           4. Under your cPanel username, you can see a list of...

How to import database via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like "example".         4. Under your cPanel username, you can see a list of all...

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 dropdown list, and then choose a Database from the list. 4. Click on the Add...

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. Enter your new password or use a password generator. 5. Click on the Create a User...

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 wish to remove and then click on the Delete icon. 4. Click on the Delete Database...

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 a list of all your databases. Locate the Database and then click on Rename Icon. 4. Change the database name and then click on the...

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 the text field.4. Click on the Create Database Button.