6/11/24, 11:23 PM Topic: MySQL Installation Instructions for Windows and Mac
Press ALT + F8 to see a list of keyboard shortcuts
MySQL Installation Instructions for Windows and Mac
All Sections
MySQL Installation Instructions for Windows PCs
In order to install MySQL:
1. Go to dev.mysql.com/downloads/installer (http://dev.mysql.com/downloads/installer)
2. Download the Community Edition.
This seems to be the best option to install:
mysql-installer-community file (second option)
3. Here is an excellent YouTube video (https://youtu.be/FDd2tftN5IA) that will give you step-by-step
instructions for installing MySQL Server and the MySQL Workbench, which is a great tool for creating
your databases and running your queries.
4. It takes about 15 minutes to install.
MySQL Installation Instructions for Macs
There are three steps to getting started on Mac OS:
1. Install the MySQL Server
2. Install the MySQL Workbench (the GUI that will manage your database)
3. Install the MySQL Employees Sample Database
STEP 1: Install the MySQL Community Server
• Go to MySQL Community Downloads (https://dev.mysql.com/downloads/
(https://dev.mysql.com/downloads/) )
• Select MySQL Community Server.
• Choose macOS for your operating system.
• Download the DMV Archive.
• Once downloaded, run the installer.
STEP 2: Install the MySQL Workbench
• Navigate back to MySQL Community Downloads (https://dev.mysql.com/downloads/
(https://dev.mysql.com/downloads/) )
https://classroom.ucsc-extension.edu/courses/7497/discussion_topics/85284 1/2
6/11/24, 11:23 PM Topic: MySQL Installation Instructions for Windows and Mac
• Select MySQL Workbench.
• Choose macOS for your operating system.
• Download the DMV Archive.
• Once downloaded, drag the MySQL Workbench icon into your Applications folder.
• Open MySQL Workbench.
• If Workbench doesn’t automatically recognize your instance, create a new connection by pressing the
[+] button next to MySQL Connections.
• Name the new connection (i.e. Local Instance).
• Enter the password you chose during your server installation.
• Click on [Test Connection]. Then click on OK.
• You’ll now see your Local Instance under MySQL Connections.
Click on it to connect to your local server.
STEP 3: Import the Employee Sample Database (This is an optional step for those who wish to use this
database to follow along with the examples in the videos. It is not required).
• Download the Employee Sample Database from GitHub
(https://github.com/datacharmer/test_db (https://github.com/datacharmer/test_db) )
• Open MySQL Workbench.
• Connect to your Local Instance.
• Open the file employees.sql from your download. (Click on the second button in your Workbench
toolbar. It has an open folder in the icon.)
• Once opened, run the employees.sql script by pressing the lightning icon above the script.
• Switch to the Schemas tab in Workbench. Click on the refresh icon with two opposite-facing arrows.
• You should now see your employees database in addition to your pre-installed sys database.
Search entries or author Unread
Subscribe Subscribed
Reply
Attach
Cancel Post Reply
https://classroom.ucsc-extension.edu/courses/7497/discussion_topics/85284 2/2
