How to Access Your WordPress Database via phpMyAdmin
While the WordPress dashboard allows you to manage content, phpMyAdmin allows you to manage the underlying data itself. Whether you need to fix a broken URL, deactivate a buggy plugin from the back end, or run a "Search and Replace" command, phpMyAdmin is the professional tool for the job.
As a Nixzoe Managed WordPress customer, you have full, unrestricted access to this tool through your cPanel.
Step 1: Identify Your Database Name
If you have multiple WordPress installations, youll first want to know which database belongs to which site.
-
In your Nixzoe WordPress Manager, look at the Details of your site.
-
Note the Database Name (e.g.,
nixzoe_wp123).
Step 2: Launch phpMyAdmin
-
Log in to your Nixzoehost Client Area.
-
Open cPanel.
-
Scroll down to the Databases section and click the phpMyAdmin icon.
-
A new tab will open, showing the phpMyAdmin interface.
Step 3: Navigating Your Database
-
In the left-hand sidebar, click the (+) icon next to your database name to expand the tables.
-
You will see tables like
wp_posts,wp_options, andwp_users.-
wp_options: Where your site URL and general settings live.
-
wp_posts: Where your pages, blog posts, and menu items are stored.
-
wp_users: Where your user accounts and encrypted passwords reside.
-
Common Tasks You Can Perform
| Task | Table to Edit | Why do this? |
| Change Site URL | wp_options |
If you changed your domain name and the site won't load. |
| Reset Password | wp_users |
If you are locked out and the "Forgot Password" email fails. |
| Deactivate Plugins | wp_options |
To fix a "White Screen of Death" caused by a specific plugin. |
| Search & Replace | wp_posts |
To update old links or change a brand name across 100+ pages instantly. |
Important: The "Safety First" Rule
Directly editing a database is powerful, but it carries risk. Unlike a WordPress post, there is no "Undo" button in phpMyAdmin.
Before making any changes:
-
Always use the Export tab in phpMyAdmin to download a
.sqlbackup of your database. -
Alternatively, use the Back Up / Restore tool in your Nixzoehost dashboard to create a manual snapshot.
Nixzoehost Expert Tip: If you ever see an error message saying "Error Establishing a Database Connection," it usually means your
wp-config.phpfile has the wrong credentials. You can use phpMyAdmin to verify that your database still exists and is healthy!
