Why not just reinit the database as specified in the
last step on install (after make install) in the manual.
No need to delete your database, just back them up
somewhere else. Then delete eveyrthing in your
localstatedir (where thedatabases are) including
'mysql' dir. Do reinit, and copy back all databases
except the 'mysql' database. Now you are at the
original start position.
----- Original Message -----
From: "John-Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 28, 2001 4:17 PM
Subject: Start from scratch
> Hello all
> I have made a mess of the grant table and have no way now of gaining
access
> to any of the databases I have set up or tables. Is there any way I
can
> start from scratch with the grant table by going back to a situation
were
> all databases are deleted and no access privileges are set up. is it
> nessassary to reinstall mysql to achieve this or is there another
way. I am
> running debian potato. If I do need to reinstall how do I completely
> UN install first.
> Many thanks in advance
> John-Mark
> --
> John-Mark
>
> --------------------------------------------------------------------
-
> 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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
