No of visitors who read this post: 2789
Category: XAMPP
Type: Question
Author: Scott Elison
No votes yet

Hello,

Maybe this is a simple question but for some.

Please be kind to share your tips. I need to change the password for “root” in phpMyAdmin.

But I don’t find any idea how doing that. No link or tips from phpMyAdmin.

It gives me some notification, but not the way to solve it.

Thanks for your time.

phpMyAdmin root password change error

The additional features for working with linked tables have been deactivated. To find out why, click here.

Your configuration file contains settings (root with no password) that correspond to the

default MySQL privileged account. Your MySQL server is running with this default, is

open to intrusion, and you really should fix this security hole by setting a password for

user 'root'.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# Comment Id: 26860

Before I offer any solution, I'm going to warn you of something, while it is that it is very important to have a strong password for a live mysql / phpMyAdmin database its not so much a deep security issue for your local machine.

The reason why I’m saying this is because changing the password for your local machine really offers no benefit more of a hassle, especially if you forget your password lol happened to me once, boy was that a pain. 

  • But anyway you can change the password by simply using the command prompt window in your XAMPP main window.
  • From there, type the following into the mysql command at shell prompt $mysqladmin -u root password NEWPASSWORD.
  • Where NEWPASSWORD is the password that you'll be storing.
  • Let me point out again though, despite the warning, changing the password to your local account offers no real benefit and can be a real pain especially if for any reason you have errors, I had a situation once where the databases just wouldn’t work after changing a password, I had to forcibly reset everything using a script that i found online.

# Comment Id: 27862

Hello Scott,

  • To change your phpmyadmin password, you only have to follow three simple steps.
  • Open your XAMPP control panel and click on the security link just on the left side (3rd option).
  • Now it will open a new page where you have to click on the link provided (http://localhost/security/xamppsecurity.php). 
  • As you can see in the image.
  • Now simply type your new password for phpmyadmin and confirm it.

NOTE:IN THE CASE IF U FORGET YOUR PASSWORD THEN YOU HAVE TO UNINSTALL IT AND THEN REINSTALL IT
AND IT'S DEFAULT PASSWORD IS root.

XAMPP for windows

XAMPP-security console MySQL & XAMPP directory protection