Re: Start from scratch

2001-01-28 Thread John-Mark

OK I get what you mean except that I installed on debian potato and
therefore do not have the reinit step since I used apt-get. Do you have any
ideas on this one.
Thanks again jm
- Original Message -
From: "Artem Koutchine" [EMAIL PROTECTED]
To: "John-Mark" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, January 28, 2001 1:35 PM
Subject: Re: Start from scratch


 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




newbie grant problems

2001-01-23 Thread John-Mark

Hello all I am very new to this so please have patience with this
question.
I have recently installed mysql on debian potato and after installing I
was able to get a mysql prompt by typing mysql at the normal; user prompt
(not root) I thought that this was good. However I now get
ERROR 1045: access denied for user: 'root@localhost' (Using password: (NO)
when I try typing mysql at the root prompt. I have read the manual but as
yet
have not managed to set any grant tables can anyone point me in the right
direction
Many thanks
-
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