Chapter 14: Database Security

Overview

Security is not an optional extra. Plugging leaks in your data security once everything is established is much harder than securing the data properly in the first place. And, as a database administrator (DBA), you may trust your users, but when they accidentally delete a table they didn't even know was there, it's you who'll be blamed. Most of this chapter deals with managing users and ensuring they can do only what they need to do.

Featured in this chapter:

• Security when connecting

• Changing and assigning passwords

• Managing users and permissions

• The MySQL permission tables

• GRANT and REVOKE

• Dangerous privileges

• Application and system security

• Security issues with LOAD DATA LOCAL