MySQL Workbench 5.2 CE, Windows 7, "Can't connect to MySQL Server on 127.0.0.1 (10061)"
I've seen this problem asked a bunch of times on here but every solution posted hasn't been helpful for me.
I just got the x86 install and installed MySQL Workbench 5.2 CE on my Computer.
After that I tried to create a New Server Instance or New Connection using localhost as the hostname, I've tried Port 3306 (and trying no port) and not putting a password for root or Default Schema.
I get the error message "Can't connect to MySQL server on '127.0.0.1' (10061)" both times.
I read a possible problem is that the MySQL Server isn't running so I tried looking for mysqld in my MySQL Workbench 5.2 CE folder but it isn't there (there isn't a bin folder either).
It's frustrating since all I want to do is create a small application that connects to MySQL Workbench for a school project (though I may use MySQL later on).
Any help would be very much appreciated. Thanks.
Answer
I had the same problem and solved it as follows.
- Search for 'Services' in the Windows Search Bar.
- Click on 'Services', which should be the only hit.
- Scroll down to 'MySQL56'.
- Right-click on this item and hit 'Start' or 'Restart'.
That's it! Easy as pie.