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
- Open the site in your account area and press Open control panel.
- Open the Databases section. The site's database is listed with its name and user.
- Press the phpMyAdmin link for it. It opens at
phpmyadmin.affiliatehost.comand 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.phpwhen you need it.
Was this helpful? If something here is unclear or out of date, tell us and we will fix it.
Related articles
Detailed control panel how-tos live in the Help Desk inside your control panel. Open it from your account area.