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

Greg Wollf
Greg Wollf
12,463 Points
Posted by Greg Wollf
Greg Wollf
12,463 Points

Unable to start MySQL server

I successfully installed MySQL but have been unable to start up a server. Every time I try to click 'Start Server' this is what appears in the Startup Message Log

"Could not open error log file: [Errno 2] No such file or directory: 'XERXES.err' 2015-08-10 16:05:04 - Starting server... 2015-08-10 16:05:08 - Server start done. 2015-08-10 16:05:09 - Checking server status... 2015-08-10 16:05:09 - Trying to connect to MySQL... 2015-08-10 16:05:09 - Can't connect to MySQL server on '127.0.0.1' (10061) (2003) 2015-08-10 16:05:09 - Assuming server is not running 2015-08-10 16:05:09 - Checking server status... 2015-08-10 16:05:09 - Trying to connect to MySQL... 2015-08-10 16:05:09 - Can't connect to MySQL server on '127.0.0.1' (10061) (2003) 2015-08-10 16:05:09 - Assuming server is not running"

I decided to attempt a test on the connection but received this error message

"Failed to Connect to MySQL at localhost:3306 with user root Can't connect to MySQL server on '127.0.0.1' (10061)"

I've tried searching online for how to solve these errors but have not been able to find anything yet. Please help.

Stuart Ringold
Stuart Ringold
12,508 Points
Stuart Ringold
Stuart Ringold
12,508 Points

Just to clarify are you running mysql on a UNIX system (Mac or Ubuntu), MAMP, XAMP, VagrantBox, or Windows?

1 Answer

Ted Sumner
Ted Sumner
Courses Plus Student 17,967 Points

I have used XAMPP on a Linux Mint build and Windows 7 and had no problems at all. Another student was having problems with another program, installed XAMPP and was running right away.

Greg Wollf
Greg Wollf
12,463 Points
Greg Wollf
Greg Wollf
12,463 Points

XAMPP solved it for me. Thanks.

Ted Sumner
Ted Sumner
Courses Plus Student 17,967 Points

One thing to be aware of is that you save projects in the htdocs folder in the XAMPP folder if you need the server to process the code like you do with PHP and other back end languages. I had to change the folder permissions to be able to save stuff there in Linux Mint operating system. I did not in windows.