mysql 8.0安装

1. 官网下载安装包

https://dev.mysql.com/downloads/mysql/
mysql-8.0.34-1.el7.x86_64.rpm-bundle.tar

2. 查看mariadba是否有安装，如有则删除

rpm -qa | grep mariadb
删除命令：rpm -e  mariadb-*   --nodeps 
删除后执行rpm -qa查看没有任何返回则说明删除完成

3. 上传mysql安装包到服务器，并解压

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

4. 运行安装,执行如下命令，如执行时提示依赖错误，根据依赖关系执行相应包的安装

rpm -ev mysql-community-client-plugins-8.0.34-1.el7.x86_64 --nodeps
 rpm -ev mysql-community-icu-data-files-8.0.34-1.el7.x86_64 --nodeps
 rpm -ev mysql-community-client-8.0.34-1.el7.x86_64 --nodeps
 rpm -ev mysql80-community-release-el7-3.noarch --nodeps
 rpm -ev mysql-community-server-8.0.34-1.el7.x86_64 --nodeps
 rpm -ev mysql-community-libs-8.0.34-1.el7.x86_64 --nodeps
 rpm -ev mysql-community-common-8.0.34-1.el7.x86_64 --nodeps

执行完成后查看安装情况如下，在表示安装成功

5. 运行如下命令初始化

mysqld --initialize;
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;

7.查看mysql初始密码

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

6. 登录并修改密码
mysql -uroot -p

修改密码为123456
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'
创建远程访问权限
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
为用户赋权
grant all privileges on *.* to 'root'@'%';
flush privilege