Support Center
Setup A Site
Account & Features
Platform Information
WordPress Help
Troubleshoot
Browse All

SQL Queries in phpMyAdmin

Last updated on July 28th, 2025

databasephpmyadminquery

At WP Engine, the easiest way to access and work with your database is through a tool called phpMyAdmin. phpMyAdmin makes it easy to securely view and edit data as well as run queries to update data in bulk. If you are looking to optimize your WordPress® website, you will likely need to perform several actions in phpMyAdmin.1

NOTE

Want to access your database a different way? Try SSH Gateway instead.

Contents hide
1 Access Database with phpMyAdmin
2 Run Query in phpMyAdmin
3 Custom Database Prefix
4 Find the Database Prefix
5 Run SQL Query with a Custom Database Prefix
5.1 Example

Access Database with phpMyAdmin

To easily view your website’s database with phpMyAdmin in the WP Engine User Portal:

  1. From the Sites page, select the environment name
  2. Click phpMyAdmin at the top right