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

Tom Knox
Tom Knox
12,408 Points
Posted by Tom Knox
Tom Knox
12,408 Points

Using port 3307 worked for me.

I was able to determine that my server is running on port 3307. Once I changed this info in MySQL Workbench everything worked perfectly.

John King
John King
565 Points
John King
John King
565 Points

Solved things for me too, thanks.

8 Answers

Fenian Noakes
PLUS
Fenian Noakes
Courses Plus Student 5,212 Points
Fenian Noakes
Fenian Noakes
Courses Plus Student 5,212 Points

Thanks Tom! in addition to following Tom's advice and changing Port from 3306 - to 3307 I also did the following; Systems preferences > MySQL>Turn of MySQL Server then Restarted MAC then reopened the Workbench - typed in 'localhost' for connection name then updated port '3307' I then pressed the 'Configure Server Management' button - (bottom left) and simply continued through that. Once that was done - I then pressed the 'test connection' back in the 'Setup New Connection' screen and it worked. That worked for me. Cheers

Fenian Noakes
Fenian Noakes
Courses Plus Student 5,212 Points
Fenian Noakes
Fenian Noakes
Courses Plus Student 5,212 Points

noticed typo 'Turn of MySQL' was supposed to be 'Turn on MySQL'

SURAKSHA RAMESH SHETTY
SURAKSHA RAMESH SHETTY
52 Points
SURAKSHA RAMESH SHETTY
SURAKSHA RAMESH SHETTY
52 Points

Hello Fenian,

I tried changing the port to 3307, but on clicking the "Configure Server Management" and then continue, I get the following message: "Could not connect to MySQL server: Access denied for user 'root'@'localhost' (using password: YES) You may continue if the server is simply not running." In this case, may I know what is the error as it is not connecting to the server at all, even though the server is running ?

Ben Bastow
Ben Bastow
24,657 Points
Ben Bastow
Ben Bastow
24,657 Points

THANK YOU SO MUCH SERIOUSLY LIKE THEY SHOULD PUT THIS IN THE DESCRIPTION!! THIS HAS HELPED ME SO MUCH!!

Athoug Alsoughayer
Athoug Alsoughayer
7,949 Points
Athoug Alsoughayer
Athoug Alsoughayer
7,949 Points

THANK YOU! Seriously been struggling for days to get it started.

Michael O'Kane
Michael O'Kane
5,896 Points
Michael O'Kane
Michael O'Kane
5,896 Points

yeah thanks for the tip with this. I spent a number of hours trying to install it via the methods in the video with no joy but changing the port to 3307 worked first time

thanks so much

Sara Read
Sara Read
10,476 Points
Sara Read
Sara Read
10,476 Points

Thank you so much!

Arshdeep Singh
Arshdeep Singh
6,576 Points
Arshdeep Singh
Arshdeep Singh
6,576 Points

Worked for me.

brianbardellini
brianbardellini
2,151 Points
brianbardellini
brianbardellini
2,151 Points

Worked perfect after hours of troubleshooting and frustration. Please add this note to the video.