Hi Jesse,
On Sat, Jun 22, 2002 at 03:42:57AM -0500, Jesse Angell wrote:
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out what do i do
to give root full privs again?!? Please help me get mysql running again
Oops!
Take a look at http://www.mysql.com/doc/R/e/Resetting_permissions.html
on how to restart your MySQL daemon with privilege checking. Then login
with:
# mysql -u root
And type:
grant all on *.* to root@localhost;
And restart your MySQL daemon again. I never tried this, but I guess
it should work.
Good luck!
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php