> 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
---------------------------------------------------------------------
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