mysql source compiling

readme.md

• Download mysql source

• Ran the following cmake command based on the documentation

cmake \
  -DCMAKE_INSTALL_PREFIX=/usr/local/mac-dev-env/mysql-5.7.18 \
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=ON \
  -DWITH_BOOST=/usr/local/src/boost \
  ..

cmake \
  -DCMAKE_INSTALL_PREFIX=./mysql-5.7.18 \
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=1 \
  ..

• gives the following error

CMake Error at cmake/boost.cmake:81 (MESSAGE):
You can download it with -DDOWNLOAD_BOOST=1 -DWITH_BOOST=<directory>

• following https://geeksww.com/tutorials/operating_systems/linux/installation/installing_mysql_client_tools_binaries_and_library_on_ubuntu_linux.php

./configure.cmake --without-server --enable-thread-safe-client \
    --with-client-ldflags=-all-static --prefix=./mybuild \
    --without-debug  --without-docs --with-big-tables

• this didn't work

Building boost

• http://www.boost.org/doc/libs/1_65_0/more/getting_started/unix-variants.html#prepare-to-use-a-boost-library-binary

download boost and untar

mkdir mybuild
./bootstrap.sh --prefix=mybuild/
./b2

• building taking time

• create folder mybuild inside mysql source folder so that cmake files are in that folder and it's easy to delete the tmp files. Also put the entire src in git to see if the original src folder gets new files.

cmake \
  -DCMAKE_INSTALL_PREFIX= ./mysql-5.7.18\
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=ON \
  -DWITH_BOOST=../../boost_1_65_0.tar.gz \
  ..

• gives error -- MySQL currently requires boost_1_59_0

cmake \
  -DCMAKE_INSTALL_PREFIX= ./mysql-5.7.18\
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=ON \
  -DWITH_BOOST=../../ \
  ..

• this tried to download boost but later got timeout error

• downloaded boost package wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

cmake \
  -DCMAKE_INSTALL_PREFIX= ./mysql-5.7.18\
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=ON \
  -DWITH_BOOST=../../ \
  ..

• the cmake is running ok

• make to build the exe

• got this error /Users/anjesh/Dev/source/mysql-5.7.19/mysys/charset.c:403:22: error: use of undeclared identifier 'DEFAULT_CHARSET_HOME'

• Found the bug reported here https://bugs.mysql.com/bug.php?id=78214

• not sure how to fix

• looks like this error might be due to space after PREFIX= , something that's mentioned in above command

cmake \
  -DCMAKE_INSTALL_PREFIX=./mysql-5.7.18 \
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=ON \
  -DWITH_BOOST=../../ \
  ..

make

• still cann't compile Mysql-python becauase of some .h file folder issues.

• again runnnig cmake and make with some change in the prefix

cmake \
  -DCMAKE_INSTALL_PREFIX=./ \
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \
  -DDOWNLOAD_BOOST=ON \
  -DWITH_BOOST=../../ \
  ..

make

make install without sudo and the necessary files are installed in the same folder

Now i was able to install MySQL-Python after configuring mysql_config, i put mysql_config in ~/bin and the installation worked.