TEST DB CONNECTION PROBLEMS

MySQL Workbench has changed quite a bit since this video was made. I'll lay out the current steps needed to get this running on OSX, and I hope this provides your solution if just by adjusting your settings or reinstallation of the workbench and/or MySQL server entirely.

1) Click the Apple icon on the top left of your screen, then click "About This Mac" and make a not of what OSX version you have currently installed.

2) Visit the Download MySQL Page and download & install the DMG Archive package that fits your OSX version (Mine is 10.10.2 so the 'Mac OS X 10.9 (x86, 64-bit), DMG Archive' package works for me). Note: You will only get the .pkg file from this download because the optional 'MySQL.prefPane' file is now a default option to install in the installer application. If you just enter in your password and keep clicking continue, it and the other defaults will be installed just fine.

3) Download and install the MySQL Utilities from the MySQL Utilities Page. Make sure you choose the DMG file that fits your OSX version. (Mine is 10.9 since I have 10.10.2)

4) Download & install the MySQL Workbench from the MySQL Workbench Page (make sure that you have the 'Mac OS X' platform option selected), and move the app icon into your applications folder.

5) Copy the example config file:

1. Type Command ⌘ – Space Bar to get the Spotlight Search open, type "terminal" and hit enter. To open the terminal app.
2. Type $ sudo cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf at the command prompt (You may get a warning about using the 'sudo' command, but it's ok in this case).
3. Enter your account's password.

6) Open up the MySQL Workbench app. You're going to get the 'home' screen, which is totally different from what's in the video, but that's ok.

1. Either type Command ⌘ – U or click 'Database > Connect to Database...' in the navigation bar to make sure you can connect to the new database.
2. The Hostname (127.0.0.1), Port (3306), and Username (root) should all be the same as in the video by default. Make sure they are and click 'ok.'
3. Now you should have a new view in the app with at least the a 'Query 1' tab, and the 'MANAGEMENT' pane on the left. Click 'Server Status' and look at the opened 'Administration' tab to check if your server is running. If not click the 'INSTANCE' button, then click the 'Start Server' button. It will ask you for your password, and just enter in your computer account's password. Do the same if it asks you when you stop the server as well.

After this you should have your MySQL server running at localhost, and ready to go!

Hope this helped. :)

thanx !

Amazing Ben! Truly great step by step explanation!

Thank you for this! Great update

Ben...

You're the best!