Setting up MySQL Workbench Before Week 4
We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around February 6, 2018.
(1) If you’re using your own computer (Windows or Mac), you’ll need to install the software;
If you’re using a lab computer which already has MySQL Workbench installed, you’ll still need to configure a connection to access databases with your username and password.
You can get instructions for how to do both of those things in this Quick Guide to MySQL Workbench. Use the guide to setup your software and connection.
(3) Whether you use a lab computer or your own computer, you’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Under Grades in Canvas.
- To find it, in Canvas, click Grades, then click “MySQL Account“
- You will find the MySQL username and password are added as comments to “MySQL Account.”
- The first value that starts with “m” is the username, and the second value is the password.