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 Running a Script and Using MySQL Workbench

Tati Belikova
Tati Belikova
14,117 Points
Posted by Tati Belikova
Tati Belikova
14,117 Points

MySQL server wont start. help!

As I am starting server from MySQL workbench i get this : How do I fix this?

2015-09-26 14:07:40 - Starting server... 2015-09-26 14:07:40 - Executing '/usr/local/mysql/support-files/mysql.server start' 2015-09-26 14:07:40 - Start server: Starting MySQL

2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: . 2015-09-26 14:07:40 - Start server: ........................................ 2015-09-26 14:07:40 - Start server: .................................................. ERROR! The server quit without updating PID file (/usr/local/mysql/data/tatianaeliksmbp.pid).

2015-09-26 14:07:40 - Server start done. 2015-09-26 14:07:40 - Checking server status... 2015-09-26 14:07:40 - Trying to connect to MySQL... 2015-09-26 14:07:40 - Can't connect to MySQL server on '127.0.0.1' (61) (2003) 2015-09-26 14:07:40 - Assuming server is not running 2015-09-26 14:07:40 - Checking server status... 2015-09-26 14:07:40 - Trying to connect to MySQL... 2015-09-26 14:07:40 - Can't connect to MySQL server on '127.0.0.1' (61) (2003) 2015-09-26 14:07:40 - Assuming server is not running

Gunhoo Yoon
Gunhoo Yoon
5,027 Points
Gunhoo Yoon
Gunhoo Yoon
5,027 Points

Do you have MySQL server installed? If yes try this answer from Stackoverflow

Tati Belikova
Tati Belikova
14,117 Points
Tati Belikova
Tati Belikova
14,117 Points

Yes i have MySQL server installed

Gunhoo Yoon
Gunhoo Yoon
5,027 Points
Gunhoo Yoon
Gunhoo Yoon
5,027 Points

Then you might need to search for a bit since it can vary a lot. Here are few starting points.

(http://ubuntuforums.org/showthread.php?t=2242435)

(http://serverfault.com/questions/544187/cant-connect-to-mysql-using-localhost-but-using-127-0-0-1-its-ok)

(http://dev.mysql.com/doc/refman/5.6/en/can-not-connect-to-server.html)

Sorry but I can only help this way as I haven't touched MySQL workbench. I've only used MySQL server directly.

Gunhoo Yoon
Gunhoo Yoon
5,027 Points
Gunhoo Yoon
Gunhoo Yoon
5,027 Points

Have you tried directly accessing through MySQL server without using Workbench?

Tati Belikova
Tati Belikova
14,117 Points
Tati Belikova
Tati Belikova
14,117 Points

MySql server seems to work when i restart computer and mark start automatically, but as soon as i try to make connection through MySQL workbench connection drops and im not able to reconnect without workbench as well.

Gunhoo Yoon
Gunhoo Yoon
5,027 Points
Gunhoo Yoon
Gunhoo Yoon
5,027 Points

If you are using OS X ignore all of the link I posted and try following steps provided by MySQL official document. Link Switch to your MySQL version if needed.

Tati Belikova
Tati Belikova
14,117 Points
Tati Belikova
Tati Belikova
14,117 Points

Gunhoo, this sounds like a solution. its crazy that MySQL havent adopted yet to Yosemite. I assume, its better if I ll get rid of MySQL before going through installation process again?? http://www.youtube.com/watch?v=uVqulpxUWzw

Gunhoo Yoon
Gunhoo Yoon
5,027 Points
Gunhoo Yoon
Gunhoo Yoon
5,027 Points

Yeah I think you should remove it and re-install with the OS X quirks in mind. I'm not familiar with any OS X so I cannot assure solid answer until I try this in virtual machine or something.

1 Answer

Tati Belikova
Tati Belikova
14,117 Points
Tati Belikova
Tati Belikova
14,117 Points

Alright, so after few hours of unistalling and installing MySql server and trying all possible fixes I have decided to give up. And in absolute despair I thought to give XAMPP a try. and it worked right away by one click on MySQL connect button, my server instance on workbench started working in seconds with no errors. And after all those struggles and a super easy set up with XAMPP I dont think installing MySQL server separatly can be a good practice for Mac Yosemite Users, not only it gives errors but the uninstall process is not very easy. Sad that Treehouse team didnt mention this changes in teachers notes. Big Thanks to Gunhoo Yoon for giving me so much help!