I don't want MySQL to run as a default auto start service. I want to choose when to start and stop it via a shrotcut. What is the best way to accomplish this?
You can set its startup type to manual in services.msc. This way it will not start automatically unless required. You can create batch files to start and stop the service fairly easily as well. Simply get the name of the service from services.msc as shown here:
Now use this name in batch files.
net start "mysql"
And in your stop.bat:
net stop "mysql"
Simple solution I found to this error. On every Windows machine you can type in msconfig in the run dialog box by pressing windows key + r. The two workbenches should be set as separate processes. In my case one was MySQL the other was MySQL57. I wanted to stop the MySQL and it worked.