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

problems with xampp and mysql workbench

Hello. I was using XAMPP and MYSQL Workbench. It was working fine but then I restarted my computer. Now XAMPP won't start MySQL database and I have no idea why. How can I troubleshoot this? The set up and management of sql is a pain the ass.

2 Answers

I found the answer on the internet. sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start

But why do I have to use that code? What is it "fixing"?

If something hasn't worked before but worked after with sudo command that means the file permission needs to be tweaked. What sudo does is it temporarily allowing you to access file as super user.

Hmmm, so how do I change the file permission permanently?

It seems like it's not the best case to change file ownership or permission for your situation. I would just alias /Applications/XAMPP/xamppfiles/bin/mysql.server start and run it with sudo. I don't know how that works in mac so you are better off by googling something like "how to set alias in mac".