From: Walter Heck - OlinData.com (listsolindata.com)
Date: Tue Aug 25 2009 - 22:51:51 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.combluepolka.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=listsolindata.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]