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
Bob Sutherton
20,160 PointsWeird Error for MySQL Workbench.
I went through the installer, following along with the video. First, it didn't open immediately after the install like Andrew's did in the video. There is an icon (MySQL Notifier) on my task bar but whenever I try to do anything this error pops up:
Error: The service MySQL57 failed the most recent status change request with the message The service mysql57 was not found in the Windows Services If problem persists please restart MySQL Notifier.
I have no idea what that means. I do have XAMPP installed. Could be that causing a conflict?
1 Answer
Viki Pattanaik
6,314 PointsHey Brock, I don't know if you have worked around your problem but here's how I got around to tying together XAMPP and Workbench so they work in harmony. First off, I actually installed XAMPP, the version shown in the PHP Build A Simple Application video set by Randy Hoyt. It was XAMPP V3.0.12 so it had MYSQL 5.5.25 by default. My operating system is Windows 8.1, not sure if that makes much of a difference but thought you should not it. Next I went ahead and installed Workbench 6.1. Here's what i did differently... Instead of using the installer as shown in the tutorial by Andrew I directly downloaded the Workbench msi file from mysql downloads. Installed that. Workbench starts fine, no issues at all. I just ensure to start MySQL and PHP from XAMPP before doing anything on Workbench and I make a new SQL connection with port 3306 and root (remember to not set any password, I haven't yet figured out how to set a password and get this to work). Test the connection and it should give out a success message.
Like I said, this is how I went about getting the two to work together. I presumed that there will be eventual complications since workbench and xampp are different applications so i ensured that the MySQL version matches the workbench version designed for it. Hope this helps buddy.
Bob Sutherton
20,160 PointsBob Sutherton
20,160 PointsWow, actually I had not found a solution to this. I had put this on the backburner as I am doing so much at once. Thanks for responding. I will give this a try. What worries me though is that you say you expect eventual complications?
Thanks for the response! I will come back and let you know once I get it going.
Viki Pattanaik
6,314 PointsViki Pattanaik
6,314 PointsI wrote, "I presumed that there will be eventual complications since workbench and xampp are different applications so i ensured that the MySQL version matches the workbench version designed for it". Basically what I meant was since I too am just starting out in my quest, I only go by what I already know. From what I understand Workbench is supposed to interact with MySQL server and give back processed data so if Workbench is designed to work with a newer instance of MySQL but what I am running on my system is older then somewhere down the road this may (not surely will but may) cause a complication. However, that is why I also said that before I installed workbench I made sure that the version of MySQL I have matches the Workbench's requirements. Hope I made myself clear buddy.
Do keep us posted on whether my solution worked. :)
Bob Sutherton
20,160 PointsBob Sutherton
20,160 PointsI see what you mean. Thanks for clarifying that for me.