Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL configuration: when to use hyphen and when to use underscore

Tags:

In MySQL some configuration options use _ and some use -. Is there any way to easily identify when to use one versus the other?.

like image 896
itsraja Avatar asked Oct 12 '11 07:10

itsraja


2 Answers

No.

It's just one of those things that happen when a team of people design a product.
Different conventions get used leading to inconsistency.

See here: http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html

And scroll to the options starting with ssl, you'll see what I mean.

like image 167
Johan Avatar answered Sep 21 '22 07:09

Johan


According to the suggestion in the mysql bug report discussing the confusing state of the mysql docs:

  1. The my.cnf and command line options you can use either _ or - within the option name.
  2. Server variables are _ only when working with the MySQL client (modifying from SET for example).

In summary, you can use _ and - interchangeably within a config file.

like image 25
Mike Marcacci Avatar answered Sep 25 '22 07:09

Mike Marcacci