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.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:
> http://lists.mysql.com/mysql?unsub=1
>
>
