Edit file File name : my.cnf Content :#-----------------------------------------------------------------------------------------------# # WARNING: This file is managed by Salt, any changes will be overwritten on the next Salt run # #-----------------------------------------------------------------------------------------------# # Config designed for MySQL 8 # #-----------------------------------------------------------------------------------------------# [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock log-error = /var/log/mysqld.log log_timestamps = SYSTEM pid-file = /var/run/mysqld/mysqld.pid default-authentication-plugin = mysql_native_password sql_mode = NO_ENGINE_SUBSTITUTION character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci max_allowed_packet = 64M max_user_connections = 100 max_delayed_threads = 0 tmpdir = /tmp wait_timeout = 300 read_buffer_size = 256K read_rnd_buffer_size = 512K myisam-recover-options = DEFAULT myisam_sort_buffer_size = 128M innodb_buffer_pool_size = 128M innodb_log_buffer_size = 32M innodb_data_home_dir = /var/lib/mysql/ innodb_file_per_table = 1 innodb_log_group_home_dir = /var/lib/mysql/ innodb_redo_log_capacity = 100M tmp_table_size = 64M max_heap_table_size = 64M table_open_cache = 16384 table_definition_cache = 8192 disable_log_bin # Extra settings which were default on MariaDB 10.3, Ref SYSENG-14843 event_scheduler = OFF sort_buffer_size = 512K key_buffer_size = 134217728 thread_cache_size = 256 max_length_for_sort_data = 1024 max_relay_log_size = 1073741824 query_alloc_block_size = 16384 sync_binlog = 0 thread_stack = 299008 lock_wait_timeout = 86400 innodb_adaptive_hash_index = OFF innodb_autoinc_lock_mode = 1 innodb_change_buffering = none innodb_concurrency_tickets = 0 innodb_lru_scan_depth = 1536 innodb_spin_wait_delay = 4 innodb_thread_sleep_delay = 0 group_concat_max_len = 1048576 [mysql] no-auto-rehash default-character-set = utf8mb4 [mysqldump] quick max_allowed_packet = 32M [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout !include /etc/my.cnf.d/hwconf.conf Save