The MySQL User Privilege System

MySQL has a sophisticated user privilege system that allows precise control of user privileges, whether users have powers across the server or are restricted to one or a number of its databases. Although MySQL complies with ANSI-92, its user privilege system goes beyond the ANSI standard.

Under the MySQL privilege system, you can grant a user access across the server, or you can limit users at a database, table, or even column level, with close control over what each user is allowed to do and where, such as whether the user can view or modify data. You can require users to connect to MySQL from a specific host machine or domain, and you can vary their level of privilege according to where they connect from.

For ...

Get Sams Teach Yourself MySQL in 21 Days, Second Edition 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.