phpMyAdmin - no privileges
Posted by: kennyb (---.lightspeed.bvhlca.sbcglobal.net)
Date: November 18, 2013 09:31AM

I am very new to all of this.
I installed the wampserver 2.4 stack, which includes phpMyAdmin of course.
I opened up the home page of phpMyAdmin. And then tried to create a database. But I cannot because I have no privileges.
The documentation suggests that privileges can be changed in the User page, accessed through the privileges link - but there is no privileges link and there is no User page. Also - there is nothing about privileges in the my.ini file. I am stumped.
How can i get privileges?
FYI, I am logged into windows as the computer admin.
I would be very appreciative if someone could help me with this. Should i be looking in the windows settings, or in some other settings file?
Thanks.

Options: ReplyQuote
Re: phpMyAdmin - no privileges
Posted by: RiggsFolly (---.as13285.net)
Date: November 18, 2013 11:23AM

MySQL comes with a default user account called 'root', initially it has not password set.

So on the phpMyAdmin login page use

Username = root
Password = blank (dont put anything in here )

You are now logged in as the SuperUser and can do anythng.


So now make sure you set the same password on all 3 root users that exists.
Thats
root@127.0.0.1
root@::1
root@localhost

AND DONT FORGET THE PASSWORD!!!!! Its a pain getting back in if you do.

Options: ReplyQuote


Sorry, only registered users may post in this forum.