MySQL configuration + use (occasional updates)

1.MY.CNF Configuration

Add to:

[Client]

Default-character-set = Utf8user = root

[Mysqld]

Binlog_format=rowbind-address=0.0.0.0default_storage_engine=innodbinnodb_autoinc_lock_mode=2innodb_flush_log_ At_trx_commit=0innodb_buffer_pool_size=122minnodb_locks_unsafe_for_binlog=1wsrep_provider=/usr/lib/libgalera_ Smm.sowsrep_cluster_address=gcomm://192.168.189.24,192.168.189.25,192.168.189.30wsrep_cluster_name=yuqing_db_ Clusterwsrep_node_address=192.168.189.24wsrep_node_name=yuqing_db_node001wsrep_sst_method=rsyncwsrep_slave_ Threads=4explicit_defaults_for_timestamp=1default-time-zone = ' the ' "

Comments:

bind-address=127.0.0.0

　　

MySQL configuration + use (occasional updates)