On Wed, Jun 13, 2001 at 04:56:23PM -0400, RIDLEY, JAMES A. (AIT) wrote:
Hi,
> I somehow locked out the root account from MySQL. How can I get access back
> as root on the Unix system?
Try this :
/path/to/mysql-directory/libexec/mysqld --skip-grant-tables
In a second term, just run mysql -p -> password: <hit enter>
Works for me...
> James A Ridley
> System Administrator
> AIX ITO Midrange Support
> Ameritech/SBC Telecommunications Inc.
> (317)265-4252 work
> (317)673-3670 pager
--
Met vriendelijke groet/With kind regards,
Cable & Wireless http://www.widexs.nl
Wouter de Jong System-Administrator
Tel +31 23 5698070 Fax +31 23 5698099
Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL
---------------------------------------------------------------------
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