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!
Securing privilege table structure
Moderator: General Moderators
-
visionmaster
- Forum Contributor
- Posts: 139
- Joined: Wed Jul 14, 2004 4:06 am
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
-
visionmaster
- Forum Contributor
- Posts: 139
- Joined: Wed Jul 14, 2004 4:06 am
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK