Yum安装MySQL 5.7版本

--安装源--

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

yum -y install mysql57-community-release-el7-11.noarch.rpm

yum -y install mysql-server --nogpgcheck

--服务启动--

systemctl start mysqld.service
systemctl status mysqld.service

systemctl enable mysqld.service

--更改密码--

cat /var/log/mysqld.log| grep password

 

ALTER USER USER() IDENTIFIED BY '123456';

set global validate_password_policy=0;

set global validate_password_mixed_case_count=1;

set global validate_password_number_count=1;

set global validate_password_length=4;

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

alter user 'root'@'%' identified by '123456' password expire never;

flush privileges;

 

---数据备份---

mysqldump -u root -p --all-databases > backup.sql;

mysqldump -u root -p database_name table_name > backup.sql;

---仅安装客户端---

yum -y install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

yum -y install mysql-community-common --nogpgcheck

yum -y install mysql-community-client --nogpgcheck