You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe 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=arch...@jab.org