I've been getting some strange behaviours from MySQL:
After setting the root password, connection to the DB is no problem. But after a certain amount of time with many restarts and stoppages, the root password seems to automatically reset itself. This is done without any modifications to the database.
We are running MySQL in Windows 2000 and using "net start mysql" and "net stop mysql" to start and stop the DB.