How to find out Database Name, Username and Password of Wordperss Website
The vast majority of settings and features can be handled within the WordPress administration section. However, when troubleshooting or under extreme circumstances, you may need to work directly with the database. Most hosting accounts contain more than one database, so you will need to know exactly which database to work with. This article will demonstrate how to locate the database name your particular WordPress installation is working with.
Here is Quick Way to Find out Database Name, Username & Password:
If you are doing something where you need the name of your database, then I’m assuming you have access to your server.
Simply go to the main folder of your WordPress install and locate the file called wp-config.php.
Open that file by clicking “View” or “Edit” or however your system lets you see the file.
Once your file is open, near the top after some introductory information, you should be able to spot the database name pretty clearly. It should look something like this:
Here is a STEP by STEP procedure to locate your WordPress installation’s database name, username and password:
Step No. 1:
First, you will need to log into your cPanel account.
Step No. 2:
Next, you will need to open and enter the File Manager tool.
Step No. 3:
From the File Manager, you will need to locate and move to the root folder for your WordPress installation. Once in the root folder for your application, you will see many files. The find the wp-config.php file. If you are using your main domain, the root folder will be public_html, as shown under:
If you are using a domain name, then it will be under public_html/domainname (For example, if example.com is an addon domain, you will need to fin the public_html/example.com folder), as shown under:
Step No. 4:
Now Highlight the file “wp-config.php” and then click on the Edit button found in the toolbar across the top of the screen. A popup will appear on the screen, click the Edit button there as well. [want to learn? How to Export WordPress Database File ]
after click “edit”, you will see the next window, as shown below:
now click “edit” button. now u will see next text file for edit.
Step No. 5:
Once in the editor, you will see a lot of code regarding WordPress. Just past the code comments, around line 19, you will see the code for the database name. It appears like the example below:
The database name parameter is actually composed of two parts. In our example snowfallerz_wrdp5, the first part is the cpanel username (snowfallerz), and the second part is the actual database name (_wrdp5).
And here in above image u will see easily Database Username and Password as well.
Step No. 6:
Write down your database name in a secure location so you can remember it when you need to access it using the phpMyAdmin tool.
If you are planning to transfer your domain/website to some other location or some another hosting account, or want to take backup of your wordpress database file, then you need to export the database file, dont know How to Export WordPress Database File? dont worry, you may click the upcoming link to learn How to Export WordPress Database File .