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.
Step 2: Now open your browser and type localhost and click phpMyAdmin under tools option in right sidebar.
Step 3: Now phpMyAdmin login without any password.
Step 4: Goto “C:\xampp\phpMyAdmin” and find “Config.inc.php” file
Step 5: Open “Config.inc.php” file in Text editor like Notepad++.
Step 6: Find the line $cfg [‘Servers’] [$a] [‘auth_type’] = ‘config’; in “config.inc.php” file.
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“.
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.
Step 9: Now you can see “change password” link. please click that link.
Note: notice under phpMyAdmin title, logout icon is visible.
Step 10: Set your phpMyAdmin password and retype again and press GO button.
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.