Hosting

PHPMyAdmin and MySQL

PHPMyAdmin and MySQL access are available to administrators on the WordPress.com Business and eCommerce plans.

Before Beginning

Accessing your database is not required for your site to function. Do not touch your site’s database unless you have a very specific reason. If you’re unsure, contact a Happiness Engineer for help before accessing your database.

You should not ever run a command unless you know exactly what it will do.

If you don’t understand what a command does, don’t run it. Running unknown commands without understanding them may lead to your site breaking, and can also cause you to lose data.

You may have come across articles that suggest manipulating the database to improve various aspects of your site. Here at WordPress.com we’ve already taken steps to ensure your site is optimized, and you should not need to do anything with your database directly.

We are happy to help you determine whether you need to access your database and help restore your site should accidents occur, however WordPress.com Happiness Engineers are not here to assist you with creating, modifying, or running database commands.

Database Access

You’ll see a Hosting Configuration option under Manage in the navigation menu of your WordPress.com Dashboard.

Click it to access your site’s database.

You can also use https://wordpress.com/hosting-config to access this section.

Once there, click the Open phpMyAdmin Button to get started.

A new tab will open and you’ll be prompted to click a link to proceed to your Database.

After this loading screen you’ll see something called phpMyAdmin; it’s a tool used to access your site’s database, and run commands to interact with it.

What if Something Goes Wrong?

If something happens to your site after you’ve made changes to your database, we’d be glad to help you restore your site from a Rewind Backup.

If you run a command, and something happens you didn’t expect, we’re happy to help you restore your site to an earlier point, from before you ran the command. But we will not be able to help you debug your command to make it work as expected. You can Rewind your site from your Activity Log.

Frequently Asked Questions

Can I upload .sql files? What is the file size limit?

Yes, you can import database files. Please bear in mind that the size of the database counts against your 200 GB storage limit.

Can I change file size limits and maximum execution time?

No, this is set on the server side and it cannot be changed. You can review our environment details here.

Do you provide support for custom SQL queries I want to run in phpMyAdmin?

No, we do not provide support to help you create, modify, run, or debug commands. Please do not run a command if you aren’t sure what it will do.

If I have multiple users on my site, can I see who did what?

Accessing the database will appear as an entry in your Activity Log. However, we are not able to track what someone does while they are accessing your database.

Not quite what you're looking for?

Get Help