Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Installing MySQL Server and MySQL Workbench Installing MySQL Server and Workbench on OS X

Posted by Beth Singley
Beth Singley
3,491 Points

starting over

Help. I need to start over in installing as I have no idea where I went wrong but there's no icon in the sys preferences (mac) and the workbench can't connect and terminal doesn't recognize and mysql commands.

However, the internet is full of warnings around installing more than one version of mysql on one machine. How do I strip out anything that I've previously installed and go back to a clean slate?

3 Answers

Evan Goodwin
PLUS
Evan Goodwin
Courses Plus Student 22,260 Points
Evan Goodwin
Evan Goodwin
Courses Plus Student 22,260 Points

I think this way of installing mysql server is outdated. You should install the server through homebrew. This video shows how and allows you to set up the password.

If you already installed as instruction in the video, the homebrew install will say you already have a copy and instruct you how to unlink (uninstall) that installation. after unliking, install through home brew at terminal (homebrew install mysql).

The workbench layout has changed, so to set your connection you click + in the circle next to MySQL connections. You add a name for the connection in the top field (ex Treehousemysql). Leave hostname and user (as root). Click 'store in keychain' by password and input the password you created during the homebrew install. This brings up the screen you see in the tutorial.

Start the server (under Instance in left column). After server is running, click File-Open SQL script and navigate to the treehouse movie db you downloaded. SQL code will appear. Click the lightning bolt and this loads the data in the db (treehouse movies should appear under Schemas). Then you can run the queries in the Query 1 tab.

Colby Wise
Colby Wise
3,165 Points
Colby Wise
Colby Wise
3,165 Points

I followed the exact steps outlined by Evan and got it working however I installed mySQL vr 5.7 not 5.6 via Homebrew. I followed this tutorial which walked through install to password change: https://gist.github.com/nrollr/a8d156206fa1e53c6cd6

johndupper
johndupper
12,558 Points
johndupper
johndupper
12,558 Points

Beth, I was having similar troubles. I had installed the most up-to-date version of MySQL and panicked when I couldn't follow along. By the time I read Andrew's note about downloading the archived version to correspond to the videos it was too late... I then tried to install the old version but I couldn't because I had a newer version installed already. My advice is to run sudo rm -rf /var/db/receipts/com.mysql.* in terminal and then install the older version. It worked for me - I hope this helps! Keep learning. :) -- John