源码安装mysql5.7[0]

Posted on by

mysql的源码分为两种，一种是含有boost的，一种不带boost。mysql的编译采用cmake，因此需要安装cmake编译器

  • 创建用户组
groupadd mysql
useradd -M -s /sbin/nologin mysql
  • 创建文件夹
mkdir /usr/local/mysql
mkdir /usr/local/mysql/mydata
mkdir /usr/local/mysql/conf
useradd mysql
chown -R mysql:mysql /usr/local/mysql/
  • 下载mysql源码
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.20.tar.gz
tar -xf mysql-boost-5.7.20.tar.gz
cd mysql-5.7.20
  • 安装依赖
yum install -y cmake gcc gcc-c++ ncurses ncurses-devel perl-Data-Dumper boost boost-doc boost-devel bison bison-devel
  • 配置cmake
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/mydata \
-DSYSCONFDIR=/usr/local/mysql/conf \
-DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_DEBUG=0 \
-DMYSQL_MAINTAINER_MODE=0 \
-DWITH_SSL=bundled \
-DWITH_ZLIB=bundled \
-DWITH_SYSTEMD=1 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/root/mysql-5.7.20/boost
  • 开始编译安装
make && make install

安装完无报错

  • 初始化数据库
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/mydata

运行后显示

 

参考资料：

  1. https://blog.csdn.net/aizhen_forever/article/details/78509113