Hi!
Not sure if this will be useful as well. Searched the MySQL manual and
found this page. It mentions a bit about restarting MySQL and resetting the
root password.
http://www.mysql.com/doc/A/c/Access_denied.html
Hope it helps!
Sam.
----
----- Original Message -----
From: "Ken Menzel" <[EMAIL PROTECTED]>
To: "jessica" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 4:24 PM
Subject: Re: Deleted user
> >From the very fine manual:
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm
> l#Resetting_permissions
> -----------------------------------------------------
> Ken Menzel ICQ# 9325188
> www.icarz.com [EMAIL PROTECTED]
> ----- Original Message -----
> From: "jessica" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 10:09 AM
> Subject: Deleted user
>
>
> > I've made a stupid error. While logged in as root I was deleting
> > records from the user table. Someone was talking to me while I was
> > entering a command and I didn't realize what I entered until it was
> too
> > late. I entered:
> > delete from user where user='root';
> >
> > I immediately used an insert statement to re-insert the root entry,
> but
> > it's not working. I can still log in as root but appear to have
> lost
> > access to the mysql database.
> >
> > Is there any way to recover?
> >
> > Thanks,
> > Bob
> >
> >
> >
> >
>
>
> ----------------------------------------------------------------------
> ----------
>
>
> > --------------------------------------------------------------------
> -
> > 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
>
>
> ---------------------------------------------------------------------
> 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 <mysql-unsubscribe-sam=fast
[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ===================================================
> This message has been virus scanned by Messagelabs.
> ===================================================
==============================================================================
This message has been checked for all known viruses by MessageLabs.
This message is intended for the stated recipients only and may be confidential.
Opinions expressed in this email do not necessarily reflect the opinions of GlobePost
Travel or Travelselect.com. If you are not the intended recipient of this message,
please notify the sender immediately.
==============================================================================
---------------------------------------------------------------------
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
