[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] pid-file = /var/run/mysqld/mysqld.pid nice = 0 [mysqld] user = mysql basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql explicit_defaults_for_timestamp skip-grant-tables lower_case_table_names = 1 character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION #bind-address = 127.0.0.1 log-error = /var/log/mysql/error.log sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES symbolic-links=0 !includedir /etc/mysql/conf.d/