Bug #85496 [ERROR] unknown variable 'character_set_connection=utf8'

• Submitted: 17 Mar 2017 6:50
• Modified: 17 Mar 2017 9:35
• Reporter: kfpanda kf
• Status: Duplicate
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.7.17
• OS: Any
• CPU Architecture: Any

[17 Mar 2017 6:50] kfpanda kf

Description:
Hello,

first,i add "character_set_connection=utf8" into my.cnf(section: mysqld)

then,,i restart mysql, error occurs in error log:
2017-03-17T06:14:46.838884Z 0 [ERROR] unknown variable 'character_set_connection=utf8'
2017-03-17T06:14:46.838910Z 0 [ERROR] Aborting

How to repeat:
Hello,

first,i add "character_set_connection=utf8" into my.cnf(section: mysqld)

then,,i restart mysql, error occurs in error log:
2017-03-17T06:14:46.838884Z 0 [ERROR] unknown variable 'character_set_connection=utf8'
2017-03-17T06:14:46.838910Z 0 [ERROR] Aborting

Suggested fix:
I hope the variable character_set_connection can be maintained in my.cnf.

[17 Mar 2017 7:04] MySQL Verification Team

Hello kfpanda kf,

Thank you for the report.
You can refer the list available to confirm which option/variables are available in conf, command line or  server system variable.

https://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-optvar.html

Above listing confirms that "character_set_connection" is a server system variable and can be set using SET... statement.

Marking this as a not a bug!

Thanks,
Umesh

[17 Mar 2017 9:35] MySQL Verification Team

Marking this as duplicate of Bug #85501, just to aggregate them all (if they're all similar) into a single FR.