centos6.9编译安装mysql-5.6.36

前端之家收集整理的这篇文章主要介绍了centos6.9编译安装mysql-5.6.36前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  • 一 安装相关软件包
    [[email protected] ~]# yum -y install ncureses-devel libaio-devel
    [[email protected] tools]# yum install cmake –y
  • 创建MysqL运行用户
    [[email protected] tools]# useradd -s /sbin/nologin -M MysqL
  • 下载软件包
    [[email protected] tools]# wget https://downloads.mysql.com/archives/get/file/mysql-5.6.36.tar.gz
  • 解压软件
    [[email protected] tools]# tar -xf MysqL-5.6.36.tar.gz

  • 配置MysqL
    cmake . -DCMAKE_INSTALL_PREFIX=/application/MysqL-5.6.36 \
    -DMysqL_DATADIR=/application/MysqL-5.6.36/data \
    -DMysqL_UNIX_ADDR=/application/MysqL-5.6.36/tmp/MysqL.sock \
    -DDEFAULT_CHARSET=utf8 \
    -DDEFAULT_COLLATION=utf8_general_ci \
    -DWITH_EXTRA_CHARSETS=all \
    -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    -DWITH_FEDERATED_STORAGE_ENGINE=1 \
    -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
    -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
    -DWITH_ZLIB=bundled \
    -DWITH_SSL=bundled \
    -DENABLED_LOCAL_INFILE=1 \
    -DWITH_EMBEDDED_SERVER=1 \
    -DENABLE_DOWNLOADS=1 \
    -DWITH_DEBUG=0

  • 创建软连接
    ln -s /application/MysqL-5.6.36/ /application/MysqL
  • 拷贝配置文件到etc
  • cp support-files/my*.cnf /etc/my.cnf

    8 . 初始化数据库
    /application/MysqL/scripts/MysqL_install_db --basedir=/application/MysqL/ --datadir=/application/MysqL/data --user=MysqL

    9.创建关键目录并授权mkdir /application/MysqL/tmp/chown -R MysqL.MysqL /application/MysqL/10 . 拷贝启动脚本cp support-files/MysqL.server/etc/init.d/MysqLdchmod700 /etc/init.d/MysqLd11 . 设置开机自启chkconfig MysqLd onchkconfig--list MysqLd12 .启动数据库/etc/init.d/MysqLd startnetstat -lntup|grep 330613 .设置环境变量echo ‘PATH=/application/MysqL/bin/:$PATH‘ >>/etc/profilesource /etc/profileecho $PATH

    猜你在找的CentOS相关文章