MySQL8.0+离线安装

卸载MariaDB

查看版本

rpm -qa | grep mariadb

卸载

rpm -e mariadb-libs-xxxxx --nodeps

检查是否卸载干净

rpm -qa | grep mariadb

安装MySQL
上传解压
mkdir /usr/local/mysql

上传

解压tar -xvf mysql-8.0.34-1.el7.x86_64.rpm-bundle.tar

安装

安装common

rpm -ivh mysql-community-common-8.0.34-1.el7.x86_64.rpm --nodeps --force

安装libs

rpm -ivh mysql-community-libs-8.0.34-1.el7.x86_64.rpm --nodeps --force

安装client

rpm -ivh mysql-community-client-8.0.34-1.el7.x86_64.rpm --nodeps --force

安装server

rpm -ivh mysql-community-server-8.0.34-1.el7.x86_64.rpm --nodeps --force

查看mysql安装包

rpm -qa | grep mysql

初始化MySQL
mysqld --user=mysql --basedir=/usr/local/mysql/mysql8 --datadir=/usr/local/mysql/mysql8/data/ --initialize

vim /etc/my.cnf #调整datadir目录

chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld.service; # 开机启动

修改密码
&rXpsOypv0do
cat /var/log/mysqld.log | grep password
mysql -uroot -p 登录

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'AaBb.1.1.1.';
exit; # 退出后通过新密码登录

远程访问授权

use mysql;
select host,user from user;
update user set host = '%' where user = 'root';

重启mysql

systemctl resatrt mysqld.service