MySQL Bugs: #61884: having problems configuring MySQL Community Edition 5.5.14 on Windows 7 32 bit

Bug #61884	having problems configuring MySQL Community Edition 5.5.14 on Windows 7 32 bit
Submitted:	16 Jul 2011 8:09	Modified:	31 Mar 2014 10:52
Reporter:	Prateek Garodia	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Config Wizard	Severity:	S1 (Critical)
Version:	5.5.14	OS:	Windows (7 Home Premium 32 bit)
Assigned to:		CPU Architecture:	Any
Tags:	directory permission, installation, windows 7

Description:
Hi,

I installed MySQL Community Edition version 5.5.14 on my Windows 7 Home Premium machine which is 32 bit. It installed correctly but failed in configuration. It gave a "Not Responding" error so I had to shut it down. Based on the documentation, I tried running the following command in command line from the bin directory of MySQL.

>> mysql --console

I got back the following

110713 19:44:40 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.5\data\Toshiba-PC.lower-test
110713 19:44:40 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.5\data\Toshiba-PC.lower-test
110713 19:44:41 [Note] Plugin 'FEDERATED' is disabled.
110713 19:44:41 InnoDB: The InnoDB memory heap is disabled
110713 19:44:41 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110713 19:44:41 InnoDB: Compressed tables use zlib 1.2.3
110713 19:44:41 InnoDB: Initializing buffer pool, size = 128.0M
110713 19:44:41 InnoDB: Completed initialization of buffer pool
110713 19:44:41 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.

I get the same error when I try

>> mysqld --console --skip-grant-tables

Please help. What can I do to fix this?

Thanks a lot,
Prateek

How to repeat:
Here are the steps to reproduce the error.
1. Install MySQL Community Edition 5.5.14 on Windows 7 Home Premium 32 bit edition.
2. After installation, the application will try to configure the installation.
3. Enter the initial values and click to go to next screen.
4. This is where the application will hang.
5. You kill the app and go to command prompt. Enter the command as listed above from the bin directory.

Thank you for the bug report. Assuming the service wasn't created and not server instance is running. Open a command prompt as administrator and go to the bin install directory:

mysqld --defaults-file=path_for_my_ini --standalone --console

please paste here the error/warnings messages.

Thanks in advance.

As requested, here is the output after running the command. I have shown the command and the output below. 

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld --defaults-file="c:\Program F
iles\MySQL\MySQL Server 5.5\my-small.ini" --standalone --console
110716 20:08:55 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.5\data\Toshiba-PC.lower-test
110716 20:08:55 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.5\data\Toshiba-PC.lower-test
110716 20:08:55 [Note] Plugin 'FEDERATED' is disabled.
110716 20:08:56 InnoDB: The InnoDB memory heap is disabled
110716 20:08:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110716 20:08:56 InnoDB: Compressed tables use zlib 1.2.3
110716 20:08:56 InnoDB: Initializing buffer pool, size = 128.0M
110716 20:08:56 InnoDB: Completed initialization of buffer pool
110716 20:08:56  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.

Please, send the entire my.ini file generated by Config. Wizard.

Zip file of all my ini files in my install directory.

Attachment: my_ini_files.zip (application/x-zip-compressed, text), 20.50 KiB.

Hi Valeriy,

I have attached a zip file of all my ini files in my installed directory. I was not sure which one you wanted so I have zipped up all and sent it. 

Thanks,
Prateek

Folks,

I got it to work for me. I reinstalled (this time complete instead of typical) and during configuration, this time, I chose detailed configuration. The other option had failed for me the last time. I am not sure if you still need to find out why the other option did not work or maybe update the documentation to explain to people when to use which option. But, as far as this problem is concerned, I got it to work. Thanks a lot for all your help. 

Prateek

I am trying to install it on the Windows vista and getting the same issue. What should I do? 

Thanks,
GiJo

Please try latest release 5.5.19. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

This problem...
 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.5\data\Toshiba-PC.lower-test 

occurs when MySQL is installed, as instructed, i.e. logging in as Admin.
MySQL installs under C:\Program Files and it also puts a directory named " data " there as well.
Then, when we log in a as a User (instead of Admin), of course, we see this error.

I copied the data directory from the Program Files area to a user's area.

Then edited my.ini and added datadir=C:\Users\<my user name>\< pick a directory name>.

This led to more problems.

Can you point to the Installation Instructions for Windows where I went wrong?

J.P. Morgan

I think the root cause of this problem is that I downloaded the ZIP file ( and
that installation procedure does not called the Configuration Wizard to create initialization files & provide users a choice to locate their database ( data directory ) in a User's Home directory (as opposed to Admin's C:\Program Files, etc. )

.....
See 2.3.2. Choosing An Installation Package
http://dev.mysql.com/doc/refman/5.5/en/windows-choosing-package.html
 The Complete Package: This package has a file name similar to mysql-5.5.36-win32.msi and contains all files needed for a complete Windows installation, including the Configuration Wizard. This package includes optional components such as the embedded server and benchmark suite.

The Noinstall Archive: This package has a file name similar to mysql-5.5.36-win32.zip and contains all the files found in the Complete install package, with the exception of the Configuration Wizard. This package does not include an automated installer, and must be manually installed and configured. 
....

I'm uninstalling Zip installations and
ReInstalling using the *.msi file download.

Thank You / Never Mind

Thank you for the bug report. We are closing this report now since the original config wizard is no longer the focus of Windows deployment efforts. For recent MySQL Server versions, the config wizard is also no longer available, and the MySQL Installer for Windows is the recommended way to install MySQL Server on Windows.