mysql编译安装

mysql版本：5.6.38.tar.gz  （generic版）

提示：编译安装之前先创建mysql用户和组（此步骤略过）

1. 安装依赖包
yum install libaio-devel ncurses-devel cmake gcc gcc-c++ bison -y 

2. 用cmake编译
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/data/mysql \
 -DMYSQL_DATADIR=/usr/local/data/mysql/data \
 -DSYSCONFDIR=/usr/local/data/mysql \
 -DWITH_INNOBASE_STORAGE_ENGINE=1 \
 -DWITH_PARTITION_STORAGE_ENGINE=1 \
 -DWITH_FEDERATED_STORAGE_ENGINE=1 \
 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
 -DWITH_MYISAM_STORAGE_ENGINE=1 \
 -DENABLED_LOCAL_INFILE=1 \
 -DENABLE_DTRACE=0 \
 -DDEFAULT_CHARSET=utf8mb4 \
 -DDEFAULT_COLLATION=utf8mb4_general_ci \
 -DWITH_EMBEDDED_SERVER=1

3. 编译完成后开始安装
make
make install

4. 修改mysql目录权限
chown -R mysql.mysql /usr/local/data/mysql

5. 数据库初始化
cd /usr/local/data/mysql
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mnt/mysqldata --
pid-file=/usr/local/mysql/mysql.pid --tmpdir=/tmp 

6. 拷贝并修改配置文件
cp support-files/my-default.cnf  /etc/my.cnf
vim /etc/my.cnf

     [mysqld] 添加：

      log_bin=/var/mysql/bin_log     //binlog日志存放路径

      log-error=/usr/local/mysql/error.log
      basedir=/usr/local/mysql
     datadir=/mnt/mysqldata
     socket=/tmp/mysql.sock
     pid-file=/usr/local/mysql/mysql.pid
     user=mysql
     tmpdir=/tmp

7. 设置环境变量
vim /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/data/mysql/bin:/usr/local/data/mysql/lib
[root@localhost ~]#source /root/.bash_profile //使刚才的修改生效

8. 制作成服务启动
  cp support-files/mysql.server /etc/init.d/mysql
  相关命令：
  service mysql start    
  service mysql stop    
  service mysql restart 
9设置开机启动mysql服务（略过）