Page 1 of 1

Securing privilege table structure

Posted: Thu Sep 30, 2004 6:34 am
by visionmaster
Hello,

I have some questions in securing MySQL and its databases.

1. I don't only want to secure databases using mysqldump, I really want to mirror MySQL in a whole. Just for cases a fatal error happens when configuring a running database and I have to get MySQL back running quickly. How do I do that?


2. I want to insert a new user, following warning is displayed:

Warning: Your privilege table structure seem to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

I'm afraid as soon as I add an additional user, the database will not work. Can I just mysqldump the table 'mysql' and play back the dump if any problems occur. Or will that make problems regarding the encrypted passwords in any way?

Running mysql_fix_privilege_tables also seems very suspect to me...

Thanks for any help!

Posted: Thu Sep 30, 2004 6:44 am
by twigletmac
Looks like you may have updated from MySQL 3.x to 4.x - if so then you do need to run the fix script to ensure that your privilege table is in the new format.

Mac

Posted: Thu Sep 30, 2004 7:04 am
by visionmaster
Thanks for your response. So, can I backup the database 'mysql' before I do any fatal experementing? Would appreciate some detailed answers to my above questions.

Thanks a lot!

Posted: Thu Sep 30, 2004 7:52 am
by timvw
how hard is it to read the mysql manual?

Posted: Thu Sep 30, 2004 7:57 am
by twigletmac
The fix script shouldn't be fatal, but there's no reason why you can't backup the mysql database beforehand as you would do any other backup. Best source of info on this is, as timvw pointed out, the MySQL manual.

Mac