MySQL Bugs: #11988: Service Stopped when i click on the "Service Control" option

Bug #11988	Service Stopped when i click on the "Service Control" option
Submitted:	17 Jul 2005 8:22	Modified:	10 Jul 2006 14:00
Reporter:	francois brebion	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.21	OS:	Windows (XP)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any
Tags:	Server Configuration

Description:
I get "apparently" disconnected from mysql server when i click on the option "service control" in mysql administrator.

It is only "apparently", because if i keep "Mysql Control Center" open at the same time, i can ping the server , who show as disconnected in "Mysql administrator", and it is active.

How to repeat:
When i open My Sql admin, I am able to connect to Mysql server, which is running.

I can work and select any of the menu offered to me on the left side:
- Server information
- Startup variables
- User adminisrtation
...

However, if i click on Service Control, my SQL service is stopped and the status of my server becomes "disconnected". At this point i won't be able to start the service again... Unless i close Mysql admin and open it again.

Thanks

-Francois

How did you start mysql? I was able to reproduce it if I start mysql as 
mysqld.exe --console --standalone

But wasn't able to reproduce it if I started msql as servise (kind of
net start mysql41)

That's right

I started mysql from a command window with a statement 

c:>\...\mysql\bin\mysqld --console

I'm new to mysql and i don't know how can i start mysql as a service in windows XP. I tried to look in Mysql administrator, but i didn't find a solution. Can you refer me to more info on that?

I verify this bug for using mysql as  non-service.

Francois, when you install mysql, installer must ask you about service name. then for starting you need to 

net start yourservicename

in the windows console, 

or Start->Control Panel->Administration->Services , select the service and click to 'start'

I see something similar though it is not clear to me if it is the same thing.

being connected to a remote server through a ssh tunnel, that locally connected to 127.0.0.1, the GUI
* Information
* Service
* Options

show confusing information.

For example Information show server stopped, yet being connected to the server, see screen shot.

Suggest to grey out tab that are not applicable for a given server.

Well, turns out I cannot attach a file. Will be available on request then.

Hi,

The service information panel works only when the server is running locally as a Windows service. This panel will not work for a remote server or a local server that runs as a normal Windows app.

You might have other problems when connected to a server via SSL - that is already fixed and will be available in the next MA release.