Chapter 2. Administering MySQL

In This Chapter

  • Administering MySQL

  • Establishing and controlling access to data

  • Creating and managing accounts

  • Backing up and restoring databases

  • Getting the newest version of MySQL

MySQL is database management software. It manages databases that contain the information you need for the dynamic Web site that you are building. Your goal is to store data in a database or retrieve data from the database. You can store and retrieve data directly (see Chapters 3 and 4 of this minibook) or store and retrieve data from PHP scripts (see Chapter 5 of this minibook). In addition, a MySQL administrator is required to ensure that MySQL performs its work correctly and efficiently. We describe MySQL administration in this chapter.

Get PHP & MySQL® Web Development All-in-One Desk Reference for Dummies® 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