>> On Wed, Aug 26, 2009 at 02:12, Joe<mysql.com@stripped>
>> > 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'
So connect to it from somewhere other than localhost. :-)
Specifically from the bogus IP you set it to.
Let's say you used the bogus IP of 10.200.100.20.
1. Give the mysql server the IP 10.200.100.10 and a netmask 255.255.255.0.
2. On some other machine on the same LAN, give it the bogus IP with
the same netmask.
3. No need to worry about routes, it's on the same LAN.
4. On the other machine, connect using 'mysql -h10.200.100.10 -uroot
-p'. When you enter the correct password, it should let you in.
* I don't know if you'll need to restart mysql for it to bind to the
new IP. I don't think so, but then again I have not tested it.