编译安装 MySQL首先从 github 下载 mysql 源码
1
https://github.com/mysql/mysql-server
接下来编译安装
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
// 进到源码目录
cd /Users/d/c/mysql-server-5.7
// cmake
cmake \
-DCMAKE_INSTALL_PREFIX= /Users/d/c/mysql_build \
-DMYSQL_DATADIR= /Users/d/c/mysql_build/data \
-DSYSCONFDIR= /Users/d/c/mysql_build \
-DMYSQL_UNIX_ADDR= /Users/d/c/mysql_build/data/mysql.sock \
-DWITH_DEBUG= 1 \
-DDOWNLOAD_BOOST= 1 \
-DWITH_BOOST= /Users/d/c/boost \
-DWITH_SSL= /usr/local/opt/openssl@1.1
// install
make && make install
// 初始化数据库
cd /Users/d/c/mysql_build
bin/mysqld --basedir= /Users/d/c/mysql_build --datadir= /Users/d/c/mysql_build/data --initialize-insecure
-DDOWNLOAD_BOOST=1 -DWITH_BOOST=/Users/d/c/boost
这两个参数指定 boost 路径,之后会自动下载 boost。
-DWITH_SSL=/usr/local/opt/openssl@1.1
指定 openssl 路径,不指定有可能会报以下错误
1
2
3
4
5
6
7
8
9
Cannot find appropriate system libraries for WITH_SSL = system.
Make sure you have specified a supported SSL version.
Valid options are :
system ( use the OS openssl library) ,
yes ( synonym for system) ,
</path/to/custom/openssl/installation>
CMake Error at cmake/ssl.cmake:63 ( MESSAGE) :
Please install the appropriate openssl developer package.
配置CLion打开 mysql 源码目录,修改 cmake 配置
1
-DCMAKE_INSTALL_PREFIX= /Users/d/c/mysql_build -DMYSQL_DATADIR= /Users/d/c/mysql_build/data -DSYSCONFDIR= /Users/d/c/mysql_build -DMYSQL_UNIX_ADDR= /Users/d/c/mysql_build/data/mysql.sock -DWITH_DEBUG= 1 -DDOWNLOAD_BOOST= 1 -DWITH_BOOST= /Users/d/c/boost -DWITH_SSL= /usr/local/opt/openssl@1.1
之后选择 mysqld,然后点击 debug 按钮就可以开始调试了。