Edit file

File name : my.cnf

Content :# # This group is read both by the client and the server # use it for options that affect everything # [client-server] # # These two groups are read by the client library # Use it for options that affect all clients, but not the server # [client] # This group is not read by mysql client library, # If you use the same .cnf file for MySQL and MariaDB, # use it for MariaDB-only client options [client-mariadb] # This group is only read by MariaDB servers, not by MySQL. # If you use the same .cnf file for MySQL and MariaDB, # you can put MariaDB-only options here [mariadb] # # * Galera-related settings # [galera] # Mandatory settings #wsrep_on=ON #wsrep_provider= #wsrep_cluster_address= #binlog_format=row #default_storage_engine=InnoDB #innodb_autoinc_lock_mode=2 # # Allow server to accept connections on all interfaces. # #bind-address=0.0.0.0 # # Optional setting #wsrep_slave_threads=1 #innodb_flush_log_at_trx_commit=0 [mysqld] disable_log_bin port=3306 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/lib/mysql/error.log pid-file=/var/lib/mysql/mysqld.pid # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 performance-schema=0 max_allowed_packet=268435456 open_files_limit=2048 innodb_file_per_table=1 character-set-server = utf8mb4 collation-server = utf8mb4_general_ci [mysql] socket=/var/lib/mysql/mysql.sock [mysqldump] socket=/var/lib/mysql/mysql.sock [mysqlcheck] socket=/var/lib/mysql/mysql.sock

Save