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