Chapter 12. Advanced MySQL Administration
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
Implementing replication
Understanding the Privilege System in Detail
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 ...
Get PHP and MySQL Web Development, Third Edition 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.
