mysql5.7.24极速编译安装

1. 安装依赖

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

2. 解压安装包

tar -xvf mysql-5.7.24.tar.gz

3. 创建mysql用户组

groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql

4. 创建数据目录创建log目录 创建UNIX SOCK目录创建PID目录

mkdir -p /data/mysql && chown mysql.mysql /data/mysql
mkdir -p /var/log/mysql && chown mysql.mysql /var/log/mysql
mkdir -p /var/lib/mysql && chown mysql.mysql /var/lib/mysql
mkdir -p /var/run/mysqld && chown mysql.mysql /var/run/mysqld

5. 预编译

cmake
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DWITH_BOOST=/usr/local/boost_1_59_0
-DMYSQL_DATADIR=/data/mysql
-DSYSCONFDIR=/etc
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysqld.sock
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_PARTITION_STORAGE_ENGINE=1
-DENABLED_LOCAL_INFILE=1
-DENABLED_PROFILING=1
-DMYSQL_TCP_PORT=3306
-DWITH_DEBUG=0
-DDOWNLOAD_BOOST=1

7.获取线程编译

make -j grep processor /proc/cpuinfo | wc -l && make install

8.赋用户权限

chown -R mysql:mysql /usr/local/mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld

9.设置开机自启

chkconfig --add mysqld
chkconfig mysqld on

10.建立软链接

ln -s /usr/local/mysql/bin/* /usr/local/bin/

11.初始化数据库

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
会生成初始密码

12.重启服务

service mysqld restart