庆祝CentOS6.1发布，发一个源码安装mysql的教程

家园

以下命令请用root执行，刚刚测试完毕，可在centos6.1下顺利安装。（Centos最小桌面安装+开发工具）

2. yum install -y ncurses-devel bison
3. wget  http://mysql.he.net/Downloads/MySQL-5.5/mysql-5.5.19.tar.gz
4. wget http://www.cmake.org/files/v2.8/cmake-2.8.6.tar.gz
6. groupadd mysql
7. useradd mysql -g mysql -M -s /sbin/nologin
8. mkdir -p /usr/local/mysql/data
9. mkdir -p /usr/local/mysql/log
10. chmod +w /usr/local/mysql
11. tar zxvf cmake-2.8.6.tar.gz
12. tar zxvf mysql-5.5.19.tar.gz
13. cd cmake-2.8.6
14. ./bootstrap
15. gmake
16. gmake install
18. cd ../mysql-5.5.19
19. cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_USER=mysql -DWITH_DEBUG=0
20. make
21. make install
23. cp support-files/mysql.server /etc/init.d/mysqld
24. chmod +x /etc/init.d/mysqld
25. chown -R mysql:mysql /usr/local/mysql
26. ln -s /usr/local/mysql/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16
27. ln -s /usr/local/mysql/bin/mysql /sbin/mysql
28. ln -s /usr/local/mysql/bin/mysqladmin /sbin/mysqladmin
29. ln -s /usr/local/mysql/bin/mysqldump /sbin/mysqldump
30. cp support-files/my-huge.cnf /etc/my.cnf -f
32. /usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
33. chkconfig --add mysqld
34. chkconfig --level 2345 mysqld on
35. service mysqld start
36. mysqladmin -u root password "yourpasswd"
37. mysql -u root -p

复制代码