site stats
How to set PHPMYADMIN password on XAMPP server?

How to Set phpmyadmin Password on XAMPP Server?

How to Set phpmyadmin Password on XAMPP Server?
How to Set phpmyadmin Password on XAMPP Server?

Some developers are test their application or softwares on localhost using XAMPP server. But most of  application needs database application username and password. For example some CMS needs database username and password. But XAMPP or WAMP server Phpmyadmin application has login with null password. So we are not able to install that CMS application on localhost. So first we need to set phpmyadmin password. This Guide will show you how to set Phpmyadmin password on XAMPP Server.

Let’s jump into the guide!

Step 1: First open your XAMPP control panel and start the Apache service and MySQL service.
How to Set phpmyadmin Password on XAMPP Server?

 

Step 2: Now open your browser and type localhost and click phpMyAdmin under tools option in right sidebar.
How to Set phpmyadmin Password on XAMPP Server?

 

Step 3: Now phpMyAdmin login without any password.How to Set phpmyadmin Password on XAMPP Server?

 

Step 4: Goto “C:\xampp\phpMyAdmin” and find “Config.inc.php” file
How to Set phpmyadmin Password on XAMPP Server?

 

Step 5: Open “Config.inc.php” file in Text editor like Notepad++.How to Set phpmyadmin Password on XAMPP Server?

[adHerem]

Step 6: Find the line $cfg [‘Servers’] [$a] [‘auth_type’] = ‘config’; in “config.inc.php” file.
How to Set phpmyadmin Password on XAMPP Server?

 

Step 7: Change the word $cfg [‘Servers’] [$a] [‘auth_type’] = ‘config’; to $cfg [‘Servers’] [$a] [‘auth_type’] = ‘cookie’; in “config.inc.php” file and Save the changes.

Note:  your default database name is “root“.
How to Set phpmyadmin Password on XAMPP Server?

 

Step 8: Now open browser and type “localhost/phpmyadmin”. Enter username is “root“. password is null means empty. you don’t type anything leave blank and press GO button.
How to Set phpmyadmin Password on XAMPP Server?

 

Step 9: Now you can see “change password” link. please click that link.

Note: notice under phpMyAdmin title,  logout icon is visible.How to Set phpmyadmin Password on XAMPP Server?

 

Step 10: Set your phpMyAdmin password and retype again and press GO button.
How to Set phpmyadmin Password on XAMPP Server?

Finally you can set PhpMyAdmin password successfully on XAMPP server. Now you can use some CMS which need database password on localhost for your testing job.

This Post Has One Comment

  1. Thank you for sharing your thoughts. I truly appreciate your efforts and I am waiting for your further write
    ups thanks once again.

Leave a Reply

Close Menu