Bug #52047 The syntax '--default-character-set' is deprecated

• Submitted: 14 Mar 2010 12:25
• Modified: 7 Dec 2016 20:04
• Reporter: Jon Webb
• Status: Unsupported
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 5.1.44
• OS: Windows (Server 2008 sp2)
• CPU Architecture: Any
• Tags: character set, event 100

[14 Mar 2010 12:25] Jon Webb

Description:
After a fresh install of MySQL v5.1.44 onto Windows Server 2008 (sp2)
In the Application Log is the entry:
Source: MySQL
Event ID: 100
Level: Warning
"The syntax '--default-character-set' is deprecated and will be removed in a future release. Please use --character-set-server instead."

The obvious fix causes other errors !!

How to repeat:
install 5.1.44

Suggested fix:
I went to the config file "my.ini"
commented out: default-character-set=utf8
and added: character-set-server=utf8
rebooted

This fixed the warning - its gone.

BUT
now i can not connect via commandline:
c:\>mysql -uroot -p
enter password ****
Unknown Variable: character-set-server
c:\>

[14 Mar 2010 14:49] Valeriy Kravchuk

Thank you for the problem report. Please, send the results of:

mysql --version

[15 Mar 2010 8:18] Jon Webb

mysql --version

mysql  ver 14.14 Distrib 5.1.44, for Win32 (ia32)

[15 Mar 2010 13:56] MySQL Verification Team

Thank you for the feedback. Please apply the character-set-server=utf8 only in [mysqld] section and not in the [mysql] section of my.ini file and try again. Thanks in advance.

[15 Mar 2010 14:47] Jon Webb

This has indeed resolved the error message reported by windows.
Thankyou.

Just for your ntoes:
i installed/setup mysql using the Instance Wizard (custom & multilingual) - so it may be worth changing the default my.ini that it creates.
Also, i added to [mysqld]
 collation-server=utf8_general_ci
with no ill effects.

Thanks again, Jon

[15 Mar 2010 17:13] MySQL Verification Team

Thank you for the feedback. Changing category to server installing for deprecated my.ini file option.

[15 Mar 2011 15:15] Christopher Hill

Hi,

It would be nice if this could be fixed soon!

Doesn't seem as if it is a big issue but it does cause errors in the event log every time you start up MySQL under Windows if you've done a default install...

[15 Mar 2011 16:03] Jon Webb

i've just installed v5.5.9
and i see under [mysql]...
default-character-set=utf8
and under [mysqld]...
character-set-server=utf9"

Everything is working. Everything is utf8.

So to C.Hill and others, either apply the fix discussed,
or consider upgrading.
Good Luck.

[16 Mar 2011 10:56] Christopher Hill

Hi,

Wasn't aware that it was fixed in 5.5. Would still be good if it could be fixed in 5.1 by default, without having to apply the workaround.

Thanks!
Chris

[17 Mar 2011 8:41] Jon Webb

[edit]
and under [mysqld]...
character-set-server=utf8

[sorry about the typo]

[3 May 2011 15:29] Daniel Fischer

Backported the fix for bug#52380 ... don't ask.

[14 Mar 2014 9:26] Hartmut Holzgraefe

With 5.1 EOL this should now be in status "Won't fix"?

[7 Dec 2016 20:04] Yngve Svendsen

Posted by developer:
 
This relates to EOL (no longer supported) versions of MySQL Server. Thus closing.