List:General Discussion« Previous MessageNext Message »
From:Darren Cassar Date:August 26 2009 8:22am
Subject:Re: reverting to passwd-less root w/out --skip-grant-tables
View as plain text  
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
>
>

Thread
reverting to passwd-less root w/out --skip-grant-tablesJoe26 Aug
  • Re: reverting to passwd-less root w/out --skip-grant-tablesWalter Heck - OlinData.com26 Aug
    • Re: reverting to passwd-less root w/out --skip-grant-tablesJoe26 Aug
  • Re: reverting to passwd-less root w/out --skip-grant-tablesDarren Cassar26 Aug