源码编译安装mysql

1.    安装mysql-5.0.75

groupadd mysql

useradd -g mysql mysql

tar xzvf mysql-5.0.75.tar.gz

cd mysql-5.0.75

 

./configure --prefix=/usr \

--without-docs \

--without-man \

--enable-assembler \

--with-charset=utf8 \

--with-extra-charsets=all \

--enable-thread-safe-client \

--localstatedir=/data/mysqldata \

--with-mysqld-user=mysql \

--with-big-tables \

--with-unix-socket-path=/data/tmp/mysql.sock \

--sysconfdir=/data/mysqldata

 

make

make install

 

scripts/mysql_install_db

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

chmod +x /etc/init.d/mysqld

cp support-files/my-huge.cnf /data/mysqldata/

cd /data/

chown -R mysql.mysql mysqldata/

mkdir tmp binlog ibdata

chown -R mysql.mysql tmp binlog ibdata

cd mysqldata

grep -v "#" my-huge.cnf > my.cnf

vi my.cnf