Chapter 6. User Management and Security
MySQL is a multi-user database with a sophisticated access control system. The phrases in this Chapter will show you how to maintain the users on your database and to give each user only the permissions he requires.
MySQL’s privilege system ensures that each user may only perform the operations that he is allowed. A user’s identity is determined by a given username and the remote address from which the connection is made. A user is also usually required to authenticate by providing a password when connecting to the database.
Tip
You need specific administrator privileges to perform each of the commands in this Chapter. If you connect to MySQL as the root user—typical for performing user maintenance—you have ...
Get MySQL 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.
