How Can We Help?

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.
edit database table via phpMyAdmin in cPanel-websiteroof

3. In the left side-bar, Click on the expand button to expand the database like “example”.
edit database table via phpMyAdmin in cPanel-websiteroof

4. Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to edit and it will be expanded.

5. Select the appropriate table you want to edit like If you want to edit the table of WordPress and change the blog name from phpMyAdmin then select “wp-options”.
edit database table via phpMyAdmin in cPanel-websiteroof

6. Click on the “Edit” option on the 3rd raw.
edit database table via phpMyAdmin in cPanel-websiteroof

7. Edit “My Blog” to different text and then click on the “Go” button.
edit database table via phpMyAdmin in cPanel-websiteroof

By this method, you can change the value of SQL data of any software without accessing the administrator area like If you can’t change the theme from the administrator area then you can use this method to change the value of SQL and even you can change the password of any account.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Previous How to Edit .htaccess File via the cPanel File manager?
Next How to Edit file in the cPanel File Manager?
Table of Contents
Customers' reviews on Hostings.info Website Roof is listed on whtop.com Website Planet IPV6 Supported Secured by Imunify360