MySQL Bugs: #28119: MySQL Adiministrator - (Service Control & Startup Variables)

Bug #28119	MySQL Adiministrator - (Service Control & Startup Variables)
Submitted:	26 Apr 2007 12:18	Modified:	26 Jun 2007 19:27
Reporter:	mustafa turgut	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.11	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
I downloaded "WAMP 1.7.0" and "mysql-gui-tools-5.0-r11a-win32.msi", then i installed them.

When i try to open MySQL Administrator (Version 1.2.11) a message (Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled) was appeared and the sections (Service Control and Startup Variables) were disabled.

How to repeat:
??

Suggested fix:
But when i use MySQL Administrator Version 1.1.9., there is not any problem. The Service Control and also Startup Variables sections are enabled.

Thank you for a problem report. Do you have any my.ini file as a result of installation, and where is it located?

yes, i have.
it is located "C:\wamp\mysql\"

Please, send the results of

net start

Are you sure that same my.ini file was used when services was configured?

For the record I am also experiencing the same problem with my upgrade.  I downloaded the upgrade in Feb but have not upgraded until today.

I just uninstalled an unknown standalone version of mysql-administrator and installed mysql-gui-tools-5.0-r9a-win32.msi

I replaced an unknown version of mysql 5 with mysql-noinstall-5.0.27-win32.zip at the same time.

After having this problem I downloaded the 5.0-r11a windows .msi gui tools, same resulting error.  No known problems previously with the standalone version of the administrator which I have possibly used since mysql 4.x as I tend not to upgrade the tools that work.

my.ini is in c:\winnt (windows 2000 pro SP4 etc.), and yes that is where it has been all along in my case.  I have never used the installer for mysql and have always had good luck with the noinstall version.

Here is my net start (none of which has changed in 6 months or better):

These Windows 2000 services are started:

   Alerter
   Apache
   AVG E-mail Scanner
   AVG7 Alert Manager Server
   AVG7 Update Service
   COM+ Event System
   Computer Browser
   Creative Service for CDROM Access
   DHCP Client
   Distributed Link Tracking Client
   DNS Client
   DynDNS Updater Service
   Event Log
   IPSEC Policy Agent
   Logical Disk Manager
   LogMeIn
   LogMeIn Maintenance Service
   MySQL
   Network Connections
   NMIndexingService
   NVIDIA Display Driver Service
   O&O Defrag
   Plug and Play
   Print Spooler
   Protected Storage
   Remote Access Connection Manager
   Remote Procedure Call (RPC)
   Removable Storage
   Routing and Remote Access
   RunAs Service
   Security Accounts Manager
   Server
   Sunbelt Kerio Personal Firewall 4
   System Event Notification
   Task Scheduler
   TCP/IP NetBIOS Helper Service
   Telephony
   Windows Installer
   Windows Management Instrumentation
   Windows Management Instrumentation Driver Extensions
   WMDM PMSP Service
   Workstation

The command completed successfully.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\18>net start
These Windows services are started:

   Acronis Scheduler2 Service
   Application Layer Gateway Service
   Ati HotKey Poller
   Automatic Updates
   COM+ Event System
   Computer Browser
   Cryptographic Services
   DCOM Server Process Launcher
   DHCP Client
   Distributed Link Tracking Client
   DNS Client
   Error Reporting Service
   Event Log
   Fast User Switching Compatibility
   GEARSecurity
   Help and Support
   IPSEC Services
   Logical Disk Manager
   McAfee Framework Service
   Network Associates McShield
   Network Associates Task Manager
   Network Connections
   Network Location Awareness (NLA)
   Norton Ghost
   PGPserv
   Plug and Play
   Print Spooler
   Protected Storage
   Remote Access Connection Manager
   Remote Procedure Call (RPC)
   Remote Registry
   Secondary Logon
   Security Accounts Manager
   Security Center
   Server
   Shell Hardware Detection
   SSDP Discovery Service
   System Event Notification
   System Restore Service
   Task Scheduler
   TCP/IP NetBIOS Helper
   Telephony
   Terminal Services
   Themes
   wampapache
   wampmysqld
   WebClient
   Windows Audio
   Windows Firewall/Internet Connection Sharing (ICS)
   Windows Management Instrumentation
   Windows Time
   Wireless Zero Configuration
   Workstation

The command completed successfully.

C:\Documents and Settings\18>

:)))

Hi, 
I had the same error on both Windows XP SP2 and Vista.
Mysql Administrator V1.2.5rc, Mysql Server 5.0.

I worked around it on XP by disabling the following option in the configuration file : (it works, I have no idea why, although it doesn't help me creating InnoDB tables) 
the [mysqld] section :

# The default storage engine that will be used when create new tables when
#default-storage-engine=INNODB
# If we activate this option above,then the service can't be restarted

Under Vista, I solved it thanks to the bug report #23746 and this workaround above.

Hope this help !

Thank you for the feedback.

But I want to check if I catched the problem.

Please confirm or refuse:

1. You have no problem on Windows 2000 machine.
2. Error only occurs on Win XP machine.
3. When MySQL Administrator of old version worked perfectly unknown MySQL server was installed (not from WAMP package)

The following fixed this problem for me on Windows XP given that the Service is running and picking up the correct options from the config file.

1)  Invoke MySQL Administrator on the localhost and before choosing OK to connect press and hold the <Ctrl> key. The Cancel button caption changes to Skip.

2) Now choose the Skip option and be presented with a cut down list of options in the left pane of the Administrator on start up.

3) Choose the Service Control option in the left pane and choose the Configure Service tab in the right pane.

4) Untick the option box for Named Pipes and click Apply.

5) Exit and then logon as normal.

Obviously this only works if the named pipe option box is already checked with a tick!

1 - Operating system is Windows XP SP2.

2 - "WAMP 1.7.0" was installed.

3 - "mysql-gui-tools-5.0-r11a-win32.msi" was installed. (This package also includes MySQL Version 1.2.11)

4 - When i try to open MySQL Administrator (Version 1.2.11) a message (Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled) was appeared and the sections (Service Control and Startup Variables) were disabled.

5 - I uninstalled "mysql-gui-tools-5.0-r11a-win32.msi" package. Then i installed  the older version of MySQL Administrator (Version 1.1.9) separately.

6 - There is no problem with the MySQL Administrator (Version 1.1.9).

Thank you for the feedback.

MySQL installed by WAMP is running as "wampmysqld" service.

MySQL Administarator has limitation to configure only MySQL service. This limitation is documented at http://dev.mysql.com/doc/administrator/en/mysql-administrator-service-control-start-stop-s...

So I'll clarify the report as "Not a Bug"

Workaround: drop wampmysqld and create new identical MySQL service.

Simply, you must run the Administrator tool, and before push login botton, press and hold ctrl key in order to view a new button labeled <Skip>, then we can choose all parameters and evenstop, and desinstall, install the service.