CentOS7.7 安装mysql5.6.47

官网下载
tar -xf MySQL-5.6.47-1.el7.x86_64.rpm-bundle.tar
MySQL-client-5.6.47-1.el7.x86_64.rpm
MySQL-devel-5.6.47-1.el7.x86_64.rpm
MySQL-embedded-5.6.47-1.el7.x86_64.rpm
MySQL-server-5.6.47-1.el7.x86_64.rpm
MySQL-shared-5.6.47-1.el7.x86_64.rpm
MySQL-shared-compat-5.6.47-1.el7.x86_64.rpm
MySQL-test-5.6.47-1.el7.x86_64.rpm


=====安装之前 自检========
1.
rpm -qa|grep maria
    mariadb-libs-5.5.64-1.el7.x86_64
yum -y remove mariadb-libs-5.5.64-1.el7.x86_64

2.vi /etc/selinux/config
SELINUX=disabled

3.init 6



=====安装========
1.yum localinstall -y MySQL-server-5.6.47-1.el7.x86_64.rpm MySQL-client-5.6.47-1.el7.x86_64.rpm

2.vi /etc/my.cnf
[mysqld]
port=25555
datadir=/home/mysql/data/mysql
socket=/home/mysql/data/mysql/mysql.sock
lower_case_table_names=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql]
socket=/home/mysql/data/mysql/mysql.sock

3.
mkdir -p /home/mysql/data
cp -r /var/lib/mysql /home/mysql/data
chown -R mysql:mysql /home/mysql/data/mysql


4.service mysql start
// 查看初始化密码
cat /root/.mysql_secret

set password for root@localhost= password("root");
grant all privileges on *.* to root@'%' identified by 'root' with grant option;

5.设置开机自启动
chkconfig mysql on
chkconfig --list|grep mysql

6.如果远程连接不上  关闭防火墙 重启才会生效
systemctl disable firewalld