Linux服务器 mysql5.7安装流程

    cd /usr/local   #切换到安装包所在目录
    tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

    mv mysql-5.7.30-linux-glibc2.12-x86_64 /usr/local/mysql

    groupadd mysql
    useradd -r -g mysql mysql

    mkdir -p  /data/mysql              
    chown mysql:mysql -R /data/mysql  

    vi /etc/my.cnf

    [client]
    port = 3306
    
    [mysqld]
    bind-address=0.0.0.0
    port=3306
    user=mysql
    basedir=/usr/local/mysql
    datadir=/data/mysql
    socket=/tmp/mysql.sock
    log-error=/data/mysql/mysql.err
    pid-file=/data/mysql/mysql.pid
    #character config
    character_set_server=utf8mb4
    explicit_defaults_for_timestamp=true
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mariadb according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d

    cd /usr/local/mysql/bin
    ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize

    rpm -qa|grep libaio

    yum install  libaio-devel.x86_64

    cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

    service mysql start

    touch /var/log/mariadb/mariadb.log
    chown -R mysql:mysql /var/log/mariadb/

    service mysql start

    cat /data/mysql/mysql.err

    ./mysql -u root -p

    SET PASSWORD = PASSWORD('123456');
    ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
    FLUSH PRIVILEGES;  

    use mysql                                            
    update user set host = '%' where user = 'root';      
    FLUSH PRIVILEGES;