How to change the root password in XAMPP?

[Cortney]

Hi there, I have a problem regarding the use of the XAMPP. I have installed XAMPP in my Windows based computer but the problem is that i don't know that how to change the root password in it. So i am looking for a help form last one week and could not find any help with it. So finally i have4 decided to come here for the help regarding the same. I hope that i will get the solution from here. Any help may be appreciated. Waiting for reply because without the that any one can access my MySQL database. Thank you

[jesse]

Hey, You can set it during the time of installation but if you have miss that then no issue you can still set the password. Start the XAMPP server and after that open the browser which you are using for the internet connection and type http://localhost/security/ in it. Now you can see the Security page where you can set the root password for the My SQL which will update the phpMyAdmin config too.So go with it.It is really simple way to set the password for the XAMPP. Thank you

[SalVatore]

To make the change in root password for the use the following step which will help you set the same. So go through the step.

• Open the Appache Server as well as the MySQL
• Now start the Web Browser and enter the URL i.e. "http://localhost:8090/phpmyadmin/"
• After that go to the phpMyAdmin window and choose SQL tab from the right panel.
• You will see a windows open where you can run the SQL queries
• Now write the "UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';FLUSH PRIVILEGES; and click on the GO.
• After that query has been successfully executed.
• The password is set. If you refresh the browser then it will show you the error because it is not aware of the password set recently.

Thanks

[Dr. V]

This is the procdure to reset root password in MySQL . So go through this see that it is helpful or not. Say thanks if it works for you regarding the set of your root password.

• [root@redhat~]#killall mysqld
• [root@redhat~]#/usr/libexec/mysqld –skip-grant-tables –user=root &
• [root@redhat~]#mysql
• use mysql;
• update user set password=password(“newpassowrd”) where user=”root”;
• flush privileges;
• exit;
• [root@redhat~]#killall mysqld
• [root@redhat~]#/etc/init.d/mysqld start