二进制包安装MYSQL-5.7

1、软件下载地址

https://downloads.mysql.com/archives/community/
进入链接选择需要下载的版本即可进行下面的安装操作。

2、安装步骤

2.1依赖包安装

yum install libaio  numactl

2.2创建用户

groupadd  mysql
useradd -r -g mysql -s /bin/false mysql

2.3解压安装包

tar zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz  -C /usr/local/
ln -s mysql-5.7.22-linux-glibc2.12-x86_64  mysql

2.4创建配置文件

配置文件缺省位置/etc/my.cnf
红色字体部分可根据实际情况修改

 [client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
user = mysql
port = 3306
basedir = /usr/local/mysql
datadir = /data/mysql/
socket = /tmp/mysql.sock
character-set-server = utf8mb4
skip_name_resolve = 1
open_files_limit = 65535
back_log = 1024
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 = /data/mysql/slow.log
log-error = /data/mysql/error.log
long_query_time = 0.5
server-id = 3306100
log-bin = /data/mysql/mysql-binlog
sync_binlog = 1
expire_logs_days = 7
master_info_repository = TABLE
relay_log_info_repository = TABLE
binlog_format = row

lock_wait_timeout = 3600
innodb_thread_concurrency = 0
innodb_sync_spin_loops = 100
innodb_spin_wait_delay = 30
transaction_isolation = READ-COMMITTED
innodb_buffer_pool_size = 256M
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 32M
innodb_log_files_in_group = 2
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000
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_stats_on_metadata = 0
innodb_status_file = 1
innodb_status_output = 0
innodb_status_output_locks = 0

[mysqldump]
quick
max_allowed_packet = 32M

2.5初始化数据库

mkdir -p /data/mysql

cd /usr/local/mysql/bin 
./mysqld  --defaults-file=/etc/my.cnf --basedir=/user/local/mysql  --datadir=/data/mysql  --user=mysql --initialize

2.6启动服务

./mysqld_safe --defaults-file=/etc/my.cnf &

2.7 环境变量

vi  .bash_profile
export PATH=$PATH:/usr/local/mysql/bin

2.8密码修改

初始密码在error日志中查找

mysql  -uroot  -p***

mysql> set password = 'root'
mysql> alter user 'root'@'localhost' password expire never;
mysql> flush privileges;

2.9关闭服务

 mysqladmin -uroot -proot shutdown 

3、添加mysql服务

cd /usr/local/mysql/
cp support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig --list mysqld
chkconfig mysqld off
service mysqld stop 
service mysqld start