Job Ready Python

Appendix CInstalling MySQL

MySQL is a relational database management system (RDBMS) that runs as a server providing multiuser access to multiple databases. Many Python programmers use MySQL with their Python applications. This appendix provides instructions for installing MySQL. By the end of this appendix, you should be able to have a MySQL database server and client working on your local system.

MySQL INSTALLATION

You can download and install MySQL using an installer. We're going to use MySQL's MSI installer to install MySQL to Windows. It installs everything we need for MySQL development and makes the 32-/64-bit decision for us.

NOTE During installation, you will be asked to set the MySQL root user password. It is critical that you do not forget your root password. If you forget it, you won't be able to use your tools.

Download and Install MySQL

Browse to MySQL's download page at https://dev.mysql.com/downloads/windows/installer/. This should present you with options to select an MSI Installer. By default, Microsoft Windows should be selected for the Operating System. If you are using a different operating system, you can select it from the drop-down list. Note that this appendix will focus on Microsoft Windows; however, installing on other operating systems should be similar.

Two options are likely to be presented. Either download will work. The first is smaller because it fetches the necessary resources from the web. This means that the initial download is fast, ...