rpm -qa|grep -i mysql
rpm -ev --nodeps mysql-community-server-5.6.51-2.el7.x86_64
find / -name mysql
rm -rf /var/lib/mysql/
wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
yum repolist all | grep mysql
yum -y install yum-utils #为了yum-config-manager可以用
禁用8.0
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
进行安装时请确保只有一个版本启用,否则会显示版本冲突
yum repolist enabled | grep mysql
yum install mysql-community-server
mysql --version
sudo systemctl start mysqld.service
sudo systemctl status mysqld.service
sudo grep ‘temporary password’ /var/log/mysqld.log
set global validate_password_policy=LOW;
set global validate_password_length=6;
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
systemctl restart mysqld.service
systemctl enable mysqld.service