mysql-5.7.x环境搭建-适用所有linux,centos

墨色 9月前 ⋅ 634 阅读

mysql-5.7-x安装

  1. 检查是否已安装过mariadb,若有便删除(linux系统自带的)
    • rpm -qa | grep mariadb
    • rpm -e --nodeps xxxxx
  2. 检查是否已安装过mysql,若有便删除(linux系统自带的)
    • rpm -qa | grep mysql
    • rpm -e --nodeps xxxxx
  3. 检查mysql组和用户是否存在,如无创建
    • 检查
      • cat /etc/group | grep mysql
      • cat /etc/passwd |grep mysql
    • 创建
      • groupadd mysql
      • useradd -r -g mysql mysql
  4. 下载压缩包,解压,然后移动到appserver/mysql-5.7.24
    • 下载
      • wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
    • 解压
      • tar xzvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
    • 移动
      • mv mysql-5.7.24-linux-glibc2.12-x86_64 /appserver/mysql-5.7.24
  5. 在mysql下添加data目录
    • mkdir /appserver/mysql-5.7.24/data
  6. 更改mysql目录下所有的目录及文件夹所属组合用户
    • chown -R mysql:mysql /appserver/mysql-5.7.24/
    • chown -R mysql:mysql /appserver/mysql-5.7.24/data/
    • chmod -R mysql /appserver/mysql-5.7.24/
    • chmod -R mysql /appserver/mysql-5.7.24/data/
  7. 更改mysql安装文件夹mysql-5.7.24的权限
    • chmod -R 755 /appserver/mysql-5.7.24/
  8. 安装libaio依赖包
    • yum install libaio
  9. 初始化mysql,并基础控制台末尾输出的初始化密码
    • 初始化
      • /appserver/mysql-5.7.24/bin/mysqld --user=mysql --datadir=/appserver/mysql-5.7.24/data --basedir=/appserver/mysql-5.7.24 --initialize
    • 默认密码示例
      • A temporary password is generated for root@localhost: gFamcspKm2+u
  10. 修改mysql配置文件
    • vi /appserver/mysql-5.7.24/support-files/mysql.server
    • 修改前:
    if test -z "$basedir"
    then
    basedir=/usr/local/mysql
    bindir=/usr/local/mysql/bin
    if test -z "$datadir"
    then
    datadir=/usr/local/mysql/data
    fi
    sbindir=/usr/local/mysql/bin
    libexecdir=/usr/local/mysql/bin
    else
    bindir="$basedir/bin"
    if test -z "$datadir"
    then
    datadir="$basedir/data"
    fi
    sbindir="$basedir/sbin"
    libexecdir="$basedir/libexec"
    fi
    
    • 修改后
    if test -z "$basedir"
    then
    basedir=/appserver/mysql-5.7.24
    bindir=/appserver/mysql-5.7.24/bin
    if test -z "$datadir"
    then
        datadir=/appserver/mysql-5.7.24/data
    fi
    sbindir=/appserver/mysql-5.7.24/bin
    libexecdir=/appserver/mysql-5.7.24/bin
    else
    bindir="$basedir/bin"
    if test -z "$datadir"
    then
        datadir="$basedir/data"
    fi
    sbindir="$basedir/sbin"
    libexecdir="$basedir/libexec"
    fi
    
    • :wq 保存退出
  11. 修改my.cnf文件 vim /etc/my.cnf
    [client]
    no-beep
    socket =/appserver/mysql-5.7.24/mysql.sock
    # pipe
    # socket=0.0
    port=3306
    # sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    [mysql]
    # 支持emoji的utf8
    default-character-set=utf8mb4
    [mysqld]
    basedir=/appserver/mysql-5.7.24
    datadir=/appserver/mysql-5.7.24/data
    port=3306
    pid-file=/appserver/mysql-5.7.24/mysqld.pid
    # skip-grant-tables
    skip-name-resolve
    socket = /appserver/mysql-5.7.24/mysql.sock
    # 支持emoji的utf8
    character-set-server=utf8mb4
    default-storage-engine=INNODB
    explicit_defaults_for_timestamp = true
    # Server Id.
    server-id=1
    max_connections=2000
    query_cache_size=64M
    table_open_cache=2000
    tmp_table_size=64M
    thread_cache_size=300
    # 限定用于每个数据库线程的栈大小。默认设置足以满足大多数应用
    thread_stack = 192k
    key_buffer_size=32M
    read_buffer_size=4M
    read_rnd_buffer_size=0.25M
    innodb_data_home_dir = /appserver/mysql-5.7.24/data
    innodb_flush_log_at_trx_commit=0
    innodb_log_buffer_size=8M
    innodb_buffer_pool_size=512M
    innodb_log_file_size=128M
    innodb_thread_concurrency=128
    innodb_autoextend_increment=1000
    innodb_buffer_pool_instances=8
    innodb_concurrency_tickets=5000
    innodb_old_blocks_time=1000
    innodb_open_files=300
    innodb_stats_on_metadata=0
    innodb_file_per_table=1
    innodb_checksum_algorithm=0
    back_log=80
    flush_time=0
    join_buffer_size=128M
    max_allowed_packet=1024M
    max_connect_errors=2000
    open_files_limit=4161
    query_cache_type=0
    sort_buffer_size=32M
    table_definition_cache=1400
    binlog_row_event_max_size=8K
    sync_master_info=10000
    sync_relay_log=10000
    sync_relay_log_info=10000
    # 批量插入数据缓存大小,可以有效提高插入效率,默认为8M
    bulk_insert_buffer_size = 64M
    interactive_timeout = 120
    wait_timeout = 120
    log-bin-trust-function-creators=1
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    # include all files from the config directory
    !includedir /etc/my.cnf.d
    
    • :wq 保存退出
  12. etc下面创建一个加.的my.cnf.文件
    • mkdir /etc/my.cnf.
    • touch /etc/my.cnf.
    • mkdir /etc/my.cnf.d
  13. 做个软连接,启动服务
    • ln -s /appserver/mysql-5.7.24/support-files/mysql.server /etc/init.d/mysql
    • service mysql start
  14. 做个软链接,将安装目录下的mysql 放在/usr/bin 目录下,方便使用mysql命令
    • ln -s /appserver/mysql-5.7.24/bin/mysql /usr/bin
  15. 登录msyql,输入密码(密码为步骤9初始化生成的密码)
    • mysql -u root -p
    • [Enter password:] xxxx
  16. 修改密码并开放远程
    alter user 'root'@'localhost' identified by '此处密码自己设定';
    use mysql;
    update user set user.Host='%' where user.User='root';
    flush privileges;
    quit
    
  17. 设置开机自启动
    • 将服务文件拷贝到init.d下
      • cp /appserver/mysql-5.7.24/support-files/mysql.server /etc/init.d/mysqld
    • 赋予可执行权限
      • chmod +x /etc/init.d/mysqld
      • chmod +x /etc/init.d/mysql
    • 添加服务
      • chkconfig --add mysqld
    • 显示服务列表
      • chkconfig --list
  18. 如果报so库找不到错误,可执行如下命令
    vi ~/.bashrc
    # 在末尾加入一行
    export LD_LIBRARY_PATH=/appserver/mysql-5.7.24/lib:$LD_LIBRARY_PATH
    # 保存退出
    :wq
    # 刷新
    source ~/.bashrc
    

全部评论: 0

    我有话说: