Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables &
Step # 3: Connect to mysql server using mysql client: # mysql -u root Step # 4: Setup new MySQL root user password mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit Step # 5: Stop MySQL Server: # /etc/init.d/mysql stop Step # 6: Start MySQL server and test it # /etc/init.d/mysql start # mysql -u root -p Note: You can check structure of table 'user' mysql> SHOW CREATE TABLE 'user'; And update other required fields also. Enjoy ;-) On Wed, Aug 26, 2009 at 2:36 PM, Martijn Engler <mart...@crystal-labs.nl>wrote: > 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=aim.prab...@gmail.com > > -- Best Regards, Prabhat