mysql编译安装

mysql 编译安装

1. 安装包及其他下载：
   地址 https://downloads.mysql.com/archives/community/

cd /usr/local/src
wget --no-check-certificate  https://downloads.mysql.com/archives/get/file/mysql-5.7.27.tar.gz
//boost下载
wget --no-check-certificate http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz
yum -y install ncurses-devel bison gcc gcc-c++

2. 解压

cd /usr/local/src
tar zxvf mysql-5.7.27.tar.gz
tar zxvf boost_1_59_0.tar.gz

3. 创建用户及mysql安装目录

useradd -s /sbin/nologin -M mysql
id mysql
uid=501(mysql) gid=501(mysql) groups=501(mysql)
//创建mysql目录
mkdir /usr/local/mysql
//创建data目录
mkdir /usr/local/mysql/data
chown -R mysql:mysql /usr/local/mysql

4. 编译安装

cmake . -CMAKE_INSTALL_PREFIX=/usr/local/mysql/ \
> -DMYSQL_USER=mysql \
> -DEFAULT_CHARSET=utf8 \
> -DEFAULT_COLLATION=utf_general_ci\
> -DOWNLOAD_BOOST=on \
> -DWITH_BOOST=boost \
> -DWITH_DEBUG=on \
> -DWITH_SSL=system \
> -DMYSQL_DATADIR=/usr/local/mysql/data