在虚拟机里安装MySQL

#删除默认mysql低版数据库
        rpm -qa|grep mariadb   
                    => #mariadb-libs-5.5.64-l.el7.x84_64
        yum -y remove mariadb-libs-5.5.64-l.el7.x84_64  
#下载并rpm安装mysql
        wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
        rpm -ivh mysql-community-release-el7-5.noarch.rpm
#安装mysql服务
        yum -y install mysql-server

#配置
        vim /etc/my.cnf  以下是配置文件可以直接复制进去
        #---------------------------------------------
        [client]
        default-character-set = utf8mb4
        [mysql]
        default-character-set = utf8mb4
        [mysqld]
        character-set-client-handshake = FALSE
        character-set-server = utf8mb4
        collation-server = utf8mb4_unicode_ci
        datadir=/var/lib/mysql
        socket=/var/lib/mysql/mysql.sock
        symbolic-links=0
        sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
        [mysqld_safe]
        log-error=/var/log/mysqld.log
        pid-file=/var/run/mysqld/mysqld.pid
        #---------------------------------------------
#查看[开启]服务状态
        systemctl status mysqld
        systemctl start mysqld
#登录授权
#获取临时密码
        grep 'temporary password' /var/log/mysqld.log
            #如果能获取到，则用临时密码登录
            mysql -u root -pTEMP_PASS
            #否则尝试mysql回车键，看是否可以直接登录
            mysql
            #登录设置或修改密码
            #下面'root' 是博主设置的mysql登录密码，可以自己设置，账户名为root
            grant all on *.* to root@localhost identified by 'root';#本地登录 
            grant all on *.* to root@'%' identified by 'root';      #远程登录