How to set phpMyadmin users

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

How to set phpMyadmin users

Postby WikiBio » 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
WikiBio
 
Posts: 6
Joined: 30. January 2012 21:49
Operating System: Windows 7

Re: How to set phpMyadmin users

Postby Sharley » 30. January 2012 22:44

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. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: How to set phpMyadmin users

Postby WikiBio » 30. January 2012 22:52

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,
WikiBio
 
Posts: 6
Joined: 30. January 2012 21:49
Operating System: Windows 7

Re: How to set phpMyadmin users

Postby Sharley » 30. January 2012 22:58

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.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: How to set phpMyadmin users

Postby WikiBio » 30. January 2012 23:02

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
 
Posts: 6
Joined: 30. January 2012 21:49
Operating System: Windows 7

Re: How to set phpMyadmin users

Postby WikiBio » 30. January 2012 23:04

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
 
Posts: 6
Joined: 30. January 2012 21:49
Operating System: Windows 7

Re: How to set phpMyadmin users

Postby WikiBio » 30. January 2012 23:09

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
 
Posts: 6
Joined: 30. January 2012 21:49
Operating System: Windows 7

Re: How to set phpMyadmin users

Postby WikiBio » 30. January 2012 23:11

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.
WikiBio
 
Posts: 6
Joined: 30. January 2012 21:49
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 57 guests