How to change password for root in phpMyAdmin?

Asked By Scott Elison 0 points N/A Posted on - 08/31/2011

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.

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'.

• Status: Open
• Question Views: 7760
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: XAMPP

Best Answer by Daman Mehta

Go To Solution

Answered By Grammar 0 points N/A #120122

How to change password for root in phpMyAdmin?

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.

About Grammar

Questions
0

Answers
9

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 09/01/2011
• Question Category: XAMPP

Best Answer

Best Answer

Answered By Daman Mehta 0 points N/A #120124

How to change password for root in phpMyAdmin?

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.

About Daman Mehta

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/08/2011
• Question Category: XAMPP