CentOS离线tar包安装MySQL

1.解压tar包

tar -zxvf mysql-5.7.36-el7-x86_64.tar.gz

2. 创建数据目录和日志目录

mkdir data log

//进入log目录

touch mysql.log mysql.pid mysql.sock

//创建mysql用户组

groupadd mysql

useradd -r -g mysql mysql

//赋予权限

chown -R mysql:mysql mysql-5.7.36

3.创建/etc/my.cnf

[client]
port=3306
socket=/opt/mysql-5.7.36/log/mysql.sock
default-character-set=utf8
[mysqld]
port=3306
basedir=/opt/mysql-5.7.36
datadir=/opt/mysql-5.7.36/data
socket=/opt/mysql-5.7.36/log/mysql.sock
log-error=/opt/mysql-5.7.36/log/mysql.log
pid-file=/opt/mysql-5.7.36/log/mysql.pid
character-set-server=utf8

4.初始化mysql

bin/mysqld --initialize --user=mysql --basedir=/opt/mysql-5.7.36 --datadir=/opt/mysql-5.7.36/data

初始化报错：

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

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

安装这两个包就好

//查看密码

cat log/mysql.log

//启动mysql

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

systemctl start mysqld

//登陆

bin/mysql -uroot -p

//启动报错

bin/mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

创建软连接

 ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5

//启动报错

bin/mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

创建软连接

sudo ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

 登陆成功