源码编译安装MYSQL方法

1、由于采用的是最小化安装，所有先需要安装一些基础软件组件

yum -y install gcc gcc-c++ autoconf cmake libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers gd gd2 gd-devel gd2-devel perl-CPAN bison

2、创建组和用户

[root@localhost ~]# groupadd mysql

[root@localhost ~]# useradd -g mysql mysql

[root@localhost ~]# 

3、创建目录存放mysql数据

mkdir -p /data/mysql

chown -R mysql:mysql /data/mysql

4、rpm -ivh MySQL-5.5.25a-1.el6.src.rpm

5、解压源码包

6、cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql  -DMYSQL_DATADIR=/data/mysql/data  -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_unicode_ci  -DWITH_READLINE=1  -DWITH_SSL=system  -DWITH_EMBEDDED_SERVER=1  -DENABLED_LOCAL_INFILE=1  -DDEFAULT_COLLATION=utf8_general_ci  -DWITH_MYISAM_STORAGE_ENGINE=1  -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_DEBUG=0

7、make && make install

8、cd /usr/local/mysql

cp ./support-files/mysql.server /etc/init.d/mysqld

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

chmod +x /etc/init.d/mysqld

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