MySQL, 5th Edition

13. Security and Access Control

As a MySQL administrator, you are responsible for keeping databases secure so data can be accessed by only those who have the proper authorization. To accomplish this goal, you must maintain the security and integrity of your MySQL installation. Chapter 12, “General MySQL Administration,” already touched on a security-related topic; namely, the importance of assigning passwords to MySQL accounts. That topic was dealt with as part of the process of getting your installation up and running. In this chapter, we’ll look at security issues more closely:

• Why security is important and what kind of attacks you must guard against

• Internal security risks you face from other users with login accounts on the server host ...