List:General Discussion« Previous MessageNext Message »
From:Joe Date:August 26 2009 1:02am
Subject:Re: recovery help needed
View as plain text  
OK, thanks, that got me in.  But upon inspection, the user.host 
values do not look fouled up as I thought they were (it appears 
the bogus update may have aborted).  But my access problem 
remains

If I start with --skip-grant-tables, 'show databases' shows all 
DBs.  But without that flag, I only see the 'information_schema' 
DB.

Any suggestions as to where I look from here?

On Tuesday 25 August 2009 @ 18:17, Walter Heck - OlinData.com 
wrote:
> Hey Joe,
>
> stop the server, start it with --skip-grant-tables, change the
> root entry in mysql.user to your liking, and then restart the
> server without --skip-grant-tables.
>
> viola!
>
> Walter
>
> On Wed, Aug 26, 2009 at 02:12, Joe<mysql.com@stripped> 
wrote:
> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
> > really need some help regaining access to.  While attempting
> > to adjust/add remote user access, we accidentally did the
> > following:
> >
> >  use mysql;
> >  update user set host = 'SomeBogusIP' where user = 'root';
> >
> > Now, we can't get into the DB to fix it:
> >
> > # mysql test
> > ERROR 1044 (42000): Access denied for user ''@'localhost' to
> > database 'test'
> > # mysql mysql
> > ERROR 1044 (42000): Access denied for user ''@'localhost' to
> > database 'mysql'
> >
> > We are not MySQL experts by any stretch, so any help is
> > appreciated.
> >
> >
> > Here are the files we evidently touched:
> > # ls -ltr /var/lib/mysql/mysql/
> > -rw-r----- 1 mysql mysql   5256 Aug 25 17:33 db.MYD
> > -rw-r----- 1 mysql mysql    844 Aug 25 17:35 user.MYD
> > -rw-r----- 1 mysql mysql   2048 Aug 25 17:50 user.MYI
> > -rw-r----- 1 mysql mysql   4096 Aug 25 17:50 db.MYI
> >
> > We do have a months-old copy of the 'mysql' db directory.
> >
> > 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
recovery help neededJoe26 Aug
  • Re: recovery help neededWalter Heck - OlinData.com26 Aug
    • Re: recovery help neededJoe26 Aug
      • Re: recovery help neededTodd Lyons26 Aug
      • Re: recovery help neededMartijn Engler26 Aug
        • Re: recovery help neededprabhat kumar26 Aug
  • Re: recovery help neededCarlos Proal26 Aug