centos6.8离线安装mysql5.7

由于centos服务器无法联网，无法直接更新yum源，而安装mysql5.7依赖更高版本的glibc，centos6.8的自带glibc2.12，因此有该安装步骤。

1.检查系统glibc的版本： strings /lib64/libc.so.6 | grep GLIBC

2.查找mysql之前版本：rpm -qa | grep -i mysql

3.卸载mysql之前版本：yum -y remove mysql-libs*

4.查找并删除之前的mysql文件：find / -name mysql

5.官方（https://dev.mysql.com/downloads/mysql/）下载安装包：mysql-5.7.29-linux-glibc2.12-x86_64.tar

6.上传服务器，并解压文件：

    tar -xvf mysql-5.7.29-linux-glibc2.12-x86_64.tar

    tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

7.移动解压文件夹到/usr/local/

    mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql

8.进入mysql目录，并创建data

   cd /usr/local/mysql

   mkdir data

9.查看是否有mysql用户，并创建

   cat /etc/group | grep mysql

   cat /etc/passwd | grep mysql

   userdel -r mysql

   groupadd mysql

   useradd -r -g mysql mysql

   chown -R mysql:mysql /usr/local/mysql

10.创建并修改my.cnf

   vim /etc/my.cnf

文件内容如下：

[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port = 3306
socket=/tmp/mysql.sock

symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/tmp/mysqld/mysqld.pid
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
log-bin=mysql-bin 
binlog-format=ROW 
server_id=1 
max_connections=1000

init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
lower_case_table_names=1

:wq保存退出

11.创建配置中所涉及的文件

touch /tmp/mysql.sock

chown mysql:mysql /tmp/mysql.sock

chmod 755 /tmp/mysql.sock

 

mkdir -p /tmp/mysqld

touch /tmp/mysqld/mysqld.pid

chown mysql:mysql /tmp/mysqld/mysqld.pid

chmod 755 /tmp/mysqld/mysqld.pid

 

touch /var/log/mysqld.log

chown mysql:mysql /var/log/mysqld.log

chmod 755 /var/log/mysqld.log

12.初始化并安装mysql

cd /usr/local/mysql/bin

./mysqld --initialize --user=mysql --basedir=/usr/local/mysql--datadir=/usr/local/mysql/data

./mysqld_safe --user=mysql &

ps -ef | grep mysql

13.查找默认密码

cat /var/log/mysqld.log | grep root@localhost

14.登录数据库

cd /usr/local/mysql/bin

./mysql -u root -p

15.修改密码，配置权限

set password=password("123456");

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant opiton;

flush privileges;

quit

16.设置开机服务自启动

cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

chkconfig --add mysql

chkconfig --list mysql

17.重启服务

service mysql start

service mysql status

service mysql stop

service mysql restart

18.设置任意地方都可运行mysql

ln -s /usr/loca/mysql/bin/mysql /usr/bin

19.打开3306端口，重启防火墙或关闭防火墙

vim /etc/sysconfig/iptables

#mysql
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

service iptables restart

service iptables stop

service iptables status

参考：https://www.cnblogs.com/javabg/p/9951852.html