How to set phpMyadmin users
Posted: 30. January 2012 22:34
Hello All,
My system is like these:
xampp: 1.7.7
xampp control panal: 2.5 (I didn't see any options that I could choose from the installer)
OS: Windows 7
I am trying to install the xampp. I chose the c:\xampp as the path, and I didn't check the "install Apache/MySQL/PhP as service". I didn't touch others.When the installer said "finished", I ran the xampp control panal, start the Apache and MySQL. Everything looked normal and fine. I tried to edit the mysql password by clicking the phpmyadmin-priviledges, and I saw multiple users:
User Host Password Global Priviledges Grant
Any % -- USAGE NO
Any localhost NO USAGE NO
pma localhost NO USAGE NO
root 127.0.0.1 NO ALL PRIVILEDGES YES
root localhost NO ALL PRIVILEDGES YES
Sorry for the poor expression here for I could not upload the screen shot.
I don't understand why there are 2 roots. Could I remove one root? Or just give them the same passwords?
About other users, what are they?
Thank you so much!!!!!
Best,
WikiBio
My system is like these:
xampp: 1.7.7
xampp control panal: 2.5 (I didn't see any options that I could choose from the installer)
OS: Windows 7
I am trying to install the xampp. I chose the c:\xampp as the path, and I didn't check the "install Apache/MySQL/PhP as service". I didn't touch others.When the installer said "finished", I ran the xampp control panal, start the Apache and MySQL. Everything looked normal and fine. I tried to edit the mysql password by clicking the phpmyadmin-priviledges, and I saw multiple users:
User Host Password Global Priviledges Grant
Any % -- USAGE NO
Any localhost NO USAGE NO
pma localhost NO USAGE NO
root 127.0.0.1 NO ALL PRIVILEDGES YES
root localhost NO ALL PRIVILEDGES YES
Sorry for the poor expression here for I could not upload the screen shot.
I don't understand why there are 2 roots. Could I remove one root? Or just give them the same passwords?
About other users, what are they?
Thank you so much!!!!!
Best,
WikiBio