二进制安装MySQL

1.删除centos系统自带的mariadb数据库

rpm -qa|grep mariadb
rpm -e mariadb-libs --nodeps

2.安装libaio库

yum -y install libaio numactl

3.下载并解压mysql-5.7.28

mkdir -p /data/soft
cd /data/soft
wget https://www.oaroad.com/files/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
tar xzvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.28-linux-glibc2.12-x86_64 /data/mysql

4.创建用户

groupadd mysql
useradd -s /sbin/nologin -M mysql -g mysql

5.创建basedir、datadir目录、pid文件、socket文件

mkdir -p /data/mysql/logs
mkdir -p /data/mysql/tmp
touch /data/mysql/logs/mysql.log
touch /data/mysql/logs/mysql-error.log
touch /data/mysql/logs/mysql-slow.log
touch /data/mysql/tmp/mysqld.pid
touch /data/mysql/tmp/mysql.sock
chown -R mysql.mysql /data/mysql

6.创建配置文件

vim /etc/my.cnf
[mysqld]
user = mysql
server_id = 1
port = 3306
basedir = /data/mysql
datadir = /data/mysql/data
log_bin = /data/mysql/logs/mysql-bin
socket = /data/mysql/tmp/mysql.sock
log-error = /data/mysql/logs/mysql-error.log
pid-file = /data/mysql/tmp/mysqld.pid
character-set-server = utf8
local-infile
default_storage_engine = innodb
default_authentication_plugin = mysql_native_password
log_bin_trust_function_creators = 1
slow_query_log = 1
long_query_time = 10
slow_query_log_file = /data/mysql/logs/mysql-slow.log
log-queries-not-using-indexes = 1
log_timestamps = SYSTEM

max_connections = 1000
max_connect_errors = 1000
table_open_cache = 2048
max_allowed_packet = 2048M
open_files_limit = 65535
lower_case_table_names = 1
skip-name-resolve
sql_mode = NO_ENGINE_SUBSTITUTION

#innodb
read_buffer_size = 4M
sort_buffer_size = 4M
tmp_table_size = 32M
thread_cache_size = 32
innodb_thread_concurrency = 8
innodb_buffer_pool_size = 8G
innodb_file_per_table = 1
innodb_write_io_threads = 2
innodb_read_io_threads = 2
innodb_purge_threads = 2
innodb_flush_log_at_trx_commit = 0
innodb_log_file_size = 1G
innodb_log_files_in_group = 2
innodb_log_buffer_size = 64M
innodb_max_dirty_pages_pct = 160
#innodb_lock_wait_timeout = 60
key_buffer_size = 512M

[client]
port = 3306
socket = /data/mysql/tmp/mysql.sock
#default-character-set = utf-8

7.安装初始化

/data/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql

8.把mysql放到本地系统服务中

cp /data/mysql/support-files/mysql.server /etc/init.d/mysqld

9.配置环境变量

vim /etc/profile
export PATH="/data/mysql/bin:$PATH"
source /etc/profile

10.启动服务并加入开机自启

chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld start
chkconfig --add mysqld

11.修改root密码

mysql -uroot -p`grep 'root@localhost' /data/mysql/logs/mysql-error.log |awk -F "[: ]" '{print $NF}'`
alter user "root"@"localhost" identified by "123456";