Bug #2907 Not possible to start MySQL service with MySQL Administrator
Submitted: 20 Feb 2004 10:25 Modified: 20 Feb 2004 13:14
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.1a ALPHA OS:Windows (Win XP)
Assigned to: Bugs System CPU Architecture:Any

[20 Feb 2004 10:25] [ name withheld ] 
Description:
It is not possible to start the MySQL service with MySQL Administrator.
It tries to connect to the database upon startup, which has to fail, because
the service is not started.

How to repeat:
Stop the MySQL service and try to start it with MySQL Administrator.

Suggested fix:
Put in a check, whether the services is started. If not provide an option to do so.
[20 Feb 2004 13:14] Ulrich Bayer 
There actually is an option to bypass connecting to a running database already. It is not documented though yet and it is not really obvious. :)
Try pressing Ctrl in the connection dialog, the button changes to Skip then.
[1 Mar 2010 14:58] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/101896

2847 Kristofer Pettersson	2010-03-01
      Bug#2907 invalid Open_files or Slave_open_temp_tables value in show global status
      
      If my_register_filename() fails it should return an
      invalid file handle to indicate this failure or
      the open_files status variables will be
      decreased one time too many. As the variable is unsigned
      it will warp around to a very high number when this
      happens.
     @ mysys/my_open.c
        * If an error occurs, return -1 to indicate error.