Hi Bob,
Sorry to appear a bit dense, but how do I use the -Skip-grant?
I don't see a -Skip-grant option in mysql (mysql --help)
Thanks,
Derek...
-----Original Message-----
From: R Talbot [mailto:[EMAIL PROTECTED]]
Sent: 22 September 2001 11:57
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Help - I'm completely locked out of mysql
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
> mysql
>Subject: Help - I'm completely locked out of mysql
>From: Derek Fage <[EMAIL PROTECTED]>
>Date: 2001-09-22 14:36:08
>[Download message RAW]
>
Hi there,
If your forgot yout root password try....
#/bin/mysql > -Skip-grant
use mysql;
UPDATE user SET password = password
('newpassword')
Where User = 'root';
Exit
#bin/mysql> mysqladmin reload
Restart Mysql for the new password
Been There Done This : ^)
Bob T
***************************************************************************************
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of Foreshore Limited.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]
---------------------------------------------------------------------
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
