In this chapter, we cover some more advanced MySQL topics, including advanced privileges, security, and optimization.
Key topics covered in this chapter include
Understanding the privilege system in detail
Making your MySQL database secure
Getting more information about databases
Speeding things up with indexes
Optimizing your database
Backing up and recovering
Chapter 9, “Creating Your Web Database,” described the process of setting up users and granting them privileges. You saw how to do this with the
GRANT command. If you're going to administer a MySQL database, understanding exactly what
GRANT does and how it works can be useful.
When you issue ...