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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.