How to Edit a Database Table Using phpMyAdmin in cPanel

phpMyAdmin allows you to manage and edit MySQL database data directly from cPanel without accessing your website’s administration panel. This is useful for updating settings, fixing configuration issues, modifying stored values, or making changes when admin access is unavailable.

Follow the steps below to edit a database table using phpMyAdmin in cPanel.

Step 1: Log in to cPanel

Access your hosting account and sign in to your cPanel dashboard.

Step 2: Open phpMyAdmin

In the Databases section, click on phpMyAdmin.

This will open the database management interface.

Step 3: Expand Your Database

From the left sidebar navigation panel, click the Expand icon next to your database name to display all available tables.

Select the database that contains the data you want to edit.

Step 4: Open the Database Table

Click on the specific table you want to modify.

For example:

If you want to update your WordPress site name, open:

wp_options

(WordPress installations may use a different table prefix instead of wp_.)

Step 5: Edit the Database Record

Locate the row that contains the value you want to change.

Click Edit next to that record.

Example edits may include:

• Website title
• Theme settings
• Application configuration values
• User information
• Plugin settings

Step 6: Save Your Changes

Modify the desired value in the corresponding field.

After making your changes, scroll down and click Go to save the update.

Changes Successfully Applied

Once completed, phpMyAdmin will update the database and apply the new values immediately.

Common Use Cases for Editing Database Tables

Using phpMyAdmin, you can:

• Change website titles and settings
• Update application configuration values
• Reset certain CMS options
• Modify plugin or theme settings
• Correct database values when admin access is unavailable

Important Before Editing

Database changes take effect immediately and may affect your website.

Before editing:

• Create a database backup.
• Confirm you are editing the correct table and record.
• Avoid changing unknown values.
• Test changes after saving.

Tip: If you cannot access your website’s admin area, phpMyAdmin can often be used to adjust settings directly in the database and restore access.