By default, when you install XAMPP in your windows machine, the ‘root’ password for the MySQL is set to empty. But this is not recommended, as the MySQL database without a password will be accessible to everyone. To avoid this, a proper/secure password must be set to the user ‘root‘. To do it in XAMPP, there are two ways.
Method 1: reset XAMPP MySQL root password through web interface:
After you started your XAMPP server, go to the browser and type the URL http://localhost/security/ (incase you’ve modified XAMPP server port, you need to include that port number also in previous URL). The security page will be shown where you can change the ‘root’ password for MySQL. This will update the phpMyAdmin config also.
Method 2: reset XAMPP MySQL root password through SQL update:
- Start the Apache Server and MySQL instances from the XAMPP control panel.
- After the server started, open any web browser and give http://localhost:8090/phpmyadmin/ (if you are running XAMPP on 8090 port). This will open the phpMyAdmin interface. Using this interface we can manager the MySQL server from the web browser.
- In the phpMyAdmin window, select SQL tab from the right panel. This will open the SQL tab where we can run the SQL queries.
- Now type the following query in the textarea and click Go
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
FLUSH PRIVILEGES; - Now you will see a message saying that the query has been executed successfully.
- If you refresh the page, you will be getting a error message. This is because the phpMyAdmin configuration file is not aware of our newly set root passoword. To do this we have to modify the phpMyAdmin config file.
- Open the file [XAMPP Installation Path] / phpmyadmin / config.inc.php in your favorite text editor.
- Search for the string $cfg['Servers'][$i]['password'] = ”; and change it to like this, $cfg['Servers'][$i]['password'] = ‘password’; Here the ‘password’ is what we set to the ‘root’ user using the SQL query.
- Now all set to go. Save the config.inc.php file and restart the XAMPP server.
{ 38 comments… read them below or add one }
bravo, thank you so much, this is the only tutorial i fond that actually somehow successfully worked my phpmyadmin client.
Very nice Good job.
Tnx a lot
Thanx. Works well, but … is the “restart XAMPP” step at the end of the process really needed ?
In my case it didn’t.
Thanx again
Hi Marco,
In my case, I had to restart XAMPP server, since I’d modified the phpMyAdmin config file and the server didn’t pickup the changes without restarting it.
Thanks
thx vry much
hi,
Really..Very Useful.Thx Dude..
hi dear:i was using vertrigo with editor dreamweaver.all was working very well but when i installed xampp and joomla then all vertrigo stopped working and phpmyadmin did not opened and all databases that were made in mysql are not appearing.
plz help me as early as possible.
@qaiser
from your comment, I guess the problem might be because of port conflicts. If XAMPP and the other applications try to use same port, then these kind of problems may occur.
Please try changing XAMPP password and see if everything works fine.
Thank a lot.
Thanx. Works well, but … is the “restart XAMPP” step at the end of the process really needed ?
In my case it didn't.
Thanx again
Hi Veerasundar,
Thanks a lot
Like this…
Not sure what happened, but I got an error when I changed that info within the config file. I uninstalled XAMPP, and then reinstalled, and now I can’t access myPHPAdmin. I’m getting this error message: “#1045 – Access denied for user ‘root’@'localhost’ (using password: NO) ”
Do you know how to alleviate this?
Very informative, thanx alot keep up the good work.
thank you very much it your tutorials helped me very much…but i am getting one problem i created other users on mysql with password…but when i tried to connect it through php using mysql_connect it says that can’t connect using password ‘YES’…plz help if u can…thanks..
I suspect that you are using wrong username/password combination. If you created a new username and password and you are trying to connect as this new user, then you have to use the newly created credentials.
Hi Veera
Thanks for this – its nice to see others working with XAMPP!
Here’s my take on securing XAMPP:
http://diyws.ath.cx/lessons/lesson-4-securing-xampp/
Cheers
Brad
Thank you very much . Your post is very helpful for me fixing my problem
really thanks
Thanks mate that was a great help.
look good and helpful to me. thank you for your sharing
The first part worked fine, but upon attempting to save the new password in the config.inc.php file, it refused to save, saying that I didn’t have privileges, or something to that effect. please help?
Excellent thanks.
BTW, where does XAMP store this config file to edit the MYSQL password manually?
Or is it an encrypted file that can only be modified via the web interface?
Jared
Ok, thanks!
thanku
thank you very much brother
it was very helpful
Thanks,all my problems solved..with small changes
Thanks,all
Dear sir,
Hi I want to know about the Nice menu and how to use this module in our website. Please describe with video if it is possible.
which menu are you talking about?
Thank You!!!!
i’ve search this anywhere, thx very much!!
Thank you soo much.Easy way to finish the work.
How to change the ‘root’ password for MySQL in XAMPP?
can you tell me how to change the user name also
+1 Great job. I look for so many website, could not fix it. This made it a piece of cake.
I had password set on mysql in xampp. My installation went corrupt and had to reinstall xampp. I left mysql as it is (as there were database I wanted to use). After installation, I could not login to phpmyadminbut my websites were working. Using method 1 above I changed the password and phpmyadmin is working now
Thank you
Thank you soo much Thank You!!!! Thank You!!!! Thank You!!!!
{ 4 trackbacks }