编译mysql5.5备忘

拿到源码后

sudo apt-get install cmake

sudo apt-get install libncurses5-dev

sudo cmake . -DCMAKE_INSTALL_PREFIX=/opt/apps/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_bin -DEXTRA_CHARTSET=all -DMYSQL_DATADIR=/opt/data/mysql -DSYSCONFDIR=/etc/mysql

sudo make && make install

groupadd mysql

useradd -r -g mysql mysql

cd /opt/apps/mysql

chown -R mysql .

chgrp -R mysql .

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

chmod 644 /etc/mysql/my.cnf

chmod 777 /opt/data/mysql

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

chmod +x /etc/init.d/mysqld

chkconfig -add mysqld

chkconfig mysqld on 

scripts/mysql_install_db --user=mysql

/etc/init.d/mysqld start

参考http://ideas.spkcn.com/technology/database/259.html