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 Kyle Damken
Kyle Damken
10,633 Points

This video is out of date, so I wrote a guide on how to set up the current version of MySQL Workbench for OS X

Not a question, just a link to the guide I wrote on how to do this, so other students don't have do go through the same headache : )

http://kyledamken.wordpress.com/2014/12/28/new-terms-from-treehouse-database-foundations-part-1-introduction-to-data-databases-and-sql-installing-mysql-server-and-mysql-workbench-reading-data-from-databases-with-sql-and-creatin/#install

Francois Martel
Francois Martel
24,694 Points

Thanks a lot man, this is really helpful

Product Team
Product Team
6,835 Points

Thank you

Nathan McElwain
Nathan McElwain
4,575 Points

Awesome

Kevin Mulhern
Kevin Mulhern
20,374 Points

Thanks a ton man, I forgot to start my server in the system preferences lol

Víctor Rico
Víctor Rico
17,808 Points

Thanks a lot!!!

Lucy Cockerill
Lucy Cockerill
8,798 Points

Thank you! :)

Stephen Poole
Stephen Poole
9,361 Points

Somebody give this man a medal. Well done Kyle, not sure what I would have done without this! Thank you!

14 Answers

Seph Cordovano
Seph Cordovano
17,400 Points

Wow, thanks so much man! #lifesaver (I wish there was a way to up-vote this question/helper-post to keep it at the top)

Kyle Damken
Kyle Damken
10,633 Points
Kyle Damken
Kyle Damken
10,633 Points

Hey Gerald, sorry for the delay, I've been off of treehouse the past few days working on some projects. When I say system preferences I mean for your mac. Click the apple icon in the top left > system preferences and you should see MySQL there at the bottom. I took a screenshot to show you where I mean - https://imgur.com/96RACQm

Go to MySQL and make sure that you click Start MySQL Server.

gerald blady
gerald blady
9,052 Points
gerald blady
gerald blady
9,052 Points

I'm stuck here

http://i.gyazo.com/64f89772b8e21216bafd6b1f9a4138f6.png

Can you please help?

When you say under system preferences are you referring to in the app or actually under system preferences from my mac?

Lolo Handricks
seal-mask
.a{fill-rule:evenodd;}techdegree
Lolo Handricks
Front End Web Development Techdegree Student 10,706 Points
Lolo Handricks
.a{fill-rule:evenodd;}techdegree
Lolo Handricks
Front End Web Development Techdegree Student 10,706 Points

Thank you so much! V. helpful!

David Lin
seal-mask
.a{fill-rule:evenodd;}techdegree
David Lin
Full Stack JavaScript Techdegree Student 8,116 Points
David Lin
.a{fill-rule:evenodd;}techdegree
David Lin
Full Stack JavaScript Techdegree Student 8,116 Points

Every time I try to connect MySQL Server through workbench, it always asks me for service password, why?

Seph Cordovano
Seph Cordovano
17,400 Points
Seph Cordovano
Seph Cordovano
17,400 Points

David Lin, have you tried giving this a once-over? It may be just as easy as updating the user roles.

Sahil Arora
Sahil Arora
477 Points
Sahil Arora
Sahil Arora
477 Points

Thanks ! :)

Raheem Huseinbhai
PLUS
Raheem Huseinbhai
Courses Plus Student 1,222 Points
Raheem Huseinbhai
Raheem Huseinbhai
Courses Plus Student 1,222 Points

Thank you

Brian Coffelt
Brian Coffelt
12,071 Points
Brian Coffelt
Brian Coffelt
12,071 Points

Thank you

Yann Vanhalewyn
Yann Vanhalewyn
18,687 Points
Yann Vanhalewyn
Yann Vanhalewyn
18,687 Points

Awesome! This saved me a good amount of time. Thanks!

Eric Hodgins
Eric Hodgins
29,207 Points
Eric Hodgins
Eric Hodgins
29,207 Points

Thanks a lot! Well written too. I also wish there was a way to give points or something for that.

dotz
dotz
6,733 Points
dotz
dotz
6,733 Points

I installed (or at least I think I did) the .cnf file but my machine says "error: File /etc/my.cnf doesn't exist". When I enter my system password after typing in what Kyle suggested it reads:

cp [-R [-H | -L ] | -P]] [-fi | -n] [-apvX] source_file target_file next line same until source_file ... target_directory

Was it installed?

I have a space between cp and /usr - should there be one?

Also I'm using a new machine, OSX 10.10 but following guidelines for 10.9 if that matters.

Thanks everyone (and Kyle!)

Kyle Damken
Kyle Damken
10,633 Points

Hey Dotz,

Glad the guide helped! It's been quite a while since I've done these lessons and wrote that guide though, and I haven't been using MySQL Workbench that much in the meantime. Have you tried uninstalling it and reinstalling it? Hopefully someone else here will be able to help you if it doesn't.

Misty Shaw
Misty Shaw
10,825 Points
Misty Shaw
Misty Shaw
10,825 Points

Sending another "thank you", Kyle! The instructions for installing MySQL Workbench on OS X have been very helpful.

Rajiv Barton
Rajiv Barton
12,051 Points
Rajiv Barton
Rajiv Barton
12,051 Points

You the man!