A Quick Guide To Install and Set Up MySQL Workbench
Uploaded by
onemail.bharA Quick Guide To Install and Set Up MySQL Workbench
Uploaded by
onemail.bharQuick Guide to Installing and Setting Up MySQL Workbench
If you want to install MySQL Workbench on your own computer:
Go to: http://www.mysql.com/downloads/workbench/
Windows Users:
1) You will need to install the Microsoft .NET Framework 4 Client Profiles and the Visual C++
Redistributable for Visual Studio 2013. This has some basic software that MySQL Workbench needs
to run. There are instructions how to get this software under “MySQL Workbench Prerequisites” on
that download page. In most of case you don’t need to do anything about this.
2) Select “Microsoft Windows” from the “Select Platform” drop-down menu.
Click on the button “Download” of the option “Windows (x86, 32-bit), MySQL Installer MSI” from
the “Recommended Download” .
3) You’ll see another download page – choose either install option under “Windows (x86, 32-bit), MSI
Installer 5.7.17”. The first one downloads the full set of software during the installation; the second
one downloads the full set of software immediately.” It doesn’t matter which one you choose.
4) At the “Begin Your Download” page, you don’t have to login or sign up – just click “No thanks, just
start my download.”
5) After your installer is downloaded, double-click on the icon to install the software. Click “YES” to the
message “Do you want to allow this app to make changes to your device” popped up by the system.
6) Accept the license terms. Click “Next.”
7) At the next dialog, click “Custom” as the Setup Type. Click “Next.”
8) At the next dialog, double-click on “Applications,” the double-click on “MySQL Workbench,” then
double-click on “MySQL Workbench 6.3.”
9) You’ll see two options – MySQL Workbench 6.3.8 – X86 and X64. If you have a 32-bit version of
Windows, click once on X86. If you have a 64-bit version of Windows, click on X64.
(If you don’t know, click on X86.)
10) Click on the green arrow pointing to the right to move that entry into the Products/Features To Be
Installed column. Then click “Next.”
Quick Guide to MySQL Workbench Page 2
11) Then click “Execute” to install the software.
Mac Users:
1) Select “Mac OS X” from the “Select Platform” drop-down menu. Download MySQL Workbench 6.3.8.
It will be your only choice.
2) At the “Begin Your Download” page, you don’t have to login or sign up – just click “No thanks, just
start my download.”
3) Install the software just like you would any other program (double-click on the installer and follow
the instructions to install the software on your computer).
Setting up a connection in SQL Workbench (in the lab or your own laptop):
1) If you’re working outside of Temple’s campus, you can skip to step 2.
If you’re on a lab computer, make sure you have logged in with your own MIS username.
Otherwise, you might accidentally log in to SQL Workbench as someone else. If the computer is
already logged in, log out first!
If you are on your own laptop on Temple’s campus, make sure you are connected through the
TUSecure wireless network. To get instructions for connecting to TUSecure visit:
http://www.temple.edu/cs/wireless/#tusecure
2) Start SQL Workbench.
3) Click on the “plus sign” next to MySQL Connections to create a new connection.
4) At the “Setup New Connection” dialog, fill in the information as follows:
Connection Name: mis2502
Hostname: dataanalytics.temple.edu
Username: Your username given to you by your instructor (Please click here to access your
username and password. You need to log in with your TUID.)
Quick Guide to MySQL Workbench Page 3
(If it says that “mis2502” is already taken, make the connection name something else (i.e.,
“mis2502a”. Any name is ok for this.)
5) Click “OK” and you’ll see the connection under “MySQL Connections”:
Click on the connection. Make sure the user name matches your ID (it should NOT be test0)!
6) It will ask you for your password. Enter your password (it’s case sensitive) and click OK.
(If you’re in a lab, don’t save your password in the vault or other people will be able to access your
account!)
7) You’ll see the main window for MySQL Workbench:
Quick Guide to MySQL Workbench Page 4
All you really care about is the Query 1 tab on the right and the SCHEMAS section on the left.
8) Try a query. In the SQL File 1 window, type:
Then click the lightning bolt to execute the query:
You’ll see output like this:
Quick Guide to MySQL Workbench Page 5
