【LWei-数据库-安装】CentOS下安装Mysql5.7.X解压版的教程详解

CentOS6.5下安装Mysql5.7.18，首先先下载mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz，传到CentOS6.5系统下的/usr/local目录下，执行如下命令：

配置文件示例：my.cnf

[mysql]

port                            =3306
socket                          =/tmp/mysql.sock

[mysqld]
#************** basic ***************
datadir                         =/opt/mysql/data
basedir                         =/opt/mysql
port                            =3306
socket                          =/tmp/mysql.sock
pid_file                        =/opt/mysql/data/c5-xa-xslt-bbs1.pid
user                            =mysql
#skip_grant_tables

#************** connection ***************
max_connections                 =1000
max_connect_errors              =1000

#************** sql timeout & limits ***************

lock_wait_timeout               =60
autocommit                      =1
lower_case_table_names          =1
thread_cache_size               =64
character_set_server            =utf8
transaction-isolation           ="READ-COMMITTED"
skip_name_resolve               =ON
explicit_defaults_for_timestamp =ON
log_timestamps                  =SYSTEM
event_scheduler                 =OFF
query_cache_type                =OFF
query_cache_size                =0
lc_messages                     =en_US
lc_messages_dir                 =/opt/mysql/share
init_connect                    ="set names utf8"
sql_mode                        =STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
#******************* err & slow & general ***************
log_error                       =/opt/mysql/elog/mysql.err
slow_query_log                  =ON
slow_query_log_file             =/tmp/mysql-slow.log
long_query_time                 =5
log_queries_not_using_indexes   =OFF
general_log                     =1
general_log_file                =/opt/mysql/elog/general.log
server-id = 194230

#************** binlog & relaylog ***************
expire_logs_days                =7
sync_binlog                     =2000
log-bin                         =/opt/mysql/blog/mysql-bin
log-bin-index                   =/opt/mysql/blog/mysql-bin.index
max_binlog_size                 =500M
binlog_format                   =ROW
binlog_rows_query_log_events    =ON
binlog_cache_size               =2M
binlog_stmt_cache_size          =2M
max_binlog_cache_size           =2G
max_binlog_stmt_cache_size      =2G

relay_log                       =/opt/mysql/blog/relay
relay_log_index                 =/opt/mysql/blog/relay.index
max_relay_log_size              =500M
relay_log_purge                 =ON
relay_log_recovery              =ON

log-slave-updates               =1




#*************** buffer & timeout ***************
read_buffer_size                =8M
read_rnd_buffer_size            =16M
sort_buffer_size                =16M
join_buffer_size                =32M
tmp_table_size                  =64M
max_allowed_packet              =64M
max_heap_table_size             =64M
connect_timeout                 =10
wait_timeout                    =600
interactive_timeout             =600
net_read_timeout                =30
net_write_timeout               =30

#*********** myisam ***************
skip_external_locking           =ON
key_buffer_size                 =16M
bulk_insert_buffer_size         =16M
concurrent_insert               =ALWAYS
open_files_limit                =65000
table_open_cache                =16000
table_definition_cache          =16000

#*********** innodb ***************
default_storage_engine              =InnoDB
default_tmp_storage_engine          =InnoDB
internal_tmp_disk_storage_engine    =InnoDB
innodb_data_home_dir                =/opt/mysql/data
innodb_log_file_size                =2048M
innodb_log_files_in_group           =3
innodb_flush_log_at_trx_commit      =2
innodb_fast_shutdown                =1
innodb_flush_method                 =O_DIRECT
innodb_io_capacity                  =2000
innodb_io_capacity_max              =4000
innodb_buffer_pool_size             =25G
innodb_log_buffer_size              =32M
innodb_autoinc_lock_mode            =1
innodb_buffer_pool_load_at_startup  =ON
innodb_buffer_pool_dump_at_shutdown =ON
innodb_buffer_pool_dump_pct         =15
innodb_max_dirty_pages_pct          =85
innodb_lock_wait_timeout            =10
#innodb_locks_unsafe_for_binlog      =1
innodb_old_blocks_time              =1000
innodb_open_files                   =63000
innodb_page_cleaners                =8
innodb_strict_mode                  =ON
innodb_thread_concurrency           =64
innodb_sort_buffer_size             =64M
innodb_rollback_on_timeout          =ON

innodb_lru_scan_depth               =512
innodb_write_io_threads             =8

yum search libaio # search for info
yum install libaio # install library
groupadd mysql
useradd mysql -g mysql
tar -zxvf /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.18-linux-glibc2.5-x86_64/ mysql
cd mysql/
mkdir data
cd ../
chown -R mysql:mysql mysql/
chmod -R 755 mysql/
cd mysql
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize

# 查找密码
2017-04-21T02:36:15.620346Z 1 [Note] A temporary password is generated for root@localhost: o*s#gqh)F4Ck

# 启动及配置

./support-files/mysql.server start
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
service mysqld restart
mysql -uroot -po*s#gqh)F4Ck
alter user 'root'@'localhost' identified by 'newpswd'
update user set user.Host='%' where user.User='root';
flush privileges;