Appendix C. Installing MySQL server

 

In this appendix, we’ll cover installing and setting up the MySQL database. Instructions for Windows and Linux installations are included.

C.1. Windows installation

The most convenient and recommended method is to download MySQL installer (for Windows) and let it set up all of the MySQL components on your system. The following steps explain how to do it:

1.  Download MySQL Installer from http://dev.mysql.com/downloads/installer/ and open it. Please notice that, unlike the standard MySQL installer, the smaller “web-group” version does automatically include any MySQL components, but will only download the ones you choose to install. Feel free to pick either installer. See figure C.1.

Figure C.1. Download options of MySQL installers for Windows

2.  Select the suitable Setup Type you prefer. The option Developer Default will install MySQL server and other MySQL components related to MySQL advancement, together with supportive functions such as MySQL Workbench. You can also choose Custom Setup if you want to select the MySQL items that will be installed on your system. And you can always have different versions of MySQL operate on a single system, if you wish. The MySQL notifier is useful for monitoring the running instances, stopping them, and restarting them. You can also add this later using the MySQL installer.

C.2. Linux installation