Index: web-module/script/yml/monitoring/server/allinone/my.cnf =================================================================== diff -u -rc0c9260f404de2116f14bdd4edb88c1fc0cd0d16 -r1a601e2e1b91734322e4152e1ce200cab3f774df --- web-module/script/yml/monitoring/server/allinone/my.cnf (.../my.cnf) (revision c0c9260f404de2116f14bdd4edb88c1fc0cd0d16) +++ web-module/script/yml/monitoring/server/allinone/my.cnf (.../my.cnf) (revision 1a601e2e1b91734322e4152e1ce200cab3f774df) @@ -1,3 +1,24 @@ +####### /etc/mysql/mysql.conf.d +#[mysqld] +#pid-file = /var/run/mysqld/mysqld.pid +#socket = /var/run/mysqld/mysqld.sock +#datadir = /var/lib/mysql +#log-error = /var/log/mysql/error.log +# By default we only accept connections from localhost +#bind-address = 127.0.0.1 +# Disabling symbolic-links is recommended to prevent assorted security risks +#symbolic-links=0 + +#[mysqld] +#skip-host-cache +#skip-name-resolve + +#[mysqldump] +#quick +#quote-names +#max_allowed_packet = 16M + + #5.7.32 [client] port = 3306 @@ -12,13 +33,13 @@ [mysqld] # Basic Settings user = mysql -pid-file = /var/run/mysqld/mysqld.pid -socket = /var/run/mysqld/mysqld.sock +#pid-file = /var/run/mysqld/mysqld.pid +#socket = /var/run/mysqld/mysqld.sock port = 3306 ########### add sql-mode = ANSI_QUOTES,STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION basedir = /usr -datadir = /var/lib/mysql +#datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql @@ -31,7 +52,7 @@ character-set-server = utf8 init_connect = SET collation_connection = utf8_general_ci init_connect = SET NAMES utf8 -skip-name-resolve = 1 +#skip-name-resolve = 1 log_timestamps = SYSTEM log_error_verbosity = 1 @@ -158,19 +179,12 @@ long_query_time = 3 [mysqldump] -quick -quote-names -max_allowed_packet = 64M +#quick +#quote-names +#max_allowed_packet = 64M -#[mysqladmin] -#user = root +[mysqladmin] +user = root [isamchk] -key_buffer = 16M - -# -# * IMPORTANT: Additional settings that can override those from this file! -# The files must end with '.cnf', otherwise they'll be ignored. -# -!includedir /etc/mysql/conf.d/ -!includedir /etc/mysql/mysql.conf.d/ +key_buffer = 16M \ No newline at end of file