Read section 6.3 of the manual - restart mysqld with --skip-grant-tables.
Dave
At 10:35 18/05/01 +1000, you wrote:
>Hi all,
>
>
>Just a quick question. A friend of mine installed a mysql on a new FreeBSD
>box, and for some reason the root password wasnt empty. He has root access
>on the box but cant get into mysql as root to make the needed changes to
>mysql ready for use.
>
>Is there any way a user logged on as root can reset the mysql root
>password so he can go in and reset it ?
>
>
>Thanks
>
>
>Chris
---------------------------------------------------------------------
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
