Let’s say you want to find your WordPress database name or one reason or another. Maybe you want to change your password for your WordPress login, but either way this article will show you how to find the right data base name.
Lets say you build websites for a living and have 20 websites installed on your website hosting server. This creates a small problem when trying to edit the data base user details as you need to know which data base to enter. You could enter them all until you see something that looks familiar but this is a waste of time. We will need to go to the root of your domain and look for your wp-config.php
file. This will tell us what your WordPress database name is.
How To Find Your WordPress Data Base Name
1. Login to your cpanel hosting.
2. Scroll down to the files section and look for the file manager icon. Double-click on that icon. See the screenshot below.
3. A file manager directory selection box will appear. You will need to make a few choices here.
- you need to select document root for:
- You need to tick the box that says show hidden files.
- You need to choose which website from the drop down menu.
After all of this you can press the go. See the screenshot below.
4. Now you can look for your wp-config.php
file and select it by making it blue.
5. Then right click on the blue selection and choose “view” from the menu.
6. In this file you should see something like ” (‘DB_NAME’, ‘mydb_wrdp30’);
7. That means that mydb_wrdp30 is my database name.
Mitz,
Thanks soo much for this. I’ve been with my present host for about 1 1/2 yrs and it wasn’t until I read this post that I finally figured out how to locate one of my site’s db. Useful to know this when changing settings, permissions etc. Thanks again and Happy New Year.
Very true and very nice tip! …I am usually already in cpanel messing with code and such.. 🙂
Interesting article, but why would anyone want to know their wordpress db name. Is it for security purpose? Can someone please enlighten me.
We might want to know a WordPress data base name so we can change settings, backup a data base, and much more..