Log in as root and run: set password = ''; OR update mysql.user set Password='' where User='root';
this is TOTALLY INSECURE but if that's what you want, then it should do the trick. Regards, Darren Cassar www.mysqlpreacher.com www.securich.com On Wed, Aug 26, 2009 at 2:33 AM, 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=i...@mysqlpreacher.com > >
