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[刚才你设置的密码]