Chapter 4: Setting Up MySQL

In This Chapter

arrow.png Checking whether MySQL needs to be installed

arrow.png Installing MySQL on Windows, Mac, or Linux

arrow.png Testing MySQL

arrow.png Activating MySQL

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

Get PHP, MySQL, JavaScript & HTML5 All-in-One 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.