MySQL Bugs: #61903: Unable to configure service

Bug #61903	Unable to configure service
Submitted:	18 Jul 2011 23:13	Modified:	16 Jan 2013 16:52
Reporter:	Dennis Hancy	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5.14, 5.5.15	OS:	Other (Windows Vista)
Assigned to:	Matthew Lord	CPU Architecture:	Any

Description:
Trying to rum MySql Installer.

I am on the Configuration step - almost done!

I get the message "Configuration Failed.  Check details for more info".  It has a "try again" link.

The last lines of Detail show this:
mysql-server-5.5-win32-gpl:33 - Attempting to configure service.
mysql-server-5.5-win32-gpl:40 - Configured service.
mysql-server-5.5-win32-gpl:46 - Attempting to start service.
mysql-server-5.5-win32-gpl:100 - Unable to configure service.
mysql-server-5.5-win32-gpl:100 - Product configuration controller finished configuration.

What do I do next?

Thanks...

How to repeat:
On Windows Vista..

I am attempting to download and install MySql.

There are seven steps listed on the left hand side:
Licence Information
Find Latest Products
Setup Type
Check Requirements
Installation
Configuration
Complete

I selected all the defaults for developer set up.  All goes well until the Configuration step, at which point I get the error listed above.

Thank you for the bug report. Be sure actually you don't have the service running then open a command prompt as administrator, go to bin install directory and issue:

mysqld --defaults-file=path_for_my_ini\my.ini --standalone --console

print here eventual error messages.

Thanks in advance.

Can you clarify... are you referring to the command prompt in windows? or the MySQL command prompt?

And exactly what do I type once I am there?

Is there a phone number I can call you on? I think this would be resolved much faster over the phone rather than waiting for email responses.  Thank you.

Dennis

Start standalone server

Attachment: startup-server.png (image/png, text), 266.32 KiB.

Please see picture I attached. The path for my.ini file could be different in your case.

I did this.  Here are the results:
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --default-file="C:\ProgramDa
a\MySQL\MySQL Server 5.5"  --standalone --console
110719 18:45:54 [Note] Plugin 'FEDERATED' is disabled.
110719 18:45:54 InnoDB: The InnoDB memory heap is disabled
110719 18:45:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110719 18:45:54 InnoDB: Compressed tables use zlib 1.2.3
110719 18:45:55 InnoDB: Initializing buffer pool, size = 17.0M
110719 18:45:55 InnoDB: Completed initialization of buffer pool
110719 18:45:55  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:46:05  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:46:15  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:46:25  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:46:35  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:46:40 [Warning] CTRL-C ignored during startup
110719 18:46:45  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:46:55  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:47:05  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
110719 18:47:15  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.

Can't seem to stop it though.

What does this all mean?  Can this be fixed?  Thanks.

I have the same issue on windows 7.
I finished the installation and this was the error message. I would like to use this application if anyone can help.  I am home after 6 pm eastern time.  thanks
 
mysql-server-5.5-winx64-gpl:13 - Found valid template.
mysql-server-5.5-winx64-gpl:20 - Attempting to process template.
mysql-server-5.5-winx64-gpl:26 - Processed template.
mysql-server-5.5-winx64-gpl:33 - Attempting to configure service.
mysql-server-5.5-winx64-gpl:40 - Configured service.
mysql-server-5.5-winx64-gpl:46 - Attempting to start service.
mysql-server-5.5-winx64-gpl:100 - Unable to configure service.
mysql-server-5.5-winx64-gpl:100 - Product configuration controller finished configuration.
examples-5.5:10 - Checking if there are any features installed that need configuration.
examples-5.5:100 - Unable to configure as the server product in our catalog is not running
examples-5.5:100 - Product configuration controller finished configuration.

Also having the same problem.  I am installing on a Win2008 Server.

I did as the others did above and got the following results wen trying to configure MySQL server 5.5.15

Can some1 help please???

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --default-file="C:\programDaa
\Mysql\mysql server 5.5"  --standalone --console
110829 23:18:18 [Note] Plugin 'FEDERATED' is disabled.
110829 23:18:18 InnoDB: The InnoDB memory heap is disabled
110829 23:18:18 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110829 23:18:18 InnoDB: Compressed tables use zlib 1.2.3
110829 23:18:18 InnoDB: Initializing buffer pool, size = 128.0M
110829 23:18:18 InnoDB: Completed initialization of buffer pool
110829 23:18:18 InnoDB: highest supported file format is Barracuda.
110829 23:18:18  InnoDB: Waiting for the background threads to start
110829 23:18:19 InnoDB: 1.1.8 started; log sequence number 1595675
110829 23:18:19 [ERROR] mysqld: unknown variable 'default-file=C:\programDaa\Mys
ql\mysql server 5.5'
110829 23:18:19 [ERROR] Aborting

110829 23:18:19  InnoDB: Starting shutdown...
110829 23:18:20  InnoDB: Shutdown completed; log sequence number 1595675
110829 23:18:20 [Note] mysqld: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.5\bin>

@Blake Albright

110829 23:18:19 [ERROR] mysqld: unknown variable 'default-file=C:\programDaa\Mys

mysqld --default-file=".....

should be:

mysqld --defaults-file="....

The same problem on Windows 7 Home.

Installer:
mysql-server-5.5-win32-gpl:13 - Found valid template.
mysql-server-5.5-win32-gpl:20 - Attempting to process template.
mysql-server-5.5-win32-gpl:26 - Processed template.
mysql-server-5.5-win32-gpl:33 - Attempting to configure service.
mysql-server-5.5-win32-gpl:40 - Configured service.
mysql-server-5.5-win32-gpl:46 - Attempting to start service.
mysql-server-5.5-win32-gpl:100 - Unable to configure service.
mysql-server-5.5-win32-gpl:100 - Product configuration controller finished configuration.

C:\>MySQL Server 5.5\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.5\my.ini"  --standalone --console
110905 15:56:54 [Note] Plugin 'FEDERATED' is disabled.
110905 15:56:54 InnoDB: The InnoDB memory heap is disabled
110905 15:56:54 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110905 15:56:54 InnoDB: Compressed tables use zlib 1.2.3
110905 15:56:54 InnoDB: Initializing buffer pool, size = 40.0M
110905 15:56:54 InnoDB: Completed initialization of buffer pool
InnoDB: Error: auto-extending data file .\ibdata1 is of a different size
InnoDB: 576 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
110905 15:56:54 InnoDB: Could not open or create data files.
110905 15:56:54 InnoDB: If you tried to add new data files, and it failed here,
110905 15:56:54 InnoDB: you should now edit innodb_data_file_path in my.cnf back
110905 15:56:54 InnoDB: to what it was, and remove the new ibdata files InnoDB created
110905 15:56:54 InnoDB: in this failed attempt. InnoDB only wrote those files full of
110905 15:56:54 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
110905 15:56:54 InnoDB: remove old data files which contain your precious data!
110905 15:56:54 [ERROR] Plugin 'InnoDB' init function returned error.
110905 15:56:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110905 15:56:54 [ERROR] Unknown/unsupported storage engine: INNODB
110905 15:56:54 [ERROR] Aborting

110905 15:56:54 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.EXE: Shutdown complete

By the way, the only problem with mysql-installer-5.5.15.0.msi, other installers like mysql-5.5.15-win32.msi runs correctly.

I am experiencing the same situation here:

mysql-server-5.5-win32-gpl:46 - Attempting to start service.
mysql-server-5.5-win32-gpl:100 - Unable to configure service.

Last Error: Unable to configure service.

I have already confirmed what Alexander said:
[6 Sep 11:07] Alexander Soklakov

By the way, the only problem with mysql-installer-5.5.15.0.msi, other installers like
mysql-5.5.15-win32.msi runs correctly.

Please, check if this still happens with any binaries of recent version, 5.5.19.

I got the same error on windows 7

Same problem with release version 5.5.19:

fresh install of windows XP professional 32bit, all updates installed etc.

when running the windows installer, I get:

mysql-server-5.5-win32:100 - Unable to configure service.
mysql-server-5.5-win32:100 - Product configuration controller finished configuration

Also seen this on 5.5.20 - Fresh Windows 2008 server, installing MySQL and then get this error message at the end of it. This is using the all singing and dancing Windows installer. Not Good.

A bit more from my Windows 2008 64 bit server:

mysql-server-5.5-winx64:6 - Looking for valid template
mysql-server-5.5-winx64:13 - Found valid template.
mysql-server-5.5-winx64:20 - Attempting to process template.
mysql-server-5.5-winx64:26 - Processed template.
mysql-server-5.5-winx64:33 - Attempting to configure service.
mysql-server-5.5-winx64:40 - Configured service.
mysql-server-5.5-winx64:46 - Attempting to start service.
mysql-server-5.5-winx64:100 - Unable to configure service.
mysql-server-5.5-winx64:100 - Product configuration controller finished configuration.

Yeah.  Pretty much been getting the same thing on my Windows Server 2003 R2 for the past two or three weeks with both 5.5.19 and 5.5.20.  Can't find a solution anywhere on the Internet.

I installed an older version 5.5 on an identicle box on the same virtual machine without error.  Gotta find that version again to give it a try.

Please post a solution - to anyone who comes up with something.  Stinks that no-one has helped on this one.  Seems to be a big issue.

Failure Screen

Attachment: Screen1.jpg (image/jpeg, text), 259.00 KiB.

It does work - the error at the end can be ignored but a change needs to be made to the .ini file as it doesn't generate the 'my.ini' and the password is never set so it's blank. I'm going to do a blog article about it all shortly but I want to test on 32bit and 64bit first.

this is not a non-critcal bug. It's a broken install so I call it critical. I've raised a seperate report here -> http://bugs.mysql.com/?id=64177 <- which has a workaround.

That's awesome Gary.

I suspected that there was #1 an issue with the my.ini file.  Think that an indicator had popped up somewhere along the way.  And #2 that this isn't a serious issue and could just be passed over.

Although, an error on install and config usually means that the database isn't going to function properly.

Thank for posting a fix.

That's awesome Gary.

I suspected that there was #1 an issue with the my.ini file.  Think that an indicator had popped up somewhere along the way.  And #2 that this isn't a serious issue and could just be passed over.

Although, an error on install and config usually means that the database isn't going to function properly.

Thank for posting a fix.

Spent 5 hours trying to configure the server - tried previous releases, still got the same error. For win32 installer the Data Path should be changed to "C:\Program Files\MySQL" under Setup Type tab, not Installer tab like suggested in http://bugs.mysql.com/bug.php?id=64177
Finally there are no errors and I can start actual work.

Than you for the fix

Please check with new version 5.5.23. Thanks.

I have the same problem trying to install 5.5.23.0 on Windows 7 64-bit.
I was using a user account with administrator privileges.

I tried the diagnostic step that was recommended, and have pasted the output below. I couldn't find the my.ini file, so used the small.ini one. Looks like a permission issue, but since i was using an administrator account with all default options, I believe this is an installer bug.

C:\Program Files\MySQL\MySQL Server 5.5>"c:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.exe" --defaults-file=".\my-s
mall.ini" --standalone --console
120509 15:53:28 [Warning] Can't create test file c:\Program Files\MySQL\MySQL Server 5.5\data\Badumnatest05.lower-test
120509 15:53:28 [Warning] Can't create test file c:\Program Files\MySQL\MySQL Server 5.5\data\Badumnatest05.lower-test
120509 15:53:28 [Note] Plugin 'FEDERATED' is disabled.
120509 15:53:28 InnoDB: The InnoDB memory heap is disabled
120509 15:53:28 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120509 15:53:28 InnoDB: Compressed tables use zlib 1.2.3
120509 15:53:28 InnoDB: Initializing buffer pool, size = 128.0M
120509 15:53:28 InnoDB: Completed initialization of buffer pool
120509 15:53:28 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

Changing the Data Path from the C:\Program Files\MySql\... fixed this for me. Not sure why it defaulted to that in the first place. After a full un-install / re-install at different location / uninstall again, the installer suggested c:\ProgramData\MySQL\... instead.

Changing the Data Path to the C:\Program Files\MySQL is OK (version 5.5.24). Great ! Thanks !

The fix (changing the target directory for data) worked excellent!! Many many thanks!

Changing the path does not do fix the issue. 

Windows Server R2 2008

mysql-server-5.5-winx64:6 - Looking for valid template
mysql-server-5.5-winx64:13 - Found valid template.
mysql-server-5.5-winx64:20 - Attempting to process template.
mysql-server-5.5-winx64:26 - Processed template.
mysql-server-5.5-winx64:33 - Attempting to configure service.
mysql-server-5.5-winx64:40 - Configured service.
mysql-server-5.5-winx64:46 - Attempting to start service.
mysql-server-5.5-winx64:100 - Unable to configure service.
mysql-server-5.5-winx64:100 - Product configuration controller finished configuration.

I am not able to start the MySql  server for the first time.

Below are the locations for base directory and data directory,.

basedir=c:/Program Files/MySQL/MySQL Server 5.5
datadir=e:/data

When running "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld --console" command, it waits for one or two seconds and nothing happens.
It seems it is not able to start the server because further when i am trying to execute mysql client it throws error "can't connect to the MYSQL server on 'localhost'<10061>"

PLease reply wat to do with it.

I had this issue too on a fresh Windows Server 2008 R2

"Can't create test file C:\wwwin\mysql\MySQL Server 5.5\data\WebAgrafresh.lower-test"

MySQL worked fine after I went and manually edited the my.ini, changing the backslashes in the two parameters:

basedir="C:\www\bin\mysql\MySQL Server 5.5\"
datadir="C:\www\bin\mysql\MySQL Server 5.5\data\"

to 

basedir="C:/www/bin/mysql/MySQL Server 5.5/"
datadir="C:/www/bin/mysql/MySQL Server 5.5/data/"

After that, the service could be started and stopped without a problem.

I still had to manually configure the mysql root user and other users that I defined in the install because obviously that failed after the installer could not start the service.

I'm having the exact same issue. I chose default configuration for "Server". I'm using Windows 7. Really disappointing. I'll install another DB.

Please check version 5.5.27. Thanks.

Same problem here under Windows 7 Home. I could solve it by installing the Server first (without the whole rest). It will end with an error message. Just ignore the error message and click on next. Then go to the Windows Services and search for the service "MYSQL55" and change the the logon account to the local system account and start the Server then. That will work. After that, you can install the whole rest excluding the programming examples (because it won't work since MySQL is asking for root rights under Windows; I can live without those examples, too). It isn't the first time that Oracle has problems with Windows. So their Oracle 11g Database still works with the 8.3 directory name convention under Windows today(!!!). At least Oracle 11g couldn't find it's Java installation since it was below "Program Files". But it worked with "Progra~2" (path settings) then. Sometimes I just believe that Oracle doesn't want to work together with Microsoft. I mean, other software vendors don't have such problems. And the 8.3 directory name convention doesn't exist since Windows 2000 anymore. Dear Oracle, welcome to the future! Even Linux supports longer directory names now. ;-)

One side effect of the uninstaller can cause this issue. Consider the following scenario: 
1) Install mysql instance, configure databases, remove root user (for security purposes)
2) Uninstall mysql server (in my case - I needed to replace x64 version with win32)

3) Note that my.ini in documents and settings is never removed from the system

4) Later I try to run the installer to install another mysql server (win32)

5) End up at this particular issue, because uninstaller never removed my.ini

I have the same problem for the first installation, but the second time it's ok. The differences are: 
1.the first time I chose Full(Install all the features) and the seconde time I eliminated MySQL for Excel MySQL Notifier and some connector i don't need.
2.the first time I chose DB Admin and the second time I chose DB Manager
3.I changed the name of the service to "mysql"(characters in lower case)
(there is a configuration page ask the name of the service)

I had the sames issues under Windows 7.
This worked in my case:
Uninstalled, reinstalled changing the data location.

Solved for me:
I ve the same probleme: choosing all configuration by default, but all the time I get "Unable to configure service".
Solution: when getting this problem, instead of pressing Try Again, just go to Windows Services, you will find the Mysql Service added there, but with an erroned User on the last colomn (open service as), So click right over the Mysql Service recently added and Propperties and Connexion, keep sure that information intered there are OK, for my case I just make it to Local System Account.
It seems that the mysql installer has a bug on putting the right user connexion info to the windows service that it create

The only thing that worked for me was to manually set the service user to LocalSystem in services.msc for the MySQL55 service. MySQL seems to default to NetworkService which it fails to apply for some reason. After the service has been started as LocalSystem it can be restared under NetworkService.
Hope this helps.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of an obvious bug. In these cases the configuration failed because the necessary files could not be created in the locations specified (usually permission issues).

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.