配置my.cnf
cd /usr/local/mysql/support-filescp my-default.cnf /etc/my.cnfvim /etc/my.cnf=====================================[client]#password = your_passwordport = 3306socket = /data/mysql_data/run/mysql.sockdefault-character-set=utf8[mysqld]port = 3306socket = /data/mysql_data/run/mysql.sockbasedir = /usr/local/mysqldatadir = /data/mysql_dataskip-external-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64sort_buffer_size = 512Knet_buffer_length = 8Kread_buffer_size = 256Kread_rnd_buffer_size = 512Kmyisam_sort_buffer_size = 8Mdefault-storage-engine = InnoDBcharacter_set_server = utf8tmpdir = /data/mysql_data/tmp/log-bin=/data/mysql_data/logs/mysql-binexpire_logs_days= 14binlog_format=mixedlog-error = /data/mysql_data/logs/error.logslow-query-log = 1long_query_time= 3slow_query_log_file = /data/mysql_data/logs/slow.logserver-id = 1innodb_data_home_dir = /data/mysql_data/datainnodb_data_file_path = ibdata1:10M:autoextendinnodb_log_group_home_dir = /data/mysql_data/logsinnodb_buffer_pool_size = 16Minnodb_additional_mem_pool_size = 2Minnodb_log_file_size = 5Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 50innodb_file_per_table = 1[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash[myisamchk]key_buffer_size = 20Msort_buffer_size = 20Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout======================================
2.初始化MYSQL配置表
cd /usr/local/mysql./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql_data/data --user=mysql --forceInstalling MySQL system tables...2015-07-30 18:09:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2015-07-30 18:09:19 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.25-73.1-log) starting as process 8165 ...
3.设置开机自启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql chmod +x /etc/init.d/mysql chkconfig --add mysql chkconfig --level 345 mysql on
4.设置环境变量，方便使用mysql命令
vim /etc/profile在末尾加入：PATH=/usr/local/mysql/bin:$PATH export PATH 保存退出后执行：. /etc/profile 或者 source /etc/profile
5.启动mysql,设置root密码
service mysql startmysqladmin -uroot password '******'