MySQL Grants are Self-Revoking

February 8th, 2007 | Categories: Linux, MySQL, Security | Tags:

I have a very old MySQL server (release 3.23.58) that is loosing its privilege information (i.e. the GRANTs).

I've performed a full dump of the tables in the mysql database and have restored them to a newly created database.

$ mysqladmin create p
$ mysqldump mysql | mysql p

After shutting down the server and switching the mysql and p database directories, I brought the server back up, but there is no change. The privileges on two database tables are simply disappearing.

Any ideas, anybody?

No comments yet.