centos7离线安装mysql

//查看是否安装mariadb
rpm -qa|grep mariadb
//删除mariadb
rpm -e --nodeps mariadb-libs
//解压离线安装包
tar -xvf mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar
//逐个安装
rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm
/*//编辑配置文件
vi /etc/my.cnf
#datadir=/var/lib/mysql
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid*/
//启动mysql
systemctl start mysqld.service
//设置开机启动
systemctl  enable mysqld
//查看root登录密码
cat /var/log/mysqld.log | grep password
//登录
mysql -u root -p  
//设置密码策略
set global validate_password_policy = 0;
//设置密码长度
set global validate_password_length=6;
//修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
//修改远程登录权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
//刷新权限
FLUSH PRIVILEGES;
//向防火墙暴露3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
//防火墙刷新
firewall-cmd --reload
//重置root密码
vi /etc/my.cnf
skip-grant-tables
//重启mysql
systemctl restart mysqld.service
//登录
mysql -u root -p
//修改为空字符串 
update user set authentication_string='' where user='root';
注掉skip-grant-tables
//重启mysql
systemctl restart mysqld.service
修改即可