Root User Host Privileges Overview question

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

Root User Host Privileges Overview question

Postby cimmeron » 10. March 2008 06:39

Guten Tag everyone:
( sorry, just realized I should post English language here )

This is my default XAMPP/phpMyAdmin User Host Privileges Overview:
Everytime I install XAMPP, this is the result. ( I numbered the users )

_____User__Host_______Password__Global privileges___Grant
1st___pma__localhost____No_______SHUTDOWN_______No
2nd___root__127.0.0.1___No_______ALL PRIVILEGES___Yes
3rd___root__localhost____Yes______ALL PRIVILEGES___Yes

Question:
Is it 'correct' to see 2nd User here or is my winxp setup wrong?
( All the documentation I've read only speaks of 1st and 3rd Users. )

Is it 'correct' to Delete the 2nd User here or just leave the 2nd User here?

p.s. I have since, set passwords for ALL Users.

Thanks all.
cimmeron
cimmeron
 
Posts: 6
Joined: 07. March 2008 07:10

Postby Milligan » 10. March 2008 07:17

Last edited by Milligan on 17. July 2008 06:11, edited 1 time in total.
Milligan
 
Posts: 136
Joined: 03. March 2008 06:23

Root User Host Privileges Overview question

Postby cimmeron » 10. March 2008 18:00

Hello Spud Milligam

Many thanks for your response Spud.
I'm on winXP-home sp2.

I did delete the second root ( User=Root Host=127.0.0.1 ) and everything
seems to be working. I was wondered why it shows up if it's not required?

I will also comment out the 127.0.0.1 localhost entry in the C:\Windows\system32\drivers\etc\hosts file.
Curious again, I wonder why it shows up if it's not required?

I've been following the "http://robsnotebook.com/xampp-builtin-security" article called "Make XAMPP Secure" and I did not see the 127.0.0.1 localhost entry specifically mentioned there (or anywhere else, so far).

He advises to change the pma user to increase security,
(editing the config.inc.php file) which I've done. The only impact is - can't use the control panel to stop SQL. Must us the stopSQL.bat file.
Again, everything still seems to be working fine.

Thanks once more for your response Spud.
You have helped ease my Apache-newbie-worries about messing things up.

: )

Cheers
Cimmeron
cimmeron
cimmeron
 
Posts: 6
Joined: 07. March 2008 07:10

Postby Milligan » 10. March 2008 20:11

Last edited by Milligan on 17. July 2008 06:13, edited 1 time in total.
Milligan
 
Posts: 136
Joined: 03. March 2008 06:23

Root User Host Privileges Overview question

Postby cimmeron » 11. March 2008 07:14

Hello again Spud Milligan

Sorry for mangling your name!

I have corrected the changes I'd made earlier, per your instructions.

Can now Stop MySQL via Control Panel - much better, thanks!

"and now ...
the pma user is only read only and as secure as it will ever be
and you will be able to shut down MySQL in the usual way."

1. If the pma-user is only "read only" and as secure as it will ever be ...
then the pma-user is truly secure without a password, right?
can not write to User file, guaranteed by Apache Operating System?


Spud, if I may also ask you ...

1. Is it recommended to run Apache/MySQL as Windows Services or not?

2. Is it CORRECT that Apache runs in 2 Win Processes after Start Apache?
Windows Task Manager:
Image Name = Apache.exe User Name = SYSTEM Mem Usage = 21,252k
Image Name = Apache.exe User Name = SYSTEM Mem Usage = 23,132k

p.s.
Will definite bone up on my Forum 'search' technique, starting with security. Yes, there is so much to this but I'm really enjoying it!

Many thanks again Spud Milligan!

cheers
Cimmeron
cimmeron
cimmeron
 
Posts: 6
Joined: 07. March 2008 07:10

Re: Root User Host Privileges Overview question

Postby Milligan » 11. March 2008 07:44

Last edited by Milligan on 17. July 2008 06:09, edited 1 time in total.
Milligan
 
Posts: 136
Joined: 03. March 2008 06:23

Root User Host Privileges Overview question

Postby cimmeron » 12. March 2008 03:22

Spud Milligan,

My great thanks for your taking the time for all this assistance and your tips.

I have reread and saved these notes as they answer all my current questions and you have cleared my (current) confusion. : )

I plan to research (this Forum) and do an XAMPP clean-up / re-install
to get a fresh start ( in case I left any 'gremlins' lying around )

Much obliged to you Spud and hope to chat with you again ...

Happy days to you and yours in PaddyLand!

Cimmeron
cimmeron
cimmeron
 
Posts: 6
Joined: 07. March 2008 07:10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 136 guests