mysql二进制文件方式安装

1：从华为云镜像网站下载
wget --no-check-certificate https://mirrors.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-i686.tar.gz

2：安装依赖
yum search libaio
yum install libaio

3：添加用户组
groupadd mysql
useradd -r -g mysql -s /bin/false mysql

4：解压文件到apps目录
tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.26-linux-glibc2.12-x86_64 ./mysql5726

5：数据目录并授权目
mkdir /apps/mysqldata
mkdir /apps/mysqldata/data
chown -R mysql.mysql /apps/mysqldata
chown -R root.root /apps/mysql5726

6:初始化数据文件（–initialize可以这是更多的参数，待详细研究）
bin/mysqld --initialize --basedir=/apps/mysql5726/ --datadir=/apps/mysqldata/data --user=mysql
并从日志中保持 临时密码

7:执行以下命令创建RSA private key
bin/mysql_ssl_rsa_setup --datadir=/apps/mysqldata/data

8：自定义cnf文件（/apps/mysqldata/mysql5726.cnf）

[client]
port            = 3306
socket          = /apps/mysqldata/mysql.sock   单实例安装是可以不用配置

[mysql]
no-auto-rehash

[mysqld]
user    = mysql
port    = 3306
socket  = /apps/mysqldata/mysql.sock 单实例安装是可以不用配置
basedir = /apps/mysql5726
datadir = /apps/mysqldata/data
open_files_limit    = 1024
back_log = 600
max_connections = 800
max_connect_errors = 3000
table_open_cache = 614
external-locking = FALSE
max_allowed_packet =8M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 100
#thread_concurrency = 2
query_cache_size = 2M
query_cache_limit = 1M
query_cache_min_res_unit = 2k
#default_table_type = InnoDB
thread_stack = 192K
#transaction_isolation = READ-COMMITTED
tmp_table_size = 2M
max_heap_table_size = 2M
#long_query_time = 1
#log_long_format
#log-error = /apps/mysqldata/data/error.log
#log-slow-queries = /apps/mysqldata/data/slow.log
pid-file = /apps/mysqldata/mysql.pid
log-bin = /apps/mysqldata/data/mysql-bin
binlog_cache_size = 1M
max_binlog_cache_size = 1M
max_binlog_size = 2M
expire_logs_days = 6
key_buffer_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 1M
lower_case_table_names = 1
skip-name-resolve
slave-skip-errors = 1032,1062
replicate-ignore-db=mysql
server-id = 6

[mysqldump]
quick
max_allowed_packet = 2M

[mysqld_safe]
log-error=/apps/mysqldata/3306.err
pid-file=/apps/mysqldata/data/mysqld.pid  单实例安装是可以不用配置

9测试启动
su -mysql

/apps/mysql5726/bin/mysqld --defaults-file=/apps/mysqldata/mysql5726.cnf &

10:验证登陆
/apps/mysql5726/bin/mysql -uroot -p -S /apps/mysqldata/mysql.sock

常用命令：
关闭服务
/apps/mysql5726/bin/mysqladmin -uroot -proot -S /apps/mysqldata/mysql.sock shutdown
启动服务
/apps/mysql5726/bin/mysqld_safe --defaults-file=/apps/mysqldata/mysql5726.cnf --pid-file=/apps/mysqldata/mysql.sock
命令行登陆
/apps/mysql5726/bin/mysql -uroot -p -S /apps/mysqldata/mysql.sock