源码编译安装MYSQL方法

1、由于姗隗肆念采用的是最小化安装，所有先需要安装一些基础软件组件yum -y install gcc gcc-c++ autoconf cmake lib枣娣空郅jpeg 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/mysqlchown -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/mysqlcp./support-files/mysql.server/etc/init.d/mysqldcp./support-files/my-medium.cnf/etc/my.cnfchmod+x/etc/init.d/mysqldchown -R mysql:mysql /usr/local/mysql