phpmyadmin log in as different user other than root@localhost, accidentally removed all access for user root?

Question

hello

i accidentally removed all priviliges for root@localhost and that seems to be the default user for phpMyAdmin and i'm using version 2.9.2 , so i cant seem to get access to any databases because i dont have privilige for it anymore and that's the default user. i have another user id on it which has full access, so can i log into that in any way and restore access to root@localhost? or is there any command i can use which won't harm my data? thanks in advance

Answer 1

Run this SQL statement:



GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION



where 'some_pass' is the root password.

Answer 2

Set that up as the phpmyadmin default user. As long as the other user has grant permissions set it should be no problem.

Answer 3

Hi there,

If you are looking for a free download of PHPmyadmin you can check here http://j.mp/1no5keo

I have been using it for years

Answer 4

- edge & ''edge and TNA rocks(me)" vs Eddie_advocate & Eddie Guerrero = edge and edge and Tna Rocks u are one in all my ultimate pals and that i like Ur Questions and answer ur an extremely large consumer 2-Masters & John Morrison vs Kennedy & Mr.Kennedy n1 fan. = Masters for helpful i'm a Legend interior the making and it would be an uncomplicated experience by way of fact mr.kennedy#1fan isn't that easy by way of fact he's my ultimate chum and he's that damn reliable 3-Koumidator & Undertaker vs Jayson Kane & Kane = Koumidiator and UnderTaker , koumidiator is probably going one in all the final answerer in Y!A and that i appreciate him very lots 4-heart wreck Gal & HBK & heart wreck Boy vs Randy Orton & RKO for President & Legend Killer % = sorry guy i won't have the capacity to vote i like the three shoppers and 3 wrestliers who on it so Tie 5-Ronn & Cm Punk vs Cassidy & Kurt perspective = Ronn he's kewl and he's one in all my ultimate pals ( sorry Cassidy) and for helpful i visit for ya My Fav wrestlers Morrison,edge,orton and MVP