Marcus, Check the options page
http://www.mysql.com/doc/C/o/Command-line_options.html for the startup option --skip-grant-tables and note the instructions about flushing or reloading after you have restored the root password. (And, next time, don't get so excited that you forget to check the archives. ;) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka ----- Original Message ----- From: "Marcus - Videomoviehouse.com" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 11:59 AM Subject: Is Addition To Previous Post > Here are some results from what I have tried in a addition to my > previous post. > > mysql> GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'pasword'; > ERROR 1045: Access denied for user: 'root@localhost' (Using password: > YES) > mysql> show GRANTS for root@localhost; > +----------------------------------------------------------------------- > -------------------------------+ > | Grants for root@localhost > | > +----------------------------------------------------------------------- > -------------------------------+ > | GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD > '5555555555' WITH GRANT OPTION | > +----------------------------------------------------------------------- > -------------------------------+ > 1 row in set (0.00 sec) > > mysql> > > I can set the USAGE setting but anything else I get access denied, I > have run out of options please help. I am guessing next thing would be > to re-install mysql and rebuild the server? If I copy my tables from my > var directory can I copy them back after and have it work? > --------------------------------------------------------------------- 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