Building MySQL 5.6 from source on Ubuntu 18.04

This explains the steps I used to build MySQL 5.6.35 from source on Ubuntu 18.04. I build with the perf schema disabled and if you do that then don't use Connector/J 5.1.48 (5.1.47 is OK) or you won't be able to connect thanks to bug 98919. The new Connector/J dependency on perf schema variables can be a problem for a DBMS that implements the MySQL API -- see this bug report for MemSQL.

1. Install an older version of gcc and g++: sudo apt install gcc-5 g++-5
2. Unpack source. I used 5.6.35
3. Remove the connection_control plugin because that does not compile when the perf schema is disabled at compile time -> rm -rf $SRC_ROOT/plugin/connection_control
4. Run cmake. See below. Note that I disable the perf schema.

My Cmake script:

prefix=$1

CC=gcc-5 CXX=g++-5 \

cmake .. \

      -DBUILD_CONFIG=mysql_release \

      -DCMAKE_BUILD_TYPE=RelWithDebInfo \

      -DCMAKE_INSTALL_PREFIX:PATH=$prefix \

      -DWITH_SSL="bundled" \

      -DWITH_ZLIB="bundled" \

      -DMYSQL_DATADIR="${prefix}/data" \

      -DMYSQL_UNIX_ADDR="${prefix}/var/mysql.sock" \

      -DENABLED_LOCAL_INFILE=1 \

      -DMYSQL_MAINTAINER_MODE=0 \

      -DWITH_PERFSCHEMA_STORAGE_ENGINE=0 > o.cm 2> e.cm