Search code examples
mysqldatabaseconfigurationconfigmy.ini

MySQL configuration file sections


I am trying to understand the different sections inside the my.ini configuration file ([client], [mysqld], [mysql]) and so on, I am looking for a guide describing each of the optional sections for the my.ini file, Also I was wondering what is the difference between init_connect and init-connect and I mean between the underscore(_) and the hyphen(-), Thank you all and have a nice day.


Solution

  • [mysql] applies to the mysql command line client - [mysql and client options]

    [client] applies to all connecting clients (including mysql cli) - [mysql and client options]

    [mysqld] applies to the mysql server - [server options]

    [mysqldump] applies to the utility of the same name - [mysqldump options]

    ...etc

    The difference between the (-) and the (_) is the context in which it is used.

    (-) is used in command line parameters, where (_) is used in options file parameters.

    You can see more in the docs: http://dev.mysql.com/doc/refman/5.5/en/option-files.html