源码编译MySQL方法

1、安装基础软件

yum install gcc gcc-c++ zlib-devel libtool ncurses-devel libxml2-devel

2、生成mysql用户及用户组

groupadd mysql

useradd -g mysql mysql

3、./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-readline --with-big-tables --with-plugins=all --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static

4、make &&  make install

5、这个过程是一个漫长的过程，注意是否有报错

6、准备配置文件

[root@localhost mysql-5.1.47]# cp /usr/local/mysql/share/mysql/my-huge.cnf /etc/my.cnf

cp: overwrite `/etc/my.cnf'? y

[root@localhost mysql-5.1.47]# cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld

[root@localhost mysql-5.1.47]# chmod +x /etc/init.d/mysqld 

[root@localhost mysql-5.1.47]# chown -R mysql:mysql /usr/local/mysql/

[root@localhost mysql-5.1.47]# mkdir -p /data/mysql

7、修改配置文件/etc/my.cnf中的datadir

8、初始化

/usr/local/mysql/bin/mysql_install_db --user=mysql --datadir=/data/mysql

9、启动mysql

service mysqld start