Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I set up a local MySQL server, currently with no databases. I'm trying to create a new server instance profile in MySQL Workbench to manage the server, and during the Create New Server Instance Profile wizard, it gets to the Windows Management section and tells me that No MySQL service found.

I went into Task Manager and found the process mysqld.exe to be running, under the user name of NETWORK SERVICE. Then I went into the Services tab and found that MySQLServerName (I custom named the Windows service) is also there, and status is running.

I ran cports and looked at what ports mysqld.exe is using, and ran a telnet command on that port. It's reporting that the port is being listened in on. I then ran the MySQL Command Line Client to be sure, and after \r it gives me a proper connection ID and a list of databases (NONE at this point).

But with all this, I can't make the wizard find a running service. I've Googled this and found no answers, so please, if someone would help shed some light on this issue that'd be great!

share|improve this question
    
Did this ever resolve?`I have same problem, and very little solutions. –  user25187 Jun 20 '13 at 12:56

1 Answer 1

I custom named the Windows service

This may seem a bit of an obvious question... but have you considered not doing that?

share|improve this answer
    
Yes, someone else suggested this to me and I uninstalled/reinstalled the server using the default name. That didn't work either :( –  jayjyli Nov 20 '12 at 8:30
    
Pity, I felt pretty good about that one. Please provide your version of workbench, version of MySQL, version of Windows and architecture (32/64 bit) and I'll see if I can find a way to replicate this. –  Michael - sqlbot Nov 20 '12 at 19:16
    
Workbench 5.2 CE, Windows 7 x64, MySQL 5.5. I also have an SSD to boot off of and an HDD to store misc. installations on. MySQL is installed on the boot drive, if any of that matters. Thanks for the help, lemme know how it goes! –  jayjyli Nov 22 '12 at 18:12
    
What are the full versions? Workbench 5.2.??, MySQL Server 64-bit version 5.5.??, and Windows 7 (Pro? Home Premium? Ultimate?) And, you did accept all default values on the installs this time around? –  Michael - sqlbot Nov 22 '12 at 21:11
    
MySQL Server 5.5.28, Workbench CE 5.2.44, Windows 7 Pro. Yes, all default options were selected this time, I just clicked through next for whatever screen during the installer, except for the part where it asks me to set a root/user password for the service. –  jayjyli Nov 23 '12 at 7:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.