Skip to content

Instantly share code, notes, and snippets.

@darthneel

darthneel/mysql_install.md

Last active December 10, 2015 21:24
Show Gist options
  • Save darthneel/cd12df02faa58cc65013 to your computer and use it in GitHub Desktop.
Save darthneel/cd12df02faa58cc65013 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_install.md

What to install before coming to the SQL Bootcamp

Everyone will need to install two tools to follow along during class:

  • MySQL Server, a mostly invisible program which stores information.
  • MySQL Workbench, a program designed to help you interact with the server.

Here's what to do:

1. Download and install the official MySQL server.

  • Go to the MySQL Server download page.
  • Scroll down and click "Looking for previous GA versions?".
  • Select version 5.5.74 in the dropdown box to the left.
  • What kind of computer do you have?
    • Get the 64-bit version if you happen to know that you have a 64-bit machine.
    • If you aren't sure, don't worry! Just get the 32-bit version, and it will work fine.

Apple OS X

  • Download the "DMG Archive".
  • Double-click the archive to open it.
  • Double-click the ".pkg" file starting with "mysql".
  • You'll get a dialogue saying that it can't be opened because the developer is unknown.
  • Go to the Security & Privacy pane in your System Preferences.
  • You'll see an entry for the file you just clicked at the bottom--hit the "Open Anyway" button.
  • Hit "Continue" until the installer is finished.
  • Double-click the "MySQL.prefPane" file.
  • You'll get another "developer unknown" dialogue.
  • Repeat the "Open Anyway" trick from a moment ago.
  • Click the "Start MySQL Server" button in the new preference pane.

Windows

  • Download the "MSI Installer".
  • Double-click the installer to open it.
  • Click "Next" until the the installer is finished.

2. Download and install MySQL Workbench

3. Lets test it all out.

  • Make sure MySQL Server is running and try to open the MySQL Workbench application.
  • If a connection doesn't pick up automatically, click the '+' icon near the top left of the screen.
  • Fill in the below information
    • Host Name: 127.0.0.1 (it may default to saying 'localhost' which is also fine)
    • Port: 3306
    • User Name: root
    • Password: Password should be empty
  • Click the Test Connection button and you should see a message similar to 'Connected to MySQL at 127.0.0.1:3306 with user root
  • Click the OK button to finish the set up.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment