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 ...

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.

Start your free trial