Open In App

How to find the Username and Password in PhpMyAdmin in Windows ?

Improve
Improve
Like Article
Like
Save
Share
Report

In this article, we will see how to find the Username & Password of PhpMyAdmin in Windows. PhpMyAdmin is a free and open-source administration database management tool for MySQL and MariaDB.

Sometimes, we forget the username and password that we set during registration. As the problem is without the username and password, we cannot connect to the database, and without connecting to the database, we cannot create the applications. Here, we will see how to easily retrieve the username and password of the phpMyAdmin in a step-wise manner.

Steps for finding the Username and Password of PhpMyAdmin: Here is the stepwise solution that will be followed as such to retrieve the credentials.

Step 1: Press Ctrl+R and type C:\xampp\phpMyAdmin (or) Navigate to that directory.

Run window

Go to C:\xampp\phpMyAdmin or the place where it is installed. (Generally, this is the default location)

Step 2: Inside the phpMyAdmin directory, locate the config.inc.php file. Filename: config.inc Extension: .php

screenshot-1

Here, use Searchbox and type “config.inc.php ” (or) locate it manually.

screenshot-2

Step 3: Inside the config.inc PHP file, go to this part where the “Authentication type and info” Comment is there. You can use Ctrl+F or the Search option to find it. You will see the Arrays of Arrays containing the required information.

You can open the PHP file in inbuilt-notepad or any text editor, like VS Code.

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

Screenshot

Here the password is "" empty, username is root.

Now, we can use this username and password to access the databases and create the application successfully.


Last Updated : 09 Dec, 2022
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads