linux mysql5.7源码_CentOS 7 源码编译安装 MySQL 5.7记录

没事瞎折腾，本来可以yum安装，却偏偏去要编译源码。

1. 安装依赖包

1). 安装cmake等依赖

# yum install cmake ncurses ncurses-devel bison bison-devel

2). 安装boost 1.59.0

# wget https://jaist.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

# tar -xvf boost_1_59_0.tar.gz

# mv boost_1_59_0 /usr/local/boost

3). 添加mysql用户及目录

添加三无用户mysql，并创建根目录和数据目录

# useradd -s /sbin/nologin -c "MySQL" -M mysql

# mkdir -p /apps/mysql

# mkdir -p /data/mysql/data

# mkdir -p /data/mysql/etc

# mkdir -p /data/mysql/logs

2. 获取源码

国内MySQL镜像下载

# wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/mysql-5.7.22.tar.gz

3. 解压

# tar -xvf mysql-5.7.22.tar.gz

# cd mysql-5.7.22

4. 编译安装

cmake 参数详细可参考官方文档

# cmake -DCMAKE_INSTALL_PREFIX=/apps/mysql \

-DMYSQL_DATADIR=/data/mysql/data \

-DSYSCONFDIR=/data/mysql/etc \

-DMYSQL_UNIX_ADDR=/data/mysql/logs/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DWITH_BOOST=/usr/local/boost \

-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=OFF

# make -j `grep processor /proc/cpuinfo | wc -l`

# make install

5. 初始化数据库

修改MySQL目录权限

# cd /apps/mysql

# chown -R mysql:mysql /apps/mysql

# chown -R mysql:mysql /data/mysql/data

将mysql命令添加到环境变量中

# vim /etc/profile.d/mysql.sh

export MYSQL_HOME=/apps/mysql

export PATH=$MYSQL_HOME/bin:$PATH

# source /etc/profile

# mysql --version

初始化MySQL数据库，注意保存好root用户的密码，如果不想生成随机密码，使用--initialize-insecure 参数代替--initialize 参数进行初始化即可。

# mysqld --initialize --user=mysql --basedir=/apps/mysql --datadir=/data/mysql/data

6. 创建配置文件

# vim /data/mysql/etc/my.cnf

my.cnf文件内容，应根据实际情况修改

# For advice on how to change settings please see

#

# *** DO NOT EDIT THIS FILE. It‘s a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[client]

port = 3306

socket = /data/mysql/logs/mysqld.sock

[mysql]

socket = /data/mysql/logs/mysqld.sock

[mysqld]

basedir = /apps/mysql

datadir = /data/mysql/data

pid-file = /data/mysql/logs/mysqld.pid

socket = /data/mysql/logs/mysqld.sock

log_error = /data/mysql/logs/error.log

########basic settings########

server-id = 1

port = 3306

user = mysql

character_set_server=utf8mb4

collation-server=utf8mb4_general_ci

skip_name_resolve = 1

max_connections = 800

tmpdir = /tmp

max_allowed_packet = 64M

########innodb settings########

innodb_page_size = 8K

innodb_buffer_pool_size = 2G

innodb_buffer_pool_instances = 8

[mysqld_safe]

log-error = /data/mysql/logs/error.log

pid-file = /data/mysql/logs/mysqld.pid

[mysqldump]

quick

max_allowed_packet=32M

7. 启动MySQL服务

# cp support-files/mysql.server /etc/init.d/mysqld

# chkconfig --add mysqld

# chkconfig mysqld on

# chkconfig --list mysqld

# service mysqld start

8. 登陆及修改密码

# mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';