Hi Hamish, Thank you for your response.
I have been trying exactly what you suggested, but mysql ignores the new password, so I think something else is wrong. Chris W. On Thursday 23 March 2006 15:21, Hamish Moffatt wrote: > 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]

