mysql5.1编译安装centos7_02： mysql 5.7 编译安装 （centos7）

一.MySQL5.6与MySQL5.7安装的区别

1、cmake的时候加入了bostorg

2、初始化时 使用mysqld --initialize 替代mysql_install_db，其它参数没有变化：--user= --basedir= --datadir=

3、--initialize会生成一个临时密码

4、还可以用另外一个参数--initialize-insecure

--------------------------------------------------------------------------------------------------------------------------------------------------

安装步骤和5.6几乎一致，这里不在详细记录，只给出必要的步骤！

-------------------------------------------------------------------------------------------------------------------------------------------------

#依赖

yum install -y gcc gcc-c++ automake autoconf

yum -y install make cmake bison-devel ncurses-devel libaio-devel

wget https://dl.bintray.com/boostorg/release/1.65.1/source/boost_1_65_1.tar.gz

tar xf boost_1_65_1.tar.gz -C /usr/local/

#预编译

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.7.17 \

-DMYSQL_DATADIR=/application/mysql-5.7.17/data \

-DMYSQL_UNIX_ADDR=/application/mysql-5.7.17/tmp/mysql.sock \

-DDOWNLOAD_BOOST=1 \

-DWITH_BOOST=/usr/local/boost_1_65_1/boost \

-DSYSCONFDIR=/etc \

-DDEFAULT_CHARSET=utf8mb4 \

-DDEFAULT_COLLATION=utf8mb4_general_ci \

-DWITH_EXTRA_CHARSETS=all \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_ZLIB=bundled \

-DWITH_SSL=bundled \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_EMBEDDED_SERVER=1 \

-DENABLE_DOWNLOADS=1 \

-DWITH_DEBUG=0

#编译 && 安装

内存必须 > 2GB

make && make install

#授权

chown -R mysql.mysql /application/mysql-5.7.17

#初始化

/application/mysql-5.7.17/bin/mysqld --initialize --user=mysql --basedir=/application/mysql-5.7.17 --datadir=/application/mysql-5.7.17/data

记录初始密码(一定要记录!!!)

#拷贝配置文件和启动文件

cp /application/mysql-5.7.17/support-files/my-default.cnf /etc/my.cnf

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

#启动

/etc/init.d/mysqld start