Databases
How to Import a Database via phpMyAdmin in cPanel
Log in to your cPanel account. In the Databases section, click on phpMyAdmin. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. Click on Import. Under File to Import, click on Browse and select SQL file from your computer. Scroll down and click on Go. If it shows a success message, your SQL has been successfully uploaded.
Related: import, phpmyadmin, sql
How to Export Database Table via phpMyAdmin in cPanel
Log in to your cPanel account. In the Databases section, click on phpMyAdmin. From the navigation tree in the left sidebar. Please select an appropriate database that you want to export to your computer Click on Export. Select SQL format and then click on Go. SQL file will be downloaded within a few seconds, depending on the size of the file.
Related: export, phpmyadmin
How to Delete a Database Table via phpMyAdmin in cPanel
Log in to your cPanel account. In the Databases section, click on phpMyAdmin. Click on the Expand icon from the navigation tree in the left sidebar. Select the appropriate table you want to delete. If you’re going to delete table “wp_links”, choose it. Now click on Operations. Scroll down and then click on Delete the table (DROP). Warning: The whole table will be removed. Please, note that it will be impossible to restore it, especially if you don’t have a backup.
Related: phpmyadmin
How to Edit a Database Table via phpMyAdmin in cPanel
Log in to your cPanel account. In the Databases section, click on phpMyAdmin. Click on the Expand icon from the navigation tree in the left sidebar. Select the appropriate table you want to edit. If you wish to change the blog name of WordPress, then select “wp-options”. Click on Edit in the third row. Modify the text value and then click on Go. By doing that, you can change the value of SQL data of any software without accessing the administration area. For example, if you can’t change the theme from the administration area, you can use this method to change the value of SQL data.
Related: phpmyadmin
How to Create a Database Username in cPanel
Log in to your cPanel account. In the Databases section, click on MySQL Databases. Under MySQL Users, in the Username field, enter the new username you want to create. Enter your new password or use a password generator. Click on Create a User. Tip: Write down the database username and password on a notepad so you can easily recall them while installing a script manually.