Chapter 28. Managing Security
Database servers usually contain critical data, and ensuring the safety and integrity of that data requires that access control be used. In this chapter you’ll learn about MySQL access control and user management.
Understanding Access Control
The basis of security for your MySQL server is this: Users should have appropriate access to the data they need, no more and no less. In other words, users should not have too much access to too much data.
Consider the following:
Most users need to read and write data from tables, but few users will ever need to be able to create and drop tables.
Some users might need to read tables but might not need to update them.
You might want to allow users to add data, but not delete data.
Get MySQL® Crash Course now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
