When you do get the password thing taken care of, backup your mysql db by typeing:
mysqldump -u root -p > mysql_db.bak Put this file in a polace where no one will ever be able to read it and chmod 500 it. TO recover the mysql db do a:
mysql -u root -p mysql < mysql_db.bak This will keep you db, host, user, and privileges tables backed up. Also, never add a user without calling the password funciont:
INSERT INTO USER (host, user, password) VALUES('\%', 'bob', password('marley'));If you forget the password() thing, and run a flush privileges, and restart the db, all hell breaks loose. ALways run a:
SELECT * FROM USERS WHERE user = <username>
and look for the encrypted password:
Just some hints from past experiences of mine 
------------------
Wine me, dine me, 1000101 me
