Chapter 4: Setting Up MySQL
In This Chapter
Checking whether MySQL needs to be installed
Installing MySQL on Windows, Mac, or Linux
Testing MySQL
Activating MySQL
Troubleshooting the MySQL installation
The MySQL environment includes both the MySQL database software and support programs that you can use to administer your MySQL databases. The MySQL software consists of the MySQL database server, several utility programs that assist in the administration of MySQL databases, and some supporting software that the MySQL server needs (but you don’t need to know about). The heart of MySQL is the MySQL server, which manages the databases. When you interact with a database, you send messages with requests to the database server, which responds by following the instructions in the requests — store data, get data, and so forth.
To use the MySQL databases, you need to use software that can communicate with the MySQL server. When you install MySQL, the mysql client program is automatically installed. ...