In this lab, you will install MySQL and log in to MySQL Workbench.
MySQL is an open-source relational database management system (RDBMS). The acronym "SQL" (sometimes pronounced "sequel") stands for Structured Query Language. SQL is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data in a database.
MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system.
In this lab, you will install the various components that make up a MySQL database, including the MySQL server and the MySQL Workbench application.
Note: Steps 2, 3 and 4 cover Windows installation; Mac users should skip to step 5.
You can download the MySQL installer here: https://dev.mysql.com/downloads/windows/installer/8.0.html
Select the second of the two options shown in the image below:
Note that you do not need to sign up for an Oracle Web account - just select "No thanks, just start my download" which can be found under the grey box with the Login and Sign up buttons.
Once you have downloaded the MySQL installer, carry out the following steps to install MySQL:
Once you have installed all the dependencies you can continue to MySQL installation.
Once the MySQL installation is complete, MySQL Workbench should launch automatically.
Under "MySQL Connections" you should see one connection (e.g. Local instance MySQL80). This is the default connection; you can see it uses the default "root" user, the localhost server and port 3306.
Double-click on the connection. You will be asked for a password; this is the password that you set during the installation process.
After entering the correct password, you should see the following view:
You are now logged in to the MySQL Workbench application. In our next lab (the onsite workshop on Friday 14th June) we will create a database and perform some simple queries on the data.
You can download the MySQL installer for macOS here: https://dev.mysql.com/downloads/mysql/
Select macOS as the operating system and choose the first option (DMG archive).
Once you have downloaded the installer, follow the steps described here to install MySQL:
https://dev.mysql.com/doc/refman/8.0/en/osx-installation-pkg.html
The MySQL Installation Package includes a MySQL preference pane that enables you to start and stop your MySQL database server. Complete the steps shown here to set this up:
https://dev.mysql.com/doc/refman/8.0/en/osx-installation-prefpane.html
Lastly, complete the following steps to install the MySQL Workbench application:
https://https://dev.mysql.com/doc/workbench/en/wb-installing-mac.html
Launch MySQL Workbench. It should look something like this:
Under "MySQL Connections" you should see one connection (e.g. Local instance MySQL80). This is the default connection; you can see it uses the default "root" user, the localhost server and port 3306.
Double-click on the connection. You will be asked for a password; this is the password that you set during the installation process.
After entering the correct password, you should see the following view:
You are now logged in to the MySQL Workbench application. In our next lab (the onsite workshop on Friday 14th June) we will create a database and perform some simple queries on the data.