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


August 28, 2023

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


August 28, 2023

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


August 28, 2023

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


August 28, 2023

How to Add a User to a Database and Grant Privileges

Log in to your cPanel account. In the Databases section, click on MySQL Databases. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database from the list. Click on Add. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.


August 28, 2023