1.卸载mariadb
#yum list installed | grep mariadb
#yum -y remove mariadb*
2.下载MySQL tar
#wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.23-1.el7.x86_64.rpm-bundle.tar
#yum install -y perl-Module-Install.noarch
3.解压tar包
#tar xvf mysql-5.7.23-1.el7.x86_64.rpm-bundle.tar
4.安装
#rpm -ivh mysql-community-common-5.7.23-1.el7.x86_64.rpm
#rpm -ivh mysql-community-libs-5.7.23-1.el7.x86_64.rpm
#rpm -ivh mysql-community-client-5.7.23-1.el7.x86_64.rpm
#rpm -ivh mysql-community-server-5.7.23-1.el7.x86_64.rpm
如果安装报错: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
使用 rpm -ivh mysql-community-server-5.7.23-1.el7.x86_64.rpm --force --nodeps
5.初始化mysql
#mysqld --initialize
6.设置权限
#chmod -R 777 /var/lib/mysql/
7.启动服务
#systemctl start mysqld.service
8.查看初始化密码
#cat /var/log/mysqld.log
9.本地登录mysql
#mysql -uroot -p"填写查看到的密码"
10.修改密码并授权远程登录
mysql> set PASSWORD = PASSWORD(‘新密码’);
mysql> grant all privileges on . to root@’%’ identified by “新密码”;
mysql> flush privileges;
其他
#备份数据库(压缩)
mysqldump -h127.0.0.1 -p3306 -uroot -p密码 数据库名称 | gzip > /data/dbname-date +%Y%m%d%H%M%S
.sql.gz