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)