Mysql源码编译安装
1.mysql-5.6.10.tar.gz特别大 ，虚拟机内存较少时会导致快照崩掉、所以用mysql-5.5.12.tar.gz
2.cmake比configure编译过程更详细
3.每次运行完都会产生一个缓存文件，再次编译时需删除缓存
mysql的官方网站：www.mysql.com
4.postfix默认支持mysql-libs，若卸载掉mysql-libs，postfix起不来
[root@server79 mysql-5.5.12]# ldd /usr/sbin/postfix //缺一不可
linux-vdso.so.1 => (0x00007fff62bff000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00007fb47245a000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007fb47224b000)
libpcre.so.0 => /lib64/libpcre.so.0 (0x00007fb47201e000)
libmysqlclient.so.16 => /usr/lib64/mysql/libmysqlclient.so.16 (0x00007fb471c9c000)
libm.so.6 => /lib64/libm.so.6 (0x00007fb471a18000)
libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x00007fb4717fd000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007fb4715a2000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007fb471208000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fb471003000)
libz.so.1 => /lib64/libz.so.1 (0x00007fb470ded000)
libdb-4.7.so => /lib64/libdb-4.7.so (0x00007fb470a79000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fb47085f000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fb470645000)
libc.so.6 => /lib64/libc.so.6 (0x00007fb4702b3000)
libssl3.so => /usr/lib64/libssl3.so (0x00007fb470076000)
libsmime3.so => /usr/lib64/libsmime3.so (0x00007fb46fe4a000)
libnss3.so => /usr/lib64/libnss3.so (0x00007fb46fb0f000)
libnssutil3.so => /usr/lib64/libnssutil3.so (0x00007fb46f8e8000)
libplds4.so => /lib64/libplds4.so (0x00007fb46f6e4000)
libplc4.so => /lib64/libplc4.so (0x00007fb46f4df000)
libnspr4.so => /lib64/libnspr4.so (0x00007fb46f2a1000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fb46f06a000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fb46ee27000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fb46eb48000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fb46e944000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fb46e717000)
/lib64/ld-linux-x86-64.so.2 (0x00007fb4728c7000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb46e4fa000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007fb46e297000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fb46e08c000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fb46de89000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fb46dc69000)
下载源码包:
可从官方网站下载
lftp 192.168.0.251:/pub/docs/lamp/update/lnmp> get mysql-5.5.12.tar.gz
[root@server79 ~]# tar zxf mysql-5.5.12.tar.gz
安装编译工具
[root@server79 mysql-5.5.12]# yum install cmake -y
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
#安装目录
-DMYSQL_DATADIR=/usr/local/mysql/data \
#数据库存放目录
-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock \ #Unix socket 文件路径
-DWITH_MYISAM_STORAGE_ENGINE=1 \
#安装 myisam 存储引擎
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
#安装 innodb 存储引擎
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
#安装 archive 存储引擎
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
#安装 blackhole 存储引擎
-DWITH_PARTITION_STORAGE_ENGINE=1 \
#安装数据库分区
-DENABLED_LOCAL_INFILE=1 \
#允许从本地导入数据
-DWITH_READLINE=1 \
#快捷键功能
-DWITH_SSL=yes \
#支持 SSL
-DDEFAULT_CHARSET=utf8 \
#使用 utf8 字符
-DDEFAULT_COLLATION=utf8_general_ci \
#校验字符
-DEXTRA_CHARSETS=all \
#安装所有扩展字符集
-DMYSQL_TCP_PORT=3306 \
编译：
[root@server79 mysql-5.5.12]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all
问题1：
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
解决：
[root@server79 mysql-5.5.12]# yum install ncurses-devel -y
[root@server79 mysql-5.5.12]# rm -fr CMakeCache.txt
问题2：
CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguage
CMake Error: Internal CMake error, TryCompile configure of cmake failed
-- Performing Test HAVE_PEERCRED - Failed
Warning: Bison executable not found in PATH
-- Configuring incomplete, errors occurred!
解决：
[root@server79 mysql-5.5.12]# yum install gcc-c++ -y
错误3：Warning: Bison executable not found in PATH
解决：
[root@server79 mysql-5.5.12]# yum install bison -y
[root@server79 mysql-5.5.12]# rm -fr CMakeCache.txt
[root@server79 mysql-5.5.12]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/lnmp/mysql -DMYSQL_DATADIR=/usr/local/lnmp/mysql/data -DMYSQL_UNIX_ADDR=/usr/local/lnmp/mysql/data/mysql.sock -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all
[root@server79 mysql-5.5.12]# make && make install