Bug #24434 my.cnf option: /mysqld: unknown variable 'character_set_database=utf8'

• Submitted: 19 Nov 2006 22:31
• Modified: 20 Nov 2006 23:52
• Reporter: Roland Bouman
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.13, 5.1.14 bk
• OS: Linux (ubuntu etchy)
• CPU Architecture: Any
• Tags: character set, character_set_database, my.cnf

[19 Nov 2006 22:31] Roland Bouman

Description:
The character_set_database, collation_database, character_set_connection, collation_database options cannot be set from the my.cnf option file.

How to repeat:
please use the attached my.cnf option file, and visit the mentioned options. Uncomment them one by one to elicit these errors:

061119 23:25:41  mysqld started
061119 23:25:41 [ERROR] /opt/mysql/mysql-5.1.12/libexec/mysqld: unknown variable 'character_set_database=utf8'

it also does not work for collation_database 

061119 23:27:26  mysqld started
061119 23:27:26 [ERROR] /opt/mysql/mysql-5.1.12/libexec/mysqld: unknown variable 'collation_database=utf8_general_ci'

it also does not work for character_set_connection 

061119 23:10:56  mysqld started
061119 23:10:56 [ERROR] /opt/mysql/mysql-5.1.12/libexec/mysqld: unknown variable 'character_set_connection=utf8'

it also does not work for collation_connection 

061119 23:28:57  mysqld started
061119 23:28:57 [ERROR] /opt/mysql/mysql-5.1.12/libexec/mysqld: unknown variable 'collation_connection=utf8_general_ci'

Suggested fix:
Please allow setting the setting from the option file, just like it does for character_set_server

[19 Nov 2006 22:32] Roland Bouman

my.cnf with unrecognized options

Attachment: my.cnf (application/octet-stream, text), 17.72 KiB.

[20 Nov 2006 23:52] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please check of list of variables applicable to MySQL server at http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html

[21 Nov 2006 3:24] Roland Bouman

Sveta, thanks for the update.

Of course, as always, I did look in the documentatin before submitting a bug. Can you please tell where I can find the piece of manual you are referring to? 

Thank you in advance

Roland

[21 Nov 2006 7:22] Sveta Smirnova

Roland, see previous comment, please.

[21 Nov 2006 11:52] Roland Bouman

Thank you Sveta,

my apologies for not noticing the link earlier on.

I now understand that collation_database and character_set_database are read only server variables - not defaults that can be set. Setting the default database and collation should be done using the CREATE DATABASE ddl statement.

Thanks for pointing it out, and sorry for posting a non-bug.