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

Robert Ott
PLUS
Robert Ott
Courses Plus Student 4,614 Points
Posted by Robert Ott
Robert Ott
Courses Plus Student 4,614 Points

How do I stop MySQL?

Hi. I've installed MySQL Workbench 6.2 for Mac OS X 10.10.2 and MySQL Community Server 5.6.23 (64-bit). Thanks to the tutorial by Kyle Damken I was able to install these versions and get everything up and running.

I have completed most of the Database Foundations lessons but today I tried to stop the MySQL Server from the Startup / Shutdown link in the Workbench and I got this error in the Startup Message Log:

2015-02-04 10:57:19 - Server is running

Could not open error log file: [Errno 13] Permission denied: '/usr/local/mysql/data/Robert-Otts-MacBook-Pro.local.err'

2015-02-04 10:57:22 - Command to stop the server is not configured. Please set the command that must be used to stop the server in the remote management section of this connections settings.

2015-02-04 11:00:48 - Checking server status...

2015-02-04 11:00:48 - MySQL server is currently running

I'm a total newbie. Any help is appreciated.

I can stop the server by going to System Preferences > MySQL > Stop MySQL Server but I'd like to be able to stop it from Workbench.

Thanks in advance to all you smart people!

Robert