centos 5.5 下编译安装 mysql

安装编译工具

1 2	yum install gcc gcc-c++ yum install ncurses-devel

下载源码

1 2 3 4 5

mkdir -p /tmp cd /tmp wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.15.tar.gz/from/http://mysql.he.net/ wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz

由于5.5.20之后需要使用cmake对其进行configure，所以需要安装以下两个开发组件

安装cmake和bison

1 2 3 4 5 6 7 8 9 10 11 12 13

cd /tmp tar zxvf cmake-2.8.4.tar.gz cd cmake-2.8.4 ./bootstrap make make install          cd /tmp tar zxvf bison-2.5.tar.gz cd bison-2.5 ./configure make make install

创建MySQL用户和组

1 2	/usr/sbin/groupadd mysql /usr/sbin/useradd -g mysql mysql

编译安装MySQL

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

cd /tmp tar xvf mysql-5.5.15.tar.gz cd mysql-5.5.15/ cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_EXTRA_CHARSETS=all \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DMYSQL_DATADIR=/var/mysql/data \ -DMYSQL_USER=mysql make && make install

一些相关设置

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

chmod +w /usr/local/mysql chown -R mysql:mysql /usr/local/mysql ln -s /usr/local/mysql/lib/libmysqlclient.so.16 /usr/lib/libmysqlclient.so.16 mkdir -p /var/mysql/ mkdir -p /var/mysql/data/ mkdir -p /var/mysql/log/ chown -R mysql:mysql /var/mysql/ cd support-files/ cp my-large.cnf /var/mysql/my.cnf cp mysql.server /etc/rc.d/init.d/mysqld           /usr/local/mysql/scripts/mysql_install_db \ --defaults-file=/var/mysql/my.cnf \ --basedir=/usr/local/mysql \ --datadir=/var/mysql/data \ --user=mysql          chmod +x /etc/init.d/mysqld          vi /etc/init.d/mysqld 和 /etc/mysql/my.ini（编辑此文件，查找并修改以下变量内容：） basedir=/usr/local/mysql datadir=/var/mysql/data

加入自动启动项

1 2	chkconfig --add mysqld chkconfig --level 345 mysqld on

启动服务

1	service mysqld start

设置管理员密码

1	/usr/local/mysql/bin/mysqladmin password [new-password]

登陆Mysql

1	/usr/local/mysql/bin/mysql -root -p[刚才你设置的密码]