Change root pass? [MySQL]

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

Change root pass? [MySQL]

Postby KingKronos » 28. February 2009 06:37

How do you change the root password for your MySQL server service via xampp and also, how do you change the password of the root user in phpMyAdmin?
I kept searching for my.ini but I'm not able to find it. I just got my xampp version so I assume it's the latest.
Thank you.
KingKronos
 
Posts: 5
Joined: 28. February 2009 06:33

Re: Change root pass? [MySQL]

Postby Izzy » 28. February 2009 08:08

MySQL and phpMyAdmin share the same root user and password and the password can be set in
http://localhost/security

root user has no password by default - readme_en.txt
Last edited by Izzy on 12. March 2009 08:35, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Change root pass? [MySQL]

Postby KingKronos » 02. March 2009 07:58

Code: Select all
Access forbidden!

You don't have permission to access the requested object. It is either read-protected or not readable by the server.


I get that when I try to access the link you gave me, any help?
KingKronos
 
Posts: 5
Joined: 28. February 2009 06:33

Re: Change root pass? [MySQL]

Postby Izzy » 02. March 2009 09:08

Drag xampp\apache\conf\extra\httpd-xampp.conf file in to your open text editor and look for 2 instances of:
Allow from localhost
change to:
Allow from 127.0.0.1

Save the file and restart Apache then try again and see if that helps.
Last edited by Izzy on 12. March 2009 08:37, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Change root pass? [MySQL]

Postby philip56 » 03. March 2009 22:13

Hi.

I have exactly the same problem. I cannot get Apache to restart after I make the file changes. When I remove them it does.

Is there anything else I can try?

Regards

Philip
philip56
 
Posts: 2
Joined: 02. March 2009 22:35

Re: Change root pass? [MySQL]

Postby newbie2244 » 03. March 2009 22:37

Does your xampp installation work? Are all your demo apps and tools accessible/displayed properly(no ugly scattered source code anywhere)?

Access <Security> in the nav bar, and find the hyperlink http://localhost/security/xamppsecurity.php. Click. Once you set a password, you can ause it to access MySQL through phpMyAdmin screen. YOu can change your password from within MySQL for MySQL as well.

Cheers
newbie2244
 
Posts: 49
Joined: 20. February 2009 22:39

Re: Change root pass? [MySQL]

Postby Izzy » 03. March 2009 22:43

philip56 wrote:I cannot get Apache to restart after I make the file changes. When I remove them it does
Make the changes in the conf file again, then save it as before.

Now run xampp\apache_start.bat file and it will give you a clue why it can't start.

Paste it here so it can be looked at.
Last edited by Izzy on 12. March 2009 08:39, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Change root pass? [MySQL]

Postby philip56 » 07. March 2009 16:32

Thanks Izzy.

When I went to carry out your suggestions, I realised my text editor had changed the file extension from .conf to .txt. I corrected this and all was well!!

It just shows you should always check for the obvious!.

Kind regards

Philip
philip56
 
Posts: 2
Joined: 02. March 2009 22:35


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 51 guests