数据库-MySQL

1、下载路径

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

2、解压

tar -xvf mysql-5.7.30-1.el7.x86_64.rpm-bundle(2).tar(数据库安装包)

3、环境检查

rpm -qa | grep mysql

rpm -qa | grep mariadb

卸载 rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

4、安装

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

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

rpm -ivh mysql-community-devel-5.7.30-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-5.7.30-1.el7.x86_64.rpm

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

yum install net-tools -y

yum install perl -y

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

5、服务命令

systemctl status mysqld

systemctl start mysqld

systemctl stop mysqld

systemctl enable mysqld（开机自启动）

systemctl disable mysqld

6、密码重置及远程配置

cat /var/log/mysqld.log | grep password（获取临时密码）

mysql -u root -p 输入临时密码

mysql> set global validate_password_length=4;

mysql> set global validate_password_policy=LOW;

mysql> set password = password('root');

mysql> grant all on . to 'root'@'%' identified by 'root';

mysql> flush privileges;

mysql> exit;