Apache Friends Support Forum

How do I change the root password for MySQL database on an XAMPP installation? The current password is blank, which won't work on a Joomla installation.

You can modify everything (as well data as users and passwords) in phpmyadmin, which is part of Xampp installation.

Nobbie wrote:You can modify everything (as well data as users and passwords) in phpmyadmin, which is part of Xampp installation.

Thank you for replying. I'm looking at the phpMyAdmin page and can't seem to see where you can change the root password. Maybe I'm just thick or blind but if you could point me to the procedure for doing this I would be very appreciative.

I tried using the following code from the SQL window in phpMyAdmin

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('biscuit');

I got an error message and now phpMyAdmin is denied access.
Does anyone know how to fix this?

Maybe I'm just thick or blind but if you could point me to the procedure for doing this

Maybe reading the "readme" first, if you install a new software?

I got an error message and now phpMyAdmin is denied access.
Does anyone know how to fix this?

You must also adjust the phpMyAdmin configuration to the new password.

Wiedmann wrote:

I got an error message and now phpMyAdmin is denied access.
Does anyone know how to fix this?

You must also adjust the phpMyAdmin configuration to the new password.

How???????????????????????????????????

Like you can read in the phpMyAdmmin documentation:
http://www.phpmyadmin.net/documentation/Documentation.html#servers_user

Wiedmann wrote:Like you can read in the phpMyAdmmin documentation:
http://www.phpmyadmin.net/documentation/Documentation.html#servers_user

Thank you very much, that response is much more useful than telling me that I need to do something without giving any indication of how to do it or where to find the information on how to do it. While you may think I'm an idiot, and I readily admit that I'm not an expert on all of the components of the XAMPP package, I did create a series of videos on how to install the XAMPP package for the purpose of testing the Zen Cart and Magento applications that thousands of people have accessed and found useful (http://ipicdg.com/EC/). Since Zen Cart and Magento don't care if the database username has a password, the default installation works fine. However, it seems that Joomla won't allow that. So, I need to learn a little bit more about XAMPP and it's components in order to support the applications I'm trying to test and learn. I'm an old guy, at 58 I'm a legitimate senior citizen, so I appreciate your patience and hope you can understand my ignorance. I promise you that I will carefully read the documentation you have pointed me to and, if necessary, I will update my website with this information for the visitors to my site.

Now if you could give me an indication about how to go about changing the password for the root MySQL user I would greatly appreciate it. I did find that if I click on the "Security" link from the "http://localhost/xampp" page it gives me the opportunity to change the root password. If you could verify that this is indeed the place to make the change then thank you, if not, if you could indicate where I can find the information I need it would be greatly appreciated.

Thanks again,