MySQL Tutorial

11.Managing User Privileges

One of MySQL's strengths is its advanced user privilege system. In this chapter, we'll discuss user account creation, the different privileges available, and how these privileges are represented within MySQL tables. We'll cover the following:

• Creating user accounts with GRANT and REVOKE

• Privilege levels

• Understanding the privilege tables

Creating User Accounts with GRANT and REVOKE

User privileges are given with the GRANT statement and are taken away with the REVOKE statement. These are standard SQL statements that you can execute like any other statement in this book. All MySQL user information and user privileges are eventually stored in a MySQL database, just like your own applications.