源码安装MySQL

安装环境： RedHat6.3

1. 删除旧版本，下载源码
   我安装的版本是5.6.26， 还需要cmake， 可搜索下载，也可到百度网盘下载：
   http://pan.baidu.com/s/1o6th6XG

2. 安装cmake
   ./bootstrap
   make
   make install

3. 创建用户和用户组
   groupadd mysql
   useradd -g mysql mysql
   passwd mysql

4. 我为后面在一台机器上安装多个MySQL，安装路径、数据路径、端口、配置文件的路径不用默认的。
   mkdir /usr/local/mysql3307/
   mkdir /opt/mysqldata3307/
   mkdir /etc/mysql3307
   chown -R mysql:mysql /usr/local/mysql3307
   chown -R mysql:mysql /opt/mysqldata3307
   chown -R mysql:mysql /etc/mysql3307

5. 编译安装
   cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql3307 -DMYSQL_DATADIR=/opt/mysqldata3307 \
   -DMYSQL_TCP_PORT=3307 -DMYSQL_USER=mysql -DSYSCONFDIR=/etc/mysql3307 \
   -DEFAULT_CHARSET=utf8 -DEFAULT_COLLATION=utf8_general_ci \
   -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=ON
   make
   make install

   查看选项
   cmake . -LAH # all params with help text
   ccmake . # interactive display

   出错需要重新编译时需执行
   make clean
   rm -f CMakeCache.txt

6. 配置数据库
   cp /usr/local/mysql3307/support-files/my-default.cnf /etc/mysql3307/my.cnf
   [mysqld]
   basedir = /usr/local/mysql3307
   datadir = /opt/mysqldata3307
   log-error = /opt/mysqldata3307/error.log
   port = 3307
   socket=/opt/mysqldata3307/mysql.sock

   [mysqld_safe]
   pid-file=/opt/mysqldata3307/mysqld.pid

7. 安装数据库
   /usr/local/mysql3307/scripts/mysql_install_db –basedir=/usr/local/mysql3307 –datadir=/opt/mysqldata3307 –user=mysql

8. 启动数据库
   /usr/local/mysql3307/bin/mysqld_safe –defaults-file=/etc/mysql3307/my.cnf –user=mysql &

   修改环境变量
   cd ~
   vi .bash_profile
   PATH=$PATH:$HOME/bin:/usr/local/mysql3307/bin:/usr/local/mysql3307/lib:.
   source .bash_profile

   修改数据库root用户的密码
   mysqladmin -uroot password 123456 –socket=/opt/mysqldata3307/mysql.sock

   开机启动
   vi /etc/rc.d/rc.local
   /usr/local/mysql3307/bin/mysqld_safe –defaults-file=/etc/mysql3307/my.cnf –user=mysql &