mysql 5.7 centos7 编译安装 记录

安装必要的依赖

yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

创建目录并下载

mkdir -p /data/soft

cd /data/soft/

wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.13.tar.gz

wget http://downloads.sourceforge.Net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

创建mysql用户

groupadd mysql useradd -r -g mysql mysql 

解压缩

ls -lh

tar xzf boost_1_59_0.tar.gz tar xzf mysql-5.7.9.tar.gz mv boost_1_59_0 /usr/local/boost

编译

cd mysql-5.7.9/ mkdir /usr/local/mysql cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost /usr/local/mysql/bin/mysqld  --initialize --user=mysql --basedir=/usr/local/mysql   /usr/local/mysql/bin/mysql -uroot -p  ps -ef|grep mysql  /usr/local/mysql/bin/mysqld stop 初始化库 /usr/local/mysql/bin/mysqld  --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

mv /etc/my.cnf /etc/my.cnf.bak

配置文件

 cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf /usr/local/mysql/bin/mysqld_safe  ln -s /usr/local/mysql/lib/libmysqlclient.so.20 /usr/lib/libmysqlclient.so.20 mysql -uroot -p cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld  chmod 755 /etc/init.d/mysqld     chkconfig --add mysqld    chkconfig --level 345 mysqld on    chkconfig --list mysqld  service mysqld restart  chown -R mysql.mysql /usr/local/mysql  mysql -u root -p  ln -s /usr/local/mysql/bin/mysql /usr/bin  mysql -u root -p  service mysqld start  mysql -u root -p