当前位置:Gxlcms > 数据库问题 > 二进制包安装MySQL5.7.29

二进制包安装MySQL5.7.29

时间:2021-07-01 10:21:17 帮助过:5人阅读

还是5.7.29,还是CentOS 7

二进制包安装MySQL

一、下载

  1. 安装依赖包

    yum install ncurses-devel.x86_64 libaio.x86_64 -y
    
  2. 下载MySQL二进制包

    方法一:使用wget命令直接下载

    wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.29-el7-x86_64.tar.gz
    

    方法二:到官网下载,然后上传到Linux

    https://downloads.mysql.com/archives/community/

    选择对应的版本

    技术图片

    技术图片

  3. 解压缩

    # 解压缩
    tar -zxf mysql-5.7.29-el7-x86_64.tar.gz
    
    # 移动到/usr/local下
    mv mysql-5.7.29-el7-x86_64 /usr/local/mysql
    

二、修改配置文件并初始化

  1. 前提工作

    # 创建mysql用户
    useradd -r -s /sbin/nologin mysql
    
    # 建立工作目录
    mkdir -p /data/mysql/{data,log}
    
    # 授权目录
    chown -R mysql.mysql /data/mysql
    chown -R mysql.mysql /usr/local/mysql
    
  2. 编辑配置文件

    cat > /etc/my.cnf << EOF
    [client]
    default-character-set = utf8mb4
    port = 3306
    socket = /data/mysql/mysql.sock
    
    [mysqld]
    server_id = 1
    character-set-server = utf8
    user = mysql
    port = 3306
    socket = /data/mysql/mysql.sock
    basedir = /usr/local/mysql
    datadir = /data/mysql/data
    log-error = /data/mysql/log/mysql_error.log
    log-bin = /data/mysql/log/mysql-bin
    binlog_format = ROW
    pid-file = /data/mysql/mysql.pid
    open_files_limit = 8192
    innodb_buffer_pool_size = 512M
    
    [mysql]
    auto-rehash
    prompt = ‘\u@\h [\d]> ‘
    EOF
    
  3. 初始化

    /usr/local/mysql/bin/mysqld --initialize  --user=mysql --basedir=/usr/local/mysql/  --datadir=/data/mysql/data/
    

三、启动MySQL

  1. 添加环境变量

    echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
    source /etc/profile
    
  2. 启动

    cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
    service mysql start
    chkconfig --add mysql
    
  3. 获取默认密码登录

    # 获取默认密码
    temp_passwd=`cat /data/mysql/log/mysql_error.log | grep "temporary password" | awk ‘{print $NF}‘`
    
    # 使用默认密码登录
    mysql -uroot -p$temp_passwd
    
    # 修改密码
    root@localhost [(none)]> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘NewPassword2233$‘;
    

二进制包安装mysql完成!

二进制包安装MySQL5.7.29

标签:ncurses   log   sock   arch   def   eof   ali   roo   localhost   

人气教程排行