schroeder aj

Markus,

I did what you said, which was consistent with the MySQL do***entation (and
the steps I had done previously) but instead of re-trying to fix permissions
that I tried before, I decided to do a mysqldump and get a backup copy of
the database and then re-install MySQL.

After a re-install, I restored the backup and everything (sans a few
permissions) came back without any problems.

I wonder what the upgrade could have done? Would some corruption be caused
if mysql was "replaced" while mysql was running?

AJ Schroeder

markus popp

Hi,

the grant tables (the tables in the mysql database) are read in the
following cases:

* when you start the server
* when you run a CREATE USER, DROP USER, GRANT or REVOKE command
* when you run a FLUSH PRIVILEGES command

If you replace the data files while the server is running (which is not
recommanded, however, it shouldn't make problems if you are the only user
and no one reads from the tables while you copy the data), the server
doesn't re-read the grant tables, so the old privileges should still be in
place, until one of the mentioned three actions happen.

Markus