I actually get the feeling you are not connecting as root. Try mysql -uroot -p test instead of just mysql test
Have a nice day, - Martijn On Wed, Aug 26, 2009 at 03:02, Joe<mysql....@bluepolka.net> wrote: > 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....@bluepolka.net> > 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=li...@olindata.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mart...@crystal-labs.nl > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
