Databases

Articles in this category

How to Create a Database in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on MySQL Databases. 

 2,018
(0)
How to Rename a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 

 1,848
(0)
How to Delete a Database in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 

1,964
(0)
How to Create a Database Username in cPanel

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 

 1,393
(0)
How to Add a User to a Database and Grant Privileges

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 

 1,537
(0)
How to Import a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.

 1,522
(0)
How to Export Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.

 1,446
(0)
How to Edit a Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.

 1,415
(0)
How to Delete a Database Table via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.

 1,513
(0)
How to Optimize a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.

 1,341
(0)
How to Repair a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.2. In the Databases section, click on phpMyAdmin.

 1,486
(0)
How to export a database with mysqldump utility on CLI

If you have a large database, you may want to export your MySQL database using the CLI or command line, using the mysqldump utility. Login to your account and access the terminal. If you need terminal...

 1,615
(0)
How to check MySQL / MariaDB version

If you need to check the installed version of MySQL or MariaDB on your server, the easiest way is to to open a SSH session and then run the command mysql -v and then record the version returned by MyS...

 1,990
(0)
How to import a compressed SQL backup to MySQL/MariaDB database

This method should be used for importing large databases on cPanel servers or on servers that don't have cPanel or phpMyAdmin. Keep in mind that phpMyAdmin requires you to configure the PHP version to...

 1,498
(0)