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

General Discussion

Posted by Hannah Mills
Hannah Mills
3,599 Points

Trouble opening MySQL server

I'm tring to follow the Database Foundations course and start a SQL server. I've installed the versions included in the teaching notes (and tried to follow a suggestion for server set-up) but I can't seem to open a connection. System Preferences>MySQL>Start server doesn't work - any suggestions? I've deleted/reinstalled a number of times.

Not sure what i'm doing wrong.

3 Answers

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,254 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,254 Points

By any chance are you running Skype at the same time or any other service that might be using the same port as SQL server? Try closing that down and reopening the connection.

Hannah Mills
Hannah Mills
3,599 Points

Thanks for your reply. I don't have Skype running, could it be anything else?

Grigorij Schleifer
Grigorij Schleifer
10,365 Points
Grigorij Schleifer
Grigorij Schleifer
10,365 Points

HI Hannah,

go inside the workbench (little home sign in the left corner > click Server Administration on the right side > click startup/shutdown bar on the left side > click start server button in the middle ....

Hope it helps

Grigorij

Hannah Mills
Hannah Mills
3,599 Points

Hi,

Thanks for the suggestion. Unfortunately that doesn't work either, I just get the spinning rainbow wheel - it's really not happy. I think its maybe a version issue, i've tried to uninstall/reinstall SQL (it feels like at least 400 times) but to no avail. Really frustrating.

Grigorij Schleifer
Grigorij Schleifer
10,365 Points

That is really sad !!!!

Can you look which connection parameters you got?

Go to Database > Manage Connections > In the left part of the screen, you should see the "localhost" inside the screen with Stored connections.

I have Standart TCP/IP, Host "localhost" and port 3306.

Grigorij

Hannah Mills
Hannah Mills
3,599 Points
Hannah Mills
Hannah Mills
3,599 Points

So, spoke to a dev friend and he managed to solve it so up and running now!

For some reason the server wouldn't launch, so he had to do some manual command magic in the terminal to get it working. I'm pleased because it's something I couldn't, with my very basic knowledge, have solved!

Also, the connection parameters were correct, not entirely sure what happened! Thanks so much for your help.

Grigorij Schleifer
Grigorij Schleifer
10,365 Points

Hey Hanna,

command magic is the key to salvation, I guess :)

Great, you could get it right

Grigorij