Centos7安装mysql5.7.35

rpm -qa|grep -i mysql;
rpm -e mysql-community-libs-5.7.36-1.el7.x86_64 --nodeps;

tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz;
mv mysql-5.7.35-linux-glibc2.12-x86_64 /usr/local/mysql
userdel mysql;
groupadd mysql;
useradd -r -g mysql mysql;
mkdir -p  /data/mysql;
chown mysql:mysql -R /data/mysql;

vi /etc/my.cnf

[mysqld]
bind-address=0.0.0.0                    #绑定地址运行远程连接
port=3306                               #Mysql开放的端口
user=mysql                              #数据库登录用户
basedir=/usr/local/mysql                #Mysql安装的绝对路径
datadir=/data/mysql                     #Mysql数据存放的绝对路径
socket=/tmp/mysql.sock                  #套接字文件
log-error=/data/mysql/mysql.err         #mysql生成的错误日志存放的路径
pid-file=/data/mysql/mysql.pid          #为mysqld程序指定一个存放进程ID的文件
character_set_server=utf8mb4            #数据库字符编码
symbolic-links=0                        #是否开启链接符号
explicit_defaults_for_timestamp=true    #数据库timestamp类型的列自动更新

cd /usr/local/mysql/bin/
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
service mysql status
ln -s  /usr/local/mysql/bin/mysql /usr/bin
#查看密码
cat /data/mysql/mysql.err | grep password
mysql -u root -p

SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;
#设置任何主机都可以访问mysql，主要是为了远程Navicat连接
USE mysql;
UPDATE user SET host = '%' WHERE user = 'root';
#权限刷新
FLUSH PRIVILEGES; 
#退出数据库
exit;

service mysql restart;
service mysql status;
cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld;
chmod +x /etc/init.d/mysqld;
chkconfig --add mysqld;
chkconfig --list;
firewall-cmd --zone=public --add-port=3306/tcp --permanent;
firewall-cmd --reload;
firewall-cmd --list-all;