Is there a specific reason you cannot do it with --skip-grant-table? You should theoretically also be able to overwrite the files user.* (there should be 3) in /var/lib/mysql/mysql/ (replace everything up to and including teh first mysql in that path with your mysql data dir) when the server is stopped with a copy from a fresh install. That will wipe all users in your database though, and might have unforeseen consequences depending on what you had defined before.
Backup first though! Walter On Wed, Aug 26, 2009 at 03:33, Joe<mysql....@bluepolka.net> wrote: > I'm trying to get back to an earlier state where we started > mysqld withOUT --skip-grant-tables but the root user had no > password. Yes, insecure, but we're in restoration mode here. > > How do I reset/revert the root password to no password without > running with --skip-grant-tables? > > Thanks in advance. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org