1. 首先下载 MySQL 的源码包
wget
2. 安装需要的编译工具
yum install cmake make ncurses-devel ncurses gcc gcc-c++ -y
3. 解压源码包
- tar -zxvf MySQL-5.5.20.tar.gz
- cd MySQL-5.5.20
4. 开始编译安装
- cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql56/
- -DMYSQL_UNIX_ADDR=/tmp/MySQL.sock
- -DMYSQL_DATADIR=/data/MySQL/
- -DSYSCONFDIR=/etc
- -DMYSQL_USER=MySQL
- -DMYSQL_TCP_PORT=3306
- -DWITH_XTRADB_STORAGE_ENGINE=1
- -DWITH_INNOBASE_STORAGE_ENGINE=1
- -DWITH_PARTITION_STORAGE_ENGINE=1
- -DWITH_BLACKHOLE_STORAGE_ENGINE=1
- -DWITH_MYISAM_STORAGE_ENGINE=1
- -DWITH_READLINE=1
- -DENABLED_LOCAL_INFILE=1
- -DWITH_EXTRA_CHARSETS=1
- -DDEFAULT_CHARSET=utf8
- -DDEFAULT_COLLATION=utf8_general_ci
- -DEXTRA_CHARSETS=all
- -DWITH_BIG_TABLES=1
- -DWITH_DEBUG=0`
- make
- make install
5. 设置开机启动和配置文件
- cd /usr/local/mysql56/
- cp support-files/my-large.cnf/ etc/my.cnf
- cp support-files/MySQL.server /etc/init.d/mysqld
- chkconfig -add mysqld
- chkconfig -level 35 mysqld on
- mkdir -p /data/MySQL
- useradd MySQL
6. 初始化
- /etc/init.d/mysqld/usr/local/mysql56/scripts/mysql_install_db -user=MySQL -datadir=/data/MySQL/ -basedir=/usr/local/mysql56/
- ln -s /usr/local/mysql55/bin/*/usr/bin/
ok, 到此 MySQL 就编译安装完成, 可用命令 ps -ef |grep MySQL 查看 MySQL 是否启动.
来源: http://www.bubuko.com/infodetail-2778551.html