Modify at any time:
1 [Mysqld]2 #basedir=3datadir=/var/lib/MySQL4 #mysql.default_port=33065 #Mysql.default_socket=/tmp/mysql.sock6socket=/var/lib/mysql/Mysql.sock7 #Socket=/tmp/mysql.sock8User=MySQL9 #disabling symbolic-links is recommended to prevent assorted security risksTensymbolic-links=0 Onemax_allowed_packet=32M AEvent_scheduler =0 -Character-set-server =UTF8 -Collation-server =Utf8_general_ci theCharacter-set-server =UTF8 -Collation-server =Utf8_general_ci -Net_read_timeout = 60 -Interactive_timeout = 1000 +Wait_timeout = 1000 -Open_files_limit = 8192 +Back_log = 1024 Amax_connections = 1000 atMax_connect_errors = 100000 -log-output=file -Slow_query_log = 1 -Slow_query_log_file =Slow.log -Log-error =Error.log -Log_warnings = 2 inPid-file =Mysql.pid -Long_query_time = 1 toLog-slow-admin-statements =0 +log-queries- not-using-indexes =0 -Log-slow-slave-statements =0 theSort_buffer_size =2M *Join_buffer_size =2M $Thread_cache_size = 256Panax NotoginsengThread_stack =192K -Key_buffer_size =8M theRead_buffer_size =2M +Read_rnd_buffer_size =16M ABulk_insert_buffer_size =64M the + - [Mysqld_safe] $log-error=/var/log/Mysqld.log $pid-file=/var/run/mysqld/Mysqld.pid -Default-character-set =UTF8 - the - [MySQL]Wuyiprompt ="\\[email protected]\\h \\r:\\m:\\s [\\d]&get:" thePager ="less-i-n-s" -no-auto-Rehash WuTee ="/var/log/mysql/tee.log" -Default-character-set =UTF8 About $ [Mysql.server] -Default-character-set =UTF8 - - [Client] ADefault-character-set = UTF8