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
As discussed previously, MySQL is database management software. It manages databases that contain the information you need for the dynamic website 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. In the first few sections of this chapter, we give you the preliminary information you need to know about MySQL administration and how you can control access to your data with account names, hostnames, and passwords. ...
