centos安装MySQL

首先放上官方链接：https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/

我的系统环境是centos7.默认没有安装wget，yum中没有MySQL repository，以下为安装过程：

1、安装wget：

        sudo yum install -y wget

2、wget下载mysql源：

        wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

3、安装mysql源：

       sudo rpm -Uvh mysql80-community-release-el7-1.noarch.rpm

4、查看mysql源

        yum repolist all | grep mysql

5、设置MySQL版本

        sudo vi  /etc/yum.repos.d/mysql-community.repo 

    例如，将5.7设置为可用：

    # Enable to use MySQL 5.7

    [mysql57-community]

    name=MySQL 5.7 Community Server

    baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/

    enabled=1

    gpgcheck=1

    gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

 

6、安装MySQL

    sudo yum install -y mysql-community-server

7、启动MySQL服务并查看状态

    sudo service mysqld start

   sudo service mysqld status

8、设置mysql密码

    查看root@localhost初始密码：

    sudo grep 'temporary password' /var/log/mysqld.log        

    修改初始密码：

    mysql -uroot -p

   ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

9、创建账户并查看

    use mysql;

    select host,user,password from mysql.user;

    CREATE USER 'admin'@'192.168.1.%' IDENTIFIED BY '!Password123';

10、设置远程连接权限

 

    grant all privileges on *.* to 'admin'@'%' identified by '!Password123' with grant option;

11、开启防火墙

 

       firewall-cmd --zone=public --add-port=3306/tcp --permanent

        firewall-cmd --reload