Page 1 of 1

Change root pass? [MySQL]

PostPosted: 28. February 2009 06:37
by KingKronos
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.

Re: Change root pass? [MySQL]

PostPosted: 28. February 2009 08:08
by Izzy
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

Re: Change root pass? [MySQL]

PostPosted: 02. March 2009 07:58
by KingKronos
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?

Re: Change root pass? [MySQL]

PostPosted: 02. March 2009 09:08
by Izzy
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.

Re: Change root pass? [MySQL]

PostPosted: 03. March 2009 22:13
by philip56
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

Re: Change root pass? [MySQL]

PostPosted: 03. March 2009 22:37
by newbie2244
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

Re: Change root pass? [MySQL]

PostPosted: 03. March 2009 22:43
by Izzy
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.

Re: Change root pass? [MySQL]

PostPosted: 07. March 2009 16:32
by philip56
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