mysql 5.5.20_Mysql源码安装---mysql-5.5.20

一、下载源码包，百度云盘：https://pan.baidu.com/s/1vEgAHCxNX5ctZi4VRhXBnA

二、将源码包放到/usr/src目录

三、解压源码包：tar -xzvf mysql-5.5.20.tar.gz

四、进入解压后的目录：cd mysql-5.5.20

五、安装如下包：yum  install  cmake  ncurses-devel ncurses  gcc-c++ –y

六、预编译：

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql55/-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

mysql参数解释：

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql55 Cmake预编译；-DMYSQL_UNIX_ADDR=/tmp/mysql.sock MYSQL Socket通信文件位置；-DMYSQL_DATADIR=/data/mysql MYSQL数据存放路径；-DSYSCONFDIR=/etc 配置文件路径；-DMYSQL_USER=mysql MYSQL运行用户；-DMYSQL_TCP_PORT=3306MYSQL监听端口；-DWITH_XTRADB_STORAGE_ENGINE=1开启xtradb引擎支持；-DWITH_INNOBASE_STORAGE_ENGINE=1开启innodb引擎支持；-DWITH_PARTITION_STORAGE_ENGINE=1开启partition引擎支持；-DWITH_BLACKHOLE_STORAGE_ENGINE=1开启blackhole引擎支持；-DWITH_MYISAM_STORAGE_ENGINE=1开启MyISAM引擎支持；-DWITH_READLINE=1启用快捷键功能；-DENABLED_LOCAL_INFILE=1允许从本地导入数据；-DWITH_EXTRA_CHARSETS=1支持额外的字符集；-DDEFAULT_CHARSET=utf8 默认字符集UTF-8；-DDEFAULT_COLLATION=utf8_general_ci 检验字符；-DEXTRA_CHARSETS=all 安装所有扩展字符集；-DWITH_BIG_TABLES=1将临时表存储在磁盘上；-DWITH_DEBUG=0禁止调试模式支持；

make 编译；

make install 安装。

七、make -j4 && make -j4 install

八、安装完成后，执行如下内容：

cd /usr/local/mysql55/

\cp support-files/my-large.cnf /etc/my.cnf

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

chkconfig --add mysqld

chkconfig --level 345 mysqld on

mkdir -p

/data/mysql

useradd -M -s /sbin/nologin mysql

/usr/local/mysql55/scripts/mysql_install_db --user=mysql

--datadir=/data/mysql/ --basedir=/usr/local/mysql55/　　#安装初始化

ln  -s  /usr/local/mysql55/bin/* /usr/bin/　　#添加到环境变量

service

mysqld  restart