Bug #30921 Config wizard creates 2 [mysqld] in my.ini

• Submitted: 9 Sep 2007 23:04
• Modified: 10 Sep 2007 4:35
• Reporter: Jared S (Silver Quality Contributor)
• Status: Closed
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 1.2.12
• OS: Windows (Vista)
• CPU Architecture: Any
• Tags: config wizard, INI, mysqld, qc

[9 Sep 2007 23:04] Jared S

Description:
Hi,

Looks like recent modification to config wizard has resulted in 2 [mysqld] group entries in the .INI file.

How to repeat:
1. Delete c:\program files\mysql server 5.0\my.ini
2. (install\reconfigure) MySQL server 5.0
3. View c:\program files\mysql server 5.0\my.ini

..
[mysql]
default-character-set=latin1
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
..

Suggested fix:
[mysqld]
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
default-character-set=latin1
# The TCP/IP Port the MySQL Server will listen on
port=3306

[10 Sep 2007 4:00] Valeriy Kravchuk

Jared,

Please, look again:

[mysql]
default-character-set=latin1

It is [mysql] section, for clients, not [mysqld], for server! Configuration wizard alway created them both, in this order. Please, double check.

[10 Sep 2007 4:35] Jared S

Appologies :)