建立mysql用户和组


groupadd mysql


useradd mysql



安装cmake


yum -y install gcc*


yum -y install ncurses-devel*


wget -c http://www.cmake.org/files/v2.8/cmake-2.8.11.2.tar.gz


tar zxfv cmake-2.8.11.2.tar.gz


cd cmake-2.8.11.2


./bootstrap


./configure



安装mysql


wget -c http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.33.tar.gz


tar zxfv mysql-5.5.33.tar.gz


cd mysql-5.5.33


cmake -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DWITH_SSL=system -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -LH


CFLAGS="-O3" CXX=gcc
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"
cmake . -LH|more //CMake下查看MySQL的编译配置

cmake -DWITH_DEBUG=0 -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DENABLE_PROFILING=0 -DDEFAULT_CHARSET=latin1 -DEXTRA_CHARSETS=utf8,gbk  -DMYSQL_USER=mysql -DWITH_EMBEDDED_SERVER=0 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1


./configure --prefix=/usr/local/mysql \

--without-debug \

--enable-thread-safe-client \

--enable-profiling \

--with-mysqld-ldflags=all-static \

--with-client-ldflags=all-static \

--with-charset=latin1 \

--with-extra-charsets=utf8,gbk \

--with-mysqld-user=mysql \

--without-embedded-server \

--with-server-suffix=bbk \

--with-plugins=innobase,partition


make -j 8

make && make install


如果第一次编译失败或者有问题 清理mysql目录下的CMakeCache.txt重新编译即可


chmod +w /usr/local/mysql

chown -R mysql:mysql /usr/local/mysql

cd /root/mysql-5.5.32/support-files

cp my-medium.cnf /etc/my.cnf

mkdir /mnt/mysql/data -p

chown -R mysql.mysql /mnt/mysql/data


初始化数据库

/usr/local/mysql/scripts/mysql_install_db

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/mnt/mysql/data --user=mysql


export PATH=/usr/local/mysql/bin:$PATH

/mysqldata/mysql/bin/mysqld_multi --defaults-file=/etc/my.cnf start 3306

/mysqldata/mysql/bin/mysqld_multi --defaults-file=/etc/my.cnf start 3307

/mysqldata/mysql/bin/mysqld_multi --defaults-file=/etc/my.cnf start 3308