【mysql】MySQL5.7二进制方式安装（mysql5.7&CentOS6.8）----模拟生产库

MySQL5.7二进制方式安装（mysql5.7&CentOS6.8）----模拟生产库

--将mysql二进制包上传到服务器并解压
先创建/u01/mysql，然后将安装包上传到这里
# mkdir -p /u01/mysql
解压安装包到/u01/mysql目录
# tar zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz -C /u01/mysql            #注意如果需要解压到指定的目录需要加-C参数
更改文件夹名
# mv /data/mysql-5.7.21-linux-glibc2.12-x86_64 /u01/mysql/mysql5.7

--安装依赖包，使用yum安装，故前提条件是网络源的yum方式可用
# yum -y install libaio

--创建mysql用户和组
# groupadd mysql
# useradd -g mysql mysql
# passwd mysql

--配置数据库目录
# mkdir -p /u01/mysql/{myetc,mydata,logs}
# chown mysql:mysql -R /u01/mysql

--配置环境变量
# echo "export PATH=$PATH:/u01/mysql/mysql5.7/bin" >> /etc/profile
# source /etc/profile

--配置my.cnf文件---适当调整 innodb_buffer_pool 大小就可以了。（建议物理内存的50-80%）
# vi /u01/mysql/myetc/my.cnf
[client]
port    = 3306
socket    = /tmp/mysql.sock

[mysql]
prompt="\u@db \R:\m:\s [\d]> "
no-auto-rehash

[mysqld]
user    = mysql
port    = 3306
basedir    = /u01/mysql/mysql5.7
datadir    = /u01/mysql/mydata
socket    = /tmp/mysql.sock
pid_file = /u01/mysql/myetc/mysql.pid
character-set-server = utf8mb4
log_timestamps = SYSTEM
skip_name_resolve = 1
open_files_limit    = 65535
back_log = 1024
max_connections = 500
max_connect_errors = 1000000
table_open_cache = 1024
table_definition_cache = 1024
table_open_cache_instances = 64
thread_stack = 512K
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 4M
join_buffer_size = 4M
thread_cache_size = 768
query_cache_size = 0
query_cache_type = 0
interactive_timeout = 600
wait_timeout = 600
tmp_table_size = 32M
max_heap_table_size = 32M
slow_query_log = 1
slow_query_log_file = /u01/mysql/logs/slow.log
log-error = /u01/mysql/logs/error.log
long_query_time = 0.1
server-id = 3306101
log-bin = /u01/mysql/logs/mysql-binlog
sync_binlog = 1
binlog_cache_size = 4M
max_binlog_cache_size = 1G
max_binlog_size = 1G
expire_logs_days = 7
gtid_mode = on
enforce_gtid_consistency = 1
log_slave_updates
binlog_format = row
relay_log_recovery = 1
relay-log-purge = 1
key_buffer_size = 32M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 64M
lock_wait_timeout = 3600
explicit_defaults_for_timestamp = 1
innodb_thread_concurrency = 0
innodb_sync_spin_loops = 100
innodb_spin_wait_delay = 30
transaction_isolation = REPEATABLE-READ
innodb_buffer_pool_size = 1024M
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_data_file_path = ibdata1:1G:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 2G
innodb_log_files_in_group = 2
innodb_max_undo_log_size = 4G
innodb_io_capacity = 4000
innodb_io_capacity_max = 8000
innodb_flush_neighbors = 0
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_purge_threads = 4
innodb_page_cleaners = 4
innodb_open_files = 65535
innodb_max_dirty_pages_pct = 50
innodb_flush_method = O_DIRECT
innodb_lru_scan_depth = 4000
innodb_checksum_algorithm = crc32
innodb_lock_wait_timeout = 10
innodb_rollback_on_timeout = 1
innodb_print_all_deadlocks = 1
innodb_file_per_table = 1
innodb_online_alter_log_max_size = 4G
internal_tmp_disk_storage_engine = InnoDB
innodb_stats_on_metadata = 0
innodb_status_file = 1
innodb_status_output = 0
innodb_status_output_locks = 0
performance_schema = 1
performance_schema_instrument = '%=on'

[mysqldump]
quick
max_allowed_packet = 32M
#end

注意：MySQL 5.7.2新增log_timestamps参数，该参数主要是控制error log、genera log等记录日志的显示时间。

--初始化
# cd /u01/mysql/mysql5.7/bin
# ./mysqld  --defaults-file=/u01/mysql/myetc/my.cnf --basedir=/u01/mysql/mysql5.7 --datadir=/u01/mysql/mydata --user=mysql --initialize
此时会生成一个root初始化密码
# grep 'password' /u01/mysql/logs/error.log
--启动数据库
# cd /u01/mysql/mysql5.7/bin
# ./mysqld_safe --defaults-file=/u01/mysql/myetc/my.cnf &
注：启动建议使用mysqld_safe启动，后面加&是后台运行

--登录数据库与修改root密码
# cd /u01/mysql/mysql5.7/bin
# ./mysql -uroot -p
输入上面查到的root初始化密码
修改root密码，设置密码为永不过期
mysql> set password = 'root123';
mysql> alter user 'root'@'localhost' password expire never;
mysql> flush privileges;

--关闭数据库
# mysqladmin -uroot -p密码 shutdown

--查看mysql进程是否存在
# ps -ef|grep mysql