How to set phpMyadmin users

[WikiBio]

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

[Sharley]

Best practice with XAMPP is to leave the defaults in place until you are familiar with what the defaults do and what the consequences will be if they are edited.

Set the root user password using the Security menu in http://localhost after setting your language.

The readme_en.txt file has most of the details required to start using XAMPP and it's components.

New users may find self help by reading these pages:

readme_en.txt file in the xampp folder.

http://www.apachefriends.org/en/xampp-windows.html
http://www.apachefriends.org/en/faq-xampp-windows.html

Some useful reading that may help you help us to find suitable solutions:
viewtopic.php?f=16&t=48331
viewtopic.php?f=16&t=32670

Good luck.

[WikiBio]

Thank you so much!

Yes I read the readme, and the links you gave. My question is why there are 2 roots? I may miss this information, but should I set them 2?

Best,

[Sharley]

There is only one super user root but it is bound to the local loop back address of 127.0.0.1 (localhost).
Both are required entries and when you set a password for user root in the Security section of the XAMPP admin page for MySQL/phpMyAdmin it will be added to both entries in phpMyAdmin automatically.

[WikiBio]

Hello,

I set one root a password, and it pops up a yellow box to tell me that it was all set! I edit the other root with the same password, and I lost the MySQL. I went to the c:\xmapp\phpmyadmin\config.inc.php, add the password to the
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password';
And I still could not connect with the MySQL.



Any help and hint is highly apprecited!

Best,

[WikiBio]

Thank you for your relpy! Why I entered it twice, and the c:\xmapp\phpmyadmin\config.inc.php still shows empty password? and why I lost the mysql? crying.....

[WikiBio]

New updates.

When I click edit the pma priviledge, I could still connect with the MySQL. But could not edit the root any more.

Besides, I found this:
Note: phpMyAdmin gets the users' privileges directly from MySQL's privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.

How could I reload them???

[WikiBio]

New updates.

Reloaded!

Still could not connect with the MySQL if I click on the edit root priviledge, but for user ANY and PMA, I could see the edit page.