MySQL Grants are Self-Revoking
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?
Leave a comment
| Trackback
