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