CentOS 7源码编译安装mysql 5.7

安装约定

mysql安装路径:/usr/local/mysql
mysql数据库路径: /data/mysql
mysql配置文件路径:/usr/local/mysql/my.cnf

卸载mariadb

# rpm -qa | grep mariadb
# rpm -e --nodeps mariadb-libs-5.5.37-1.el7_0.x86_64  Packet name is the last query that 

用户组和用户创建

创建用户组

groupadd mysql

创建用户

useradd -g mysql mysql -s / bin / false

下载源码软件包

Http://dev.mysql.com/downloads/mysql/5.7.html#downloads
Http://download.savannah.gnu.org/releases/libunwind/
Https://github.com/gperftools/gperftools/releases

# cd /usr/local/src/
# wget http://download.savannah.gnu.org/releases/libunwind/libunwind-1.1.tar.gz
# wget http://gperftools.googlecode.com/files/gperftools-2.5.tar.gz
# wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.x.tar.gz

安装libunwind

# tar zxvf libunwind-1.1.tar.gz
# cd libunwind-1.1
# ./configure
# make
# make install

安装gperftools

# cd ..
# tar zxvf gperftools-2.1.tar.gz
# cd gperftools-2.1
# ./configure
# make
# make install
# echo "/usr/local/lib" > /etc/ld.so.conf.d/usr_local_lib.conf
# ldconfig

安装mysql

# cd ..
# tar zxvf mysql-5.7.x.tar.gz
# cd mysql-5.7.x

在编译之前,使用如下命令来查看可用的编译参数描述

# cmake . -LH | more

如果编译出现错误,删除CMakeCache.txt重新编译

rm -rf CMakeCache.txt

开始编译:

# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
 -DMYSQL_DATADIR=/data/mysql \
 -DSYSCONFDIR=/etc \
 -DEXTRA_CHARSETS=all \
 -DDEFAULT_CHARSET=utf8 \
 -DDEFAULT_COLLATION=utf8_general_ci \
 -DWITH_INNOBASE_STORAGE_ENGINE=1 \
 -DENABLED_LOCAL_INFILE=1 \
 -DMYSQL_UNIX_ADDR=/dev/shm/mysql.sock \
 -DMYSQL_TCP_PORT=3306 \
 -DMYSQL_USER=mysql \
 -DWITH_DEBUG=0 \
 -DDOWNLOAD_BOOST=1 \
 -DWITH_BOOST=/usr/local/boost
# make
# make install
 ```

  change permission 
 ```
# chmod 755 /var/lib/mysql
# cd /usr/local/mysql
# chown -R mysql:mysql .

初始化mysql

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

创建一个mysql配置文件

# cp support-files/my-default.cnf /usr/local/mysql/my.cnf

标签:CentosMySQL 发布于:2019-11-18 17:31:43