[client] 

port=3306

socket=/MysqL/MysqL.sock

default-character-set=utf8

[MysqLd]

port=3306

character-set-server=utf8

default_storage_ENGIne = innodb

log_timestamps = SYstem

socket = /MysqL/MysqL.sock

basedir= /MysqL

datadir = /MysqL/data

pid-file = /MysqL/MysqL.pid

@H_430_21@max_connections = 1000

@H_430_21@max_connect_errors = 1000

table_open_cache = 1024

@H_430_21@max_allowed_packet = 128M

open_files_limit = 65535

explicit_defaults_for_timestamp=true

expire_logs_days=30

#####====================================[innodb]==============================

innodb_buffer_pool_size = 1024M

innodb_file_per_table = 1

innodb_write_io_threads = 4

innodb_read_io_threads = 4

innodb_purge_threads = 2

innodb_flush_log_at_trx_commit = 1

innodb_log_file_size = 512M

innodb_log_files_in_group = 2

innodb_log_buffer_size = 16M

innodb_max_dirty_pages_pct = 80

innodb_lock_wait_timeout = 30

innodb_data_file_path=ibdata1:1024M:autoextend

#####====================================[log]==============================

log_error = /MysqL/MysqL-error.log

slow_query_log = 1

long_query_time = 1 

slow_query_log_file = /MysqL/MysqL-slow.log

添加MySQL命令链接

ln -s /MysqL/bin/MysqL /usr/local/bin/MysqL

配置MysqL启动服务

cp /MysqL/support-files/MysqL.server /etc/init.d/MysqLd;

chmod 755 /etc/init.d/MysqLd;

chkconfig --add MysqLd;

chkconfig MysqLd on;

打开3306端口，允许远程访问

vi /etc/rc.local

#添加

service MysqLd start

chown MysqL:MysqL /MysqL -R

su - MysqL #一定要加-

3、MysqL server PID file Could not be found![Failed]

    查看错误日志tail -f MysqL-error.log ;找（ERROR）发下是[ERROR] unkNown variable ‘expire_logs_day=30‘参数配置错误

4、Can‘t open the MysqL.plugin table. Please run MysqL_upgrade to create it.

    清除log文件、data目录下的文件；重新初始化：/MysqL/bin/MysqLd --user=MysqL --basedir=/MysqL --datadir=/MysqL/data --initialize --pid-file=/MysqL/MysqL.pid；service MysqLd restart;

5、#ERROR 1146 (42s02): Table ‘MysqL.servers‘ doesn‘t exist