Using phpMyAdmin

Every WordPress site has one database. You rarely need to look inside it, but when you do, phpMyAdmin is the tool: it opens from the control panel and shows every table. A few jobs are genuinely easier here than in WordPress. Everything else is safer in the admin.

Open phpMyAdmin

  1. Open the site in your account area and press Open control panel.
  2. Open the Databases section. The site's database is listed with its name and user.
  3. Press the phpMyAdmin link for it. It opens at phpmyadmin.affiliatehost.com and signs you in.

The database name, user, password, and host are also in the site's wp-config.php, which is how WordPress connects.

Before you change anything

Export first. In phpMyAdmin, select the database, choose Export, and save the SQL file. A database export takes seconds and turns a mistake into a minor inconvenience. For anything beyond a single-row edit, try it on a staging copy first.

Common jobs

Export a backup of your content

Export, Quick, Go. Keep it with your file backups. This plus a copy of wp-content/uploads is a complete site.

Change the site URL after a move

In the wp_options table, the rows siteurl and home hold the site address. Editing them gets you back into a site whose URL is wrong after a migration. For the rest of the content, use a search-and-replace tool that understands serialized data rather than a raw SQL replace, which can corrupt widget and plugin settings.

Reset a WordPress password you have lost

In wp_users, edit your user's user_pass field, choose the MD5 function from the dropdown, and type a new password. WordPress accepts it on your next login and rehashes it securely. Then change it again from your profile.

Find a plugin that is locking you out

The active_plugins row in wp_options lists active plugins. The safer route is renaming the plugin's folder over SFTP; see Using FTP and SFTP.

Table prefix

Tables start with a prefix, wp_ by default. A migrated site may use a different one; the $table_prefix line in wp-config.php says which.

Remote database access

Connecting from your own computer with a desktop database client is available on Enterprise VPS on request. On the shared platform, use phpMyAdmin.

What not to do

  • Do not drop tables you do not recognize. Plugins create their own, and WordPress breaks without them.
  • Do not run SQL you found online without reading it. A search-and-replace that misses serialized data looks fine until the widgets vanish.
  • Do not store the database password in a note on your desk; it is in wp-config.php when you need it.

Was this helpful? If something here is unclear or out of date, tell us and we will fix it.

Detailed control panel how-tos live in the Help Desk inside your control panel. Open it from your account area.