How to Find Database Name, Username & Password in WordPress

How to find out Database Name, Username and Password of Wordperss Website

find-wordpress-database

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.

wp-config-php-root

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:

wp-config-php-text-source

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.

cPanel-login

Step No. 2:

Next, you will need to open and enter the File Manager tool.

locate-file-manager

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:

wp-config-php-root

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:

wp-config-php

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 ]

edit-wp-config-php

after click “edit”, you will see the next window, as shown below:

text-editor-wp-config-php

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:

define(‘DB_NAME’, ‘userna5_wp123’);

wp-config-php-text-source

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 .

Related Posts Plugin for WordPress, Blogger...