https://downloads.mysql.com/archives/community/

mkdir -p /data/mysql /data/logs/mysql/

touch /data/logs/mysql/mysqld.log 

touch /data/logs/mysql/mysql-slow.log

chown -R mysql.mysql  /data/mysql  /data/logs/mysql/

chmod -R 777   /data/logs/mysql/

ln -sf /data/mysql /var/lib/

ln -sf /data/logs/mysql/mysqld.log   /var/log/mysqld.log

ln -sf /data/logs/mysql/mysql-slow.log   /var/log/mysql-slow.log

cd /opt

wget  https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

tar -xvf mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-common-5.7.44-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.44-1.el7.x86_64.rpm

yum install -y libncurses*

rpm -ivh mysql-community-client-5.7.44-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.44-1.el7.x86_64.rpm

systemctl restart mysqld.service

systemctl status mysqld.service

systemctl start mysqld.service

systemctl stop mysqld.service

#临时密码

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p

#修改密码执行

alter user root@localhost identified by '密码';

-设置密码长度：

set global validate_password_policy=0; 

set global validate_password_length=1;

-重设密码

set password for root@localhost=password('密码');

-开启远程连接权限

use mysql;

select user,host from user;

grant all privileges on *.* to root@'%' identified by '密码';

flush privileges;

-查看mysql进程 

ps -ef|grep mysql

-查看3306端口 

netstat -anop|grep 3306

vim  /etc/my.cnf

# diy
bind-address = 0.0.0.0
user=mysql
skip-host-cache
skip-name-resolve
slow_query_log_file = /var/log/mysql-slow.log
long_query_time = 10
default-storage-engine = innodb
explicit_defaults_for_timestamp = true
server-id = 1
max_allowed_packet = 800M
log-bin=mysql-bin
binlog_format=mixed
expire_logs_days = 5
max_binlog_size = 800M

#卸载

yum remove -y mysql

# centos8异常修改

vim   /usr/lib/tmpfiles.d/mysql.conf

/var/run/mysqld → /run/mysqld