Home How To How to change phpMyAdmin password on XAMPP

How to change phpMyAdmin password on XAMPP

by Mohsin Raza
How to change phpMyAdmin password on XAMPP

A new installation of the XAMPP Control Panel on a Windows device doesn’t hold the root password for MySQL PHPMyAdmin. In such a case, it could be effectively open to everyone and that outcomes in defenseless against basic dangers. To maintain a strategic distance from it, we propose you set an appropriately secure password to the user root. In this guide, we will disclose how to change the phpMyAdmin password on XAMPP.

In spite of the fact that it has been seen that in the wake of changing the phpMyAdmin password on XAMPP, users may experience an entrance denied blunder message that forestalls them to sign in to MySQL phpMyAdmin. So as to fix this issue, you have to change the configuration settings in the config.inc.php file. Thus, how about we begin.

How to change phpMyAdmin password on XAMPP

To change the phpMyAdmin password on XAMPP, you first need to dispatch the XAMPP Control Panel.

Once it opens, click on the Admin button for MySQL.

You may need to sign in using your current username and password and afterward click on the Go button.

On the PHPMyAdmin site, change to the User accounts tab.

Under the User accounts diagram, click on the Edit benefits link which holds root as its username, and localhost as the hostname.

On the following page, move to the Change password section.

Here you have to make another strong password having a combination of letter, number, and image. Close to the password field, there is a password quality indicator that shows your password status. As the password goes stronger, the status meter turns Red > Yellow > Green.

Retype a similar password on the corresponding box and afterward click on the Go button.

In the wake of making the new password appropriately, when you sign in to phpMyAdmin, you may experience an entrance denied mistake message, saying –

Can't connect: invalid settings

For this situation, you have to fix the login issue by changing the configuration settings in the config.inc.php file.

Also see: How to Delete File Explorer Search History

How to fix phpMyAdmin Access denied message

The phpMyAdmin get to denied message mostly happens when you change the login password of the phpMyAdmin password on the XAMPP

So as to fix this blunder, open the XAMPP Control Panel application.

Move to the correct end segment and click on the Explorer button.

In the File Explorer, explore to the accompanying way “C:\xampp\phpMyAdmin”

On the corresponding folder, find config.inc and afterward open it with any content manager like a notepad.

Discover Authentication type and data, and update the accompanying parameters:

In the primary line-

$cfg['Servers'][$i]['auth_type'] = 'config'; change config with cookie

Likewise in the line-

$cfg['Servers'][$i]['AllowNoPassword'] = true; change true with false

In the wake of playing out the accompanying changes, spare and close the file. That is it.

You may also like

Leave a Comment