Centos7.6安装mysql8.0.11

# centOS7.6下安装mysql
# 在/usr/local 下建立mysql文件夹


rpm -qa | grep mariadb               # 查看是否安装mariadb包

rpm -e XXXXXX --nodeps               # 通过该命令卸载mariadb包

cd /usr/local/mysql                  # 进入mysql安装目录

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar        # 下载mysql8.0.11


tar -xvf mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar        # 解压到当前目录

# 安装common

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

# 安装libs

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

 # 安装client

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

 #安装server

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

　　# 查看所有安装的包

rpm -qa | grep mysql            


# 初始化mysql
mysqld --initialize;

chown mysql:mysql /var/lib/mysql -R;

systemctl start mysqld.service;

systemctl enable mysqld;

cat /var/log/mysqld.log | grep password        # 查看初始密码

ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘mysql‘;

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION;

ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘root‘;

FLUSH PRIVILEGES;

quit