On Thu, Mar 23, 2006 at 07:15:45AM +0000, Nelson Menezes wrote: > Chris Wakefield wrote: > >Since I can't log in as root, how can I recreate these users? > > First, stop the server and back up your data directory. Should be > /var/lib/mysql.
Eek. Better way: start mysqld with --skip-grant-tables, which makes it ignore permissions. Then you can set root's password, and restart mysqld normally. Hamish -- Hamish Moffatt VK3SB <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]