mysql5.7第一篇编译安装部署（centos7）

1）安装文件准备

下载cmake-3.5.tar.gz    http://mysqla.cmake.org/download/

下载ncurses-5.9.tar.gzftp://ftp.gnu.org/gnu/ncurses/

下载bison-3.0.4.tar.gzhttp://ftp.gnu.org/gnu/bison/

下载mysql-5.7.13.tar.gz

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

下载Boost_1_59_0.tar.gz

wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

yum groupinstall "Development Tools"
yum install lrzsz
rpm -qa |grep mariadb
rpm -e mariadb-libs --nodeps


tar zxvf cmake-3.5.2.tar.gz 
cd cmake-3.5.2/
./bootstrap 
gmake && gmake install
cmake -version


cd ..
tar zxvf ncurses-5.9.tar.gz 
cd ncurses-5.9/
./configure && make && make install

cd ..
tar zxvf bison-3.0.4.tar.gz 
cd bison-3.0.4/
./configure && make && make install

cd ..
tar zxvf boost_1_59_0.tar.gz 
mv boost_1_59_0 /usr/local/boost

groupadd -r mysql
useradd -r -g mysql -s /bin/false -M mysql

tar zxvf mysql-5.7.18.tar.gz 
cd mysql-5.7.18/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_SYSTEMD=1 -DWITH_BOOST=/usr/local/boost

make && make install

echo "export PATH=$PATH:/usr/local/mysql/bin">>/etc/profile
source /etc/profile
 
mkdir /usr/local/mysql/data -p
mkdir /usr/local/mysql/log


chown -R mysql:mysql /usr/local/mysql/
chmod 750 /usr/local/mysql/data/

初始化：任选一
1.有密码
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
2.无密码
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data


vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
server_id=1
socket=/usr/local/mysql/mysql.sock
log-error=/usr/local/mysql/data/mysqld.err




cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl enable mysqld



1.
mkdir /var/run/mysqld
chown -R mysql:mysql /var/run/mysqld/