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.