MySQL WorkBench Setup

This guide is based on:

• MySQL 5.7.28
• MySQL Workbench 8.0 CE
• WAMP 3.2

Check requirements for WAMP & use MySQL in WAMP:

1. Download the tool for checking if you have all the versions of Microsoft Visual C++ Redistributable installed
   • If not, go to this page to find the permalinks for them.
2. After installing all the required vcredist, download and install WAMP, and run for the first time.
3. After WAMP is installed and running, right-click on it in the task bar, and mouse-over Wamp Settings
   
4. Uncheck Allow MariaDB
5. Right-click on it in the task bar, and mouse-over Tools (optional)
   
6. Mouse-over Delete unused versions and select Delete mariadb (optional)
   

Setting up the database with MySQL Workbench & WAMP:

1. Install all the above mentioned software, and make sure WAMP is running (icon is green the the tray)
   
2. Turn off strict mode for MySQL Workbench
   • See how here
3. Open MySQL Workbench, and add a new connection
   
4. Give a connection a name you like
   
   • You may or may not need to set SSL option to 'No"
     
5. In the ribbon on top, select the option to run a SQL script
   
6. Run AzureSQLWithData
   
   Note: You may also use the ElectronMS script to start with a clean slate.

You may now turn strict mode back on, if you'd like.