Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Walter Heck - OlinData.com (listsolindata.com)
Date: Tue Aug 25 2009 - 22:51:51 CDT
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!
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