内网安装mysql5.7

内网不能联网，无法yum安装，使用tar包安装

1 下载

官网下载mysql5.7

$ tar xvf mysql-5.7.27-linux-glibc2.12-x86_64.tar
解压后有两个包
$ ll
-rw-r--r-- 1 adminis adminis 644916075 Jun 11 00:09 mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
-rw-r--r-- 1 adminis adminis  31651176 Jun 11 00:06 mysql-test-5.7.27-linux-glibc2.12-x86_64.tar.gz
只使用到 mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz

2 脚本安装

#!/usr/bin/env bash

pkg="mysql"
port="3306"

rpm -qa |grep mariadb
rpm -e --nodeps mariadb-libs-*
rpm -qa |grep -i ${pkg}

userdel -r ${pkg} >/dev/null 2>&1
groupdel ${pkg} >/dev/null 2>&1

groupadd ${pkg}
useradd -g ${pkg} ${pkg}

#mkdir -p /data/soft
mkdir -p /data/server
#wget -O /data/soft/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
tar zxvf /data/soft/mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz -C /data/server/
ln -s /data/server/mysql-5.7.27-linux-glibc2.12-x86_64 /data/server/${pkg}
chown -R ${pkg}:${pkg} /data/server/${pkg}*

mkdir -p /data/conf/${pkg}
mkdir -p /data/log/${pkg}
mkdir -p /data/db/${pkg}/${port}
mkdir -p /data/var/lib/${pkg}
mkdir -p /data/var/run/${pkg}
mkdir -p /data/var/cache/${pkg}
chown -R ${pkg}:${pkg} /data/{conf,log,db,var/{lib,run,cache}}/${pkg}
chown -R ${pkg}:${pkg} /data/db/${pkg}/${port}

cat>>/data/conf/${pkg}/${port}.cnf<<_EOF_
[mysql]
default-character-set=utf8

[mysqld]
log_timestamps=SYSTEM
explicit_defaults_for_timestamp=true
basedir=/data/server/${pkg}
datadir=/data/db/${pkg}/${port}
port=${port}
socket=/data/var/lib/${pkg}/${port}.sock
pid-file=/data/var/run/${pkg}/${port}.pid
user=${pkg}
symbolic-links=0
back_log=50
max_connections=1000
character-set-server=utf8
default-storage-engine=INNODB
innodb_file_per_table=on
innodb_buffer_pool_size=4G
#skip-name-resolve=on
lower_case_table_names=1
max_allowed_packet=16M

log-error=/data/log/${pkg}/error${port}.log

slow_query_log=on
long_query_time=5
slow_query_log_file=/data/log/${pkg}/slow_query${port}.log

query_cache_type=1
query_cache_limit=2M
query_cache_size=64M

_EOF_
chown -R ${pkg}:${pkg} /data/conf/${pkg}/${port}.cnf
echo "Finished"

使用脚本安装提前创建好/data目录和/data/soft并将mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz包放到/data/soft目录下

3 初始化数据库并修改密码

赋权

chown -R mysql:mysql /data

切换到mysql普通用户，配置默认环境变量

vi .bash_profile
export PATH=$PATH:/data/server/mysql/bin
立即生效
source .bash_profile 

初始化

./mysqld --initialize --user=mysql  --basedir=/data/server/mysql --datadir=/data/db/mysql/3306

初始化成功后会出现一个初始密码，需要记住
启动数据库

mysqld --defaults-file=/data/conf/mysql/3306.cnf --basedir=/data/server/mysql --datadir=/data/db/mysql/3306

修改默认密码
输入默认密码登陆后需要修改密码

mysql -uroot -p
set password for root@localhost=password("123456");

4 报错：

1 初始化报错：

./mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

解决：

通过yum install -y libnuma.so.1  后，还是无法解决。
最终，通过yum install -y numactl解决

2 启动报错

Can't connect to local MySQL server through socket '/tmp/mysql.sock

解决：

ln -s /data/var/lib/mysql/3306.sock /tmp/mysql.sock
php标准配置正是用过'/tmp/mysql .sock'