If you’re looking to find your WordPress database name in phpMyAdmin, this will be a simple guide.
Now, especially if you are using cPanel, when creating/adding a new website under your account, a new database will be created.
If you do not go out of your way to name the new database, it will be assigned with the same prefix as your other databases with a sequential number (e.g. databasename_wrdp1; databasename_wrdp2; etc).
The problem occurs when you have many websites and thereby many databases, you can forget which database is associated with which website.
For example, see the image below:
I have many databases because I have many websites on this account.
And if I wanted to change the password, or say if I forgot the username for the admin account for a website, I would need to access the database in order to change it.
However, in this mess it would take a while to sort through each database to figure out which corresponds to the particular website.
So, the simplest way to find the database name for the WordPress website you want is to find it within its wp-config.php file.
Go to “File Manager” via cPanel or ftp for the website you want, then head into your websites folder.
For example, the file path will be something like:
public_html/asapwp.com
Next, find the wp-config.php file and open it up.
Once inside, just a ways down you will see the database number:
In this case, I know it’s “_wrdp32”, and can now easily locate it within the list of databases in phpMyAdmin.