Bug #22307 MySQL Server Instance Configuration
Submitted: 13 Sep 2006 12:49 Modified: 25 Apr 2007 18:24
Reporter: Nivaldo filho Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:5.0.24a OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: MySQL Server Instance Configuration

[13 Sep 2006 12:49] Nivaldo filho
Description:
After install, I Can't configure the server by the Wizard... when a clik in 'Execute' Button the following error appear on Write Configuration File:

"Configuration file template c:\Arquivos de programa\mysql\mysql server 5.0\my-template.ini could not be processed and written to c:\Arquivos de programas\mysql\mysql server 5.0\my.ini Error code -1."

How to repeat:
always
[13 Sep 2006 13:07] Nivaldo filho
Error View

Attachment: error.JPG (image/jpeg, text), 95.40 KiB.

[20 Sep 2006 16:37] Valeriy Kravchuk
Do you install server as a user who is a member of (local) Administrators group?
[20 Sep 2006 17:30] Nivaldo filho
Yes, I did Install with User who is a Member of (Local) Administrator Group!!! I only have One User in My computer and it's in an Administrator Group. I alredy did uninstall and reinstall the Server but the error is the same.
[23 Sep 2006 11:38] Valeriy Kravchuk
Sorry, but I was not able to repeat the behaviour described on my XP. Please, send the results of:

dir "c:\Arquivos de programa\mysql\mysql server 5.0\"

command. Did you have any previous version of MySQL 5.0.x there?
[26 Sep 2006 15:14] Guy Jascht
The same problem on newly setup Windows 2003 R2 64bit. I think it isn't the OS but a missing dll, package, etc. Could it be the multilanguge installation (english/german)?

Any ideas ???
[29 Sep 2006 2:40] Dennis Haney
Same problem here. First time ever installing mysql on windows (really like the config wizard).
Settings used:
set root passwd
not set anonymous account
install as windows service -> mysql -> does not exist
include in path
UTF8
enable TCP/IP
enable strict
OLAP
NON-trans db
Server machine
Detailed

Also tried
install as windows service -> already existing account

No luck
[29 Sep 2006 2:43] Dennis Haney
It generates an incomplete temp ini file it seems, attaching to bug
[29 Sep 2006 2:45] Dennis Haney
Ohh well, can't for some reason:
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8

# The default storage engine that will be used when create new tables when
default-storage-engine=MYISAM

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=100
(and then nothing else)
[29 Sep 2006 2:47] Dennis Haney
Next config statement in the template is
_available_memory=<<<{:=[_memory]-[max_connections]*256K}>>>
Could it be because the machine has 6gig memory and you are only using a 32bit value to keep these numbers in? :)
[29 Sep 2006 2:51] Dennis Haney
I changed from "Server machine" to "Developer machine" and installation was successful
[2 Oct 2006 11:47] Nivaldo filho
I found the error!! I don't know why, but after installation, the directory of MySQL did not have permission for write... now i have other error... in "Start Service" 

error: "Cannot Create Windows Service for MySql.error:0"
[3 Oct 2006 8:44] Valeriy Kravchuk
So, you had a permission problem. Do you have any antivirus/firewall software installed? Please, check that user you are working as really has all the permissions required and (!) exclude mysqld from any additional checks at OS/firewall/antivirus software levels.
[4 Oct 2006 12:22] Valeriy Kravchuk
Bug #22886 was marked as a duplicate of this one. Please, send the results of:

mysqld-nt.exe --install
[4 Nov 2006 0:00] Bugs System
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".
[21 Apr 2007 14:52] Dylan Tynan
Hi, please reopen this bug.  I have duplicated the exact scenario described above.  I believe this is specific to Windows 2003 Server 64-bit, as that is what I am using as well (standard edition).

I got mysql installed fine & the service was running.  I then chose to configure the mysql server instance (configuration wizard).  I made the following choices:
server machine
multifunctional database
(chose drive d:\mysql datafiles\ for innodb)
decision support (DSS)/OLAP
Enable TCP/IP Networking (port 3306)
Enable Strict mode
Standard Character Set
Install as Windows Service (service name Mysql, check launch mysql automatically   <---- actually, all of this is already greyed out since that's how it was installed originally I guess)
Check for Include Bin Directory in Windows Path
Check Modify Security Settings (current pw, new pw, confirm pw, and check for enable root access from remote machines)
* I did not choose to create an anonymous account on this screen, fyi
Press Execute Button....

Fails at "Write configuration file" with error:
Configuration file template c:\program files\mysql\mysql server 5.0\my-template.ini could not be processed and written to c:\program files\mysql\mysql server 5.0\my.ini. Error code -1.

It does leave a 0 byte file out there for my.ini in that directory.

In reading the above info from another user, I went and checked the Mysql directory permissions.  The "Read-Only" box is checked, in kind of a grey-checkmark, you can uncheck, you can check it with a black checkmark, if you click it again it goes to a grey checkmark.  Anyway, unchecking it & having it apply to lower-level directories appears to work, but if you bring it back up again it's back to the regular grey-checkmark.  However, I don't really think this is the problem ... I'm running as Administrator and I clearly have Full Control permissions listed.  That grey-checkmark read-only thing is common for other programs as well .... I think that's a wild goose chase.

However, the user above is correct that if you go back and choose "Developer System" instead of "Server Machine", it does allow you to move past this error.  So, it will put a check for "Write configuration file", but it will always fail on "Restart Service".  It does this whether or not the service already started.  Attempting to start the service by hand will fail.  Basically you're stuck at this point.....

I also tried choosing not strict, tried just using named pipe, tried "dedicated mysql server machine", etc. and nothing works.

So to summarize, you can't get the config file written out unless you choose "Devleoper Machine".  But, then, the service will not start back up.  I'm on a dual-processor Intel 5140 (dual-core, so it appears to be 4 cpus total) with 4 Gig of RAM, running Windows 2003 Server x64bit with all the latest service packs & patches.

Note that Microsoft allows you to download this product free for a 6-month trial from their website if you need to get a copy to test it.  Alternatively, I am willing to give you a remote-desktop login to my server if you want to poke around and see what you can figure out.

dtynan@gmail.com

Thanks,
Dylan
[21 Apr 2007 14:53] Dylan Tynan
Oh, also, I ran the command you wanted run on my system, but I don't think it's gonna help ya ... here it is:

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>mysqld-nt.exe --install
The service already exists!
The current server installed: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql
d-nt" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" MySQL

C:\Documents and Settings\Administrator>
[21 Apr 2007 14:55] Dylan Tynan
I also tried a net start .....

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>mysqld-nt.exe --install
The service already exists!
The current server installed: "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql
d-nt" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" MySQL

C:\Documents and Settings\Administrator>net start MySQL
The MySQL service is starting.
The MySQL service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

C:\Documents and Settings\Administrator>
[21 Apr 2007 15:05] Dylan Tynan
Ok, I finally found a combination that works .....
If I choose "Developer Machine" I can write out the config file.
If I choose "Non-transactional database" (no Innodb, only ISAM) then I can get the service to restart.

That is the only combination I can get to work.....
[21 Apr 2007 20:02] Valeriy Kravchuk
What exact version of MySQL server you had used?
[25 Apr 2007 18:24] MySQL Verification Team
Duplicate of bug: http://bugs.mysql.com/bug.php?id=14649
[30 Jan 2009 2:31] Michael Hanna
I had the same issue a few minutes ago.  Perhaps this is a little messy, but I managed to solve the problem by deleting the MySQL folder from my Program Files directory, and then reinstalling.  The MySQL instance itself was left untouched, and the installer worked.
[17 Sep 2009 1:34] sarla sagar
'm getting an error with "The Security settings could not be applied" Error Number 1045.Access denied for user 'root@localhost' (using password :Yes). 

I'm using windows XP SP3. I'm seeing this error while installing and I also reinstalled and followed the steps given in the forum. 

Could any one help me out resolving this issue.
[27 Oct 2010 4:16] Nathan Mills
Thank you Dylan, your combination worked for me as well.  Why the wizard causes this apparently chronic failure for years on end is a mystery.
[27 Oct 2010 4:17] Nathan Mills
BTW I'm running Windows 7 Home Premium.