MySQL5.7.17 编译安装

1、下载wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17.tar.gztar xvf mysql-5.7.17.tar.g

1、下载

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17.tar.gztar xvf mysql-5.7.17.tar.gz -C /usr/local

2、安装依赖包、建立用户

yum -y install gcc gcc-c++ ncurses ncurses-devel cmakeuseradd -M -s /sbin/nologin mysql

3、编译安装,官方文档地址http://dev.mysql.com/doc/refman/5.7/en/source-installation.html

mkdir -pv /data/mysqlmkdir -pv /usr/local/boost_1_59_0cd /usr/local/mysql-5.7.17[root@leo mysql-5.7.17]# cmake . -LAH  #查看cmake选项cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost_1_59_0  -DSYSCONFDIR=/etc -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=1make -j `grep processor /proc/cpuinfo | wc -l`make install

4、启动脚本，设置开机自启动

/bin/cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqldchkconfig --add mysqldchkconfig mysqld on

5、初始化数据库之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃"--initialize"会生成一个随机密码(~/.mysql_secret)，而"--initialize-insecure"不会生成密码--datadir目标目录下不能有数据文件

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

6、修改数据库密码

dbrootpwd=oneinstack  #数据库root密码/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'127.0.0.1' identified by /"$dbrootpwd/" with grant option;"/usr/local/mysql/bin/mysql -e "grant all privileges on *.* to root@'localhost' identified by /"$dbrootpwd/" with grant option;"