linux centos 安装mysql8.0

一：下载
    wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
二：安装
    rpm -ivh mysql80-community-release-el7-1.noarch.rpm
    yum install mysql-server
三：初始化
    mysqld --initialize
四：启动mysql
    chown -R mysql:mysql /var/lib/mysql 
    service mysqld start    
五：验证mysql是否按装成功    
    mysqladmin --version    
六：查看初始密码
    grep "A temporary password" /var/log/mysqld.log
七：连接mysql
    mysql -uroot -p + 初始密码
    use mysql; 会报错：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
    解决办法：alter user 'root'@'localhost' identified by 'root';// root 为新密码 可随意更改
八：授权远程连接
    select host, user, authentication_string, plugin from user;
    update user set host='%' where user='root';
    FLUSH PRIVILEGES;
九：修改sql_model问题
    select @@global.sql_mode;
    set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
    FLUSH PRIVILEGES;

注：以上操作纯属个人总结，不喜勿喷