MySQL compilation installation

CMake \
-dcmake_install_prefix=/data/mysql \ #The Installation base directory.
-dmysql_datadir=/data/mysql/data \ #The Location of the MySQL Data directory.
-dsysconfdir=/data/mysql \ #The Default my.cnf option file directory.
-dwith_myisam_storage_engine=1 \ #支持MyIASM引擎
-dwith_innobase_storage_engine=1 \ #支持InnoDB引擎
-dwith_memory_storage_engine=1 \ #支持Memory引擎
-dwith_readline=1 \ #快捷键功能 (I didn't use it)
-dmysql_unix_addr=/data/mysql/mysql.sock \ #连接数据库socket路径
-dmysql_tcp_port=3306 \
-denabled_local_infile=1 \ #允许从本地导入数据
-dwith_partition_storage_engine=1 \ #安装支持数据库分区
-dextra_charsets=all \ #安装所有的字符集
-ddefault_charset=utf8 \
-ddefault_collation=utf8_general_ci

Make && make install

MySQL Compilation installation