Bug #63426 can't start server with -- default-character-set
Submitted: 25 Nov 2011 9:29 Modified: 25 Nov 2011 11:54
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.5.18 OS:Windows (7-64 bit)
Assigned to: CPU Architecture:Any
Tags: qc

[25 Nov 2011 9:29] Peter Laursen 
Description:
my.ini: 
********
..
[mysqld]  
default-character-set=cp1251
.. 

starting server fails:
**********************
C:\Users\Peter>net start mysql55
Tjenesten MySQL55 starter...
Tjenesten MySQL55 kunne ikke startes.

Der opstod en systemfejl.
Systemfejlen 1067 opstod.
Processen sluttede uventet.

C:\Users\Peter>

How to repeat:
See above.  Same works fine in 5.1.60.

And as per docs http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_default-cha... I see nothing wrong.

Suggested fix:
No idea. 

(but maybe somehow related to the fix for http://bugs.mysql.com/bug.php?id=11972)
[25 Nov 2011 9:45] Peter Laursen 
sorry .. link to docs was wrong.  

But http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html tells the same.

However "character-set-server=cp1251" works fine.  So documentation bug? Or regression?
[25 Nov 2011 11:54] Valeriy Kravchuk 
Why do you think default-character-set should work in [mysqld] section of 5.5.18 if our manual, http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-character..., clearly says:

"This option is deprecated in favor of --character-set-server. See Section 9.5, “Character Set Configuration”. --default-character-set was removed in MySQL 5.5.3."