Centos8.1安裝mysql8.0.17

• 先檢查系統是否裝有mysql  

        rpm -qa | grep mysql

• 下載下傳mysql的repo源(CentOS yum對應的是mysql 8.0.17版本)

       wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

       安裝mysql-community-release-el7-5.noarch.rpm包

       sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

• 安裝MySQL

       sudo yum install mysql-server

• 重新開機MySQL服務

       service mysqld restart

• 接着登陸設定密碼

      mysql -u root

      use mysql;

      ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'jiayoubing';

• 修改遠端登入配置.

      update user set host='%' where user='root' and host='localhost';   //%表示運作其他ip通路mysql

      flush privileges;    //重新整理配置

      exit;

• 關閉防火牆

       systemctl stop firewalld.service

• 檢視mysql是否安裝成功

        ps -ef | grep mysql

        mysqladmin --version

[[email protected] ~]# ps -ef | grep mysql
root      27345   1926  0 18:01 pts/0    00:00:00 mysql
mysql     27477      1  0 18:11 ?        00:00:06 /usr/libexec/mysqld --basedir=/usr
root      27552   1926  0 18:12 pts/0    00:00:00 mysql -u root
root      27604  27363  0 18:47 pts/1    00:00:00 grep --color=auto mysql
[[email protected] ~]# mysqladmin --version
mysqladmin  Ver 8.0.17 for Linux on x86_64 (Source distribution)