Change root pass? [MySQL]

[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.

[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

[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?

[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.

[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

[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

[Izzy]

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.

[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