Centos 7 安裝 mysql-8.0.22

安裝mysql

一、下載 mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar

地址：https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar

二、查找已安裝的mariadb

[root@hadoop101 mysql]# rpm -qa | grep mariadb

mariadb-libs-5.5.56-2.el7.x86_64

三、卸載mariadb

方法一：rpm -e --nodeps 卸載 mariadb

[root@hadoop101 mysql]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

方法二：yum -y remove 卸載 mariadb

[root@hadoop101 mysql]# yum -y remove mariadb-libs-5.5.56-2.el7.x86_64

四、洗掉mysql的目錄

[root@hadoop101 mysql]# find / -name mysql -print
/etc/selinux/targeted/active/modules/100/mysql
/usr/lib64/mysql
/opt/software/mysql
[root@hadoop101 mysql]# rm -rf /usr/lib64/mysql

五、安裝基礎工具

[root@hadoop101 mysql]# yum -y install wget
[root@hadoop101 mysql]# yum -y install lrzsz
[root@hadoop101 mysql]# yum -y install vim
[root@hadoop101 mysql]# yum -y install net-tools
[root@hadoop101 mysql]# yum -y install openssl openssl-devel
[root@hadoop101 mysql]# yum -y install libaio libaio-devel
[root@hadoop101 mysql]# yum -y install perl perl-devel
[root@hadoop101 mysql]# yum -y install perl-JSON.noarch
[root@hadoop101 mysql]# yum -y install autoconf

六、關閉防火墻

[root@hadoop101 mysql]# firewall-cmd --state
running
[root@hadoop101 mysql]# systemctl stop firewalld
[root@hadoop101 mysql]# firewall-cmd --state
not running
[root@hadoop101 mysql]# systemctl disable firewalld.service

七、關閉selinux，進入到/etc/selinux/config檔案，將SELINUX=enforcing 改為SELINUX=disabled

[root@hadoop101 mysql]# vim /etc/selinux/config

重啟 CentOS…

[root@hadoop101 mysql]# reboot

八、上傳mysql的tar包，解壓tar包

[root@hadoop101 mysql]# tar -xvf mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar
[root@hadoop101 mysql]# ls –lShr

九、安裝mysql 

PS：注意安裝順序 common -> client-plugins -> libs -> client -> server

[root@hadoop101 mysql]# rpm -ivh mysql-community-common-8.0.22-1.el7.x86_64.rpm
[root@hadoop101 mysql]# rpm -ivh mysql-community-client-plugins-8.0.22-1.el7.x86_64.rpm
[root@hadoop101 mysql]# rpm -ivh mysql-community-libs-8.0.22-1.el7.x86_64.rpm
[root@hadoop101 mysql]# rpm -ivh mysql-community-client-8.0.22-1.el7.x86_64.rpm
[root@hadoop101 mysql]# rpm -ivh mysql-community-server-8.0.22-1.el7.x86_64.rpm
[root@hadoop101 mysql]# rpm -ivh mysql-community-libs-compat-8.0.22-1.el7.x86_64.rpm（可選）
[root@hadoop101 mysql]# rpm -ivh mysql-community-devel-8.0.22-1.el7.x86_64.rpm（可選）
[root@hadoop101 mysql]# rpm -ivh mysql-community-embedded-compat-8.0.22-1.el7.x86_64.rpm（可選）
[root@hadoop101 mysql]# rpm -qa | grep mysql
mysql-community-libs-compat-8.0.22-1.el7.x86_64
mysql-community-libs-8.0.22-1.el7.x86_64
mysql-community-client-8.0.22-1.el7.x86_64
mysql-community-embedded-compat-8.0.22-1.el7.x86_64
mysql-community-common-8.0.22-1.el7.x86_64
mysql-community-server-8.0.22-1.el7.x86_64
mysql-community-client-plugins-8.0.22-1.el7.x86_64
mysql-community-devel-8.0.22-1.el7.x86_64

十、初始化資料庫，目錄授權，啟動mysql服務,查看mysql狀態 [注意操作順序]

[root@hadoop101 mysql]# mysqld --initialize --console
[root@hadoop101 mysql]# chown -R mysql:mysql /var/lib/mysql/
[root@hadoop101 mysql]# systemctl start mysqld
[root@hadoop101 mysql]# service mysql status

查看初始化后的臨時密碼

[root@hadoop101 mysql]# grep 'temporary password' /var/log/mysqld.log

或者

[root@hadoop101 mysql]# cat /var/log/mysqld.log | grep 'temporary password'

十一、登錄mysql

[root@hadoop101 mysql]# mysql -u root -p
Enter password: 直接粘貼初始密碼 ，回車確認

十二、修改初始密碼，授權遠程登錄

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; (修改 “password” 為你自己的密碼)
mysql> use mysql; (切換到mysql庫)
mysql> update user set host = "%" where user='root'; (授權遠程登錄)
mysql> flush privileges; (重繪)
mysql> quit; (退出登錄)

測驗連接是否正常

[root@hadoop101 mysql]# mysql -u root –ppassword

連接成功，安裝完畢~~撒花~~