MySQL8安装二：二进制安装

布满荆棘的人生 2024-03-23 11:04 35阅读 0赞

9de7bb31d0644e7393039222babfed10

上次记录了源码安装MySQL8, 这次是二进制安装MySQL8.

闲话少说，直接上步骤

### CentOS8.1二进制安装8.0.18单实例 ###

**安装**

#创建用户
    useradd  mysql
    
    #解压安装包
    tar -xvf mysql-8.0.18-linux-glibc2.12-x86_64.tar.xz -C /usr/local
    mv /usr/local/mysql-8.0.18-linux-glibc2.12-x86_64 /usr/local/mysql
    chown -R mysql:mysql /usr/local/mysql
    
    #安装目录和日志
    mkdir -p /var/lib/mysql ; chown -R mysql.mysql /var/lib/mysql   ; chmod -R 755 /var/lib/mysql
    touch /var/log/mysqld.log ; chown mysql:mysql /var/log/mysqld.log
    
    #软连接
    ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5

**my.cnf配置文件**

cat > /etc/my.cnf <<EOF
    [client]
    port=3306
    socket=/var/lib/mysql/mysql.sock
    
    [mysqld]
    server_id=3306
    port=3306
    mysqlx_port=33060
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    mysqlx_socket=/var/lib/mysql/mysqlx.sock
    log_error=/var/log/mysqld.log
    basedir=/usr/local/mysql
    log_bin=binlog
    log_bin_index=binlog.index
    relay_log=relay-log
    relay_log_index=relay-log.index
    transaction-isolation=repeatable-read
    user=mysql
    gtid-mode=on
    enforce_gtid_consistency=on
    binlog_checksum=none
    disabled_storage_engines="MyISAM,BLACKHOLE,ARCHIVE,MEMORY"
    innodb_buffer_pool_size=4G
    binlog_cache_size=1M
    default_time_zone='+8:00'
    federated=on
    event_scheduler=on
    EOF

**systemd配置文件**

cat > /usr/lib/systemd/system/mysqld.service<<EOF
    [Unit]
    Description=MySQL Server
    Documentation=man:mysqld(8)
    Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
    After=network.target
    After=syslog.target
    
    [Install]
    WantedBy=multi-user.target
    
    [Service]
    User=mysql
    Group=mysql
    
    Type=notify
    
    # Disable service start and stop timeout logic of systemd for mysqld service.
    TimeoutSec=0
    
    # Execute pre and post scripts as root
    PermissionsStartOnly=true
    
    # Start main service
    ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
    
    # Sets open_files_limit
    LimitNOFILE = 10000
    
    Restart=on-failure
    
    RestartPreventExitStatus=1
    
    # Set enviroment variable MYSQLD_PARENT_PID. This is required for restart.
    Environment=MYSQLD_PARENT_PID=1
    
    PrivateTmp=false
    EOF

**初始化和启动**

echo 'PATH=$PATH:/usr/local/mysql/bin' >> ~/.bash_profile
    source ~/.bash_profile
    
    #初始化数据库,使用空密码
    mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/var/lib/mysql
    systemctl --now enable mysqld

字数差不多了， 明天再来演示下多实例的配置吧  
9de7bb31d0644e7393039222babfed10

谢谢