Derek Fage wrote:
> 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....
Restart Mysqld as below.... SORRY Syntax error on Command Prompt
Bad advice is worst then no advice : ^)
>
>
> #/mysql/bin/> mysqld -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
---------------------------------------------------------------------
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