Root password

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Root password

Postby jballotti » 20. July 2009 17:51

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.
jballotti
 
Posts: 9
Joined: 06. April 2008 19:01

Re: Root password

Postby Nobbie » 20. July 2009 21:10

You can modify everything (as well data as users and passwords) in phpmyadmin, which is part of Xampp installation.
Nobbie
 
Posts: 8759
Joined: 09. March 2008 13:04

Re: Root password

Postby jballotti » 20. July 2009 21:13

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?
jballotti
 
Posts: 9
Joined: 06. April 2008 19:01

Re: Root password

Postby Wiedmann » 20. July 2009 22:34

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
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Root password

Postby jballotti » 20. July 2009 23:12

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???????????????????????????????????
jballotti
 
Posts: 9
Joined: 06. April 2008 19:01

Re: Root password

Postby Wiedmann » 20. July 2009 23:15

Like you can read in the phpMyAdmmin documentation:
http://www.phpmyadmin.net/documentation/Documentation.html#servers_user
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Root password

Postby jballotti » 21. July 2009 01:29

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, :D
jballotti
 
Posts: 9
Joined: 06. April 2008 19:01


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests