Chapter 4 Review

In this chapter, we have learned:

How to secure MySQL against attack
About the MySQL access privilege system
What is in the user, db, and host tables
Why the user table is important
Caution should be used in granting privileges
What cannot be done with privileges
The process of connecting to the server
How MySQL does connection verification and request verification
What the tables_priv, columns_priv, and procs_priv tables do
When privilege changes take effect
How MySQL handles usernames and passwords
How to add new user accounts to MySQL
How to remove user accounts from MySQL
How to limit account resources
How to assign account passwords and keep passwords secure
How to set up secure connections using SSL

Let us go to chapter 5.

© 2007 John Michael Pierobon

Notes