Hi Luke, Yep, there is a procedure in the manual http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html here. This has all the steps you will need to get root back.
Hope it all ends up ok! Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Luke Vanderfluit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 October 2005 12:17 PM To: mysql Subject: Re: database won't load after machine reboot Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: >Hi Luke, > >Have you tried doing another GRANT statement to ensure the name and >password are indeed correct? That would be my next step. That way at >least you are sure that the name/password combination are correct. > > > I can't access the database as root anymore. Accessing as other users doesn't allow me to set any GRANT statements. Is there any way I can reset the root password? (Ouch). Kr. Luke. -- Luke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
