Lesson 5Working with MySQL Server

Up to this point you have been learning about relational database theory. Now it is time to get your hands dirty and turn theory into practice. This lesson will walk you through installing a tool that will let you enter and run SQL code. This includes installing a database, MySQL, as well as MySQL Workbench, a database management application.


MySQL is a relational database management system (RDBMS) that runs as a server providing multi‐user access to multiple databases. This section will cover the steps of installing MySQL. During installation, you will be asked to set the MySQL root user password.

MySQL's installer will be used for the installation. It installs everything needed for MySQL development and makes the 32‐/64‐bit decision for you.

Step 1: Get the Download

Browse to the MySQL download page at dev.mysql.com/downloads/windows/installer. If necessary, scroll down a bit until you see the downloads, similar to what is ...

Get Job Ready SQL 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.