(二)LNMP环境源码编译安装zabbix-4.0.x——编译安装MySQL

版权声明：欢迎转载与交流。https://blog.csdn.net/one2more/article/details/115317437

1、软件包列表

序号	软件包名称	下载地址
01	boost_1_59_0.tar.gz	https://sourceforge.net/projects/boost/files/boost/1.59.0/
02	mysql-5.7.32.tar.gz	https://downloads.mysql.com/archives/community/

2、解压相关软件包

tar -xzf /usr/local/src/boost_1_59_0.tar.gz -C /usr/local/src
tar -xzf /usr/local/src/mysql-5.7.32.tar.gz -C /usr/local/src/

3、安装相关依赖包

yum install -y cmake bison bison-devel ncurses ncurses-devel openssl openssl-devel curl curl-devel

4、编译安装MySQL

cd /usr/local/src/mysql-5.7.32

# 添加mysql组
groupadd mysql

# 创建mysql用户
useradd -M -s /sbin/nologin -r -g mysql mysql

# 安装目录: /opt/mysql
# 数据目录: /opt/mysql/data
# 创建mysql相关目录并修改权限
mkdir -p /opt/mysql/{data,logs,etc}
chown -R mysql:mysql /opt/mysql/{data,logs,etc}

## cmake
cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql \
-DMYSQL_DATADIR=/opt/mysql/data \
-DSYSCONFDIR=/opt/mysql/etc \
-DINSTALL_SCRIPTDIR=/opt/mysql/sbin \
-DSYSTEMD_PID_DIR=/opt/mysql \
-DINSTALL_MYSQLTESTDIR= \
-DWITH_SYSTEMD=on \
-DSYSTEMD_SERVICE_NAME=mysqld \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/opt/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/src/boost_1_59_0 \
-DWITH_CURL=system \
-DWITH_SSL=system \
-DWITH_ZLIB=/usr/local/src/zlib-1.2.11

## make && make install
make && make install

5、配置MySQL

# 编辑my.cnf
cat > /opt/mysql/etc/my.cnf <<-EOF
[mysqld]
user = mysql
basedir=/opt/mysql
datadir=/opt/mysql/data
port=3306
socket=/opt/mysql/mysql.sock
pid-file=/opt/mysql/mysqld.pid
character-set-server=utf8
default_storage_engine=InnoDB
log-error=/opt/mysql/logs/mysqld.log
slow_query_log=1
long_query_time=1
slow_query_log_file=/opt/mysql/logs/mysql-slow.log

[mysql]
socket=/opt/mysql/mysql.sock 

[client]
socket=/opt/mysql/mysql.sock
EOF

# 配置mysql环境变量
cat > /etc/profile.d/mysql.sh <<-EOF
export PATH=/opt/mysql/bin:\$PATH
EOF

# 使环境变量生效
source /etc/profile.d/mysql.sh

# 链接libmysqlclient.so库，否则启动Zabbix-Server时会报错
cp -f /opt/mysql/lib/libmysqlclient.so.20 /usr/lib64/

# 初始化MySQL数据
/opt/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data

# 更改相关文件权限
chown -R mysql:mysql /opt/mysql

# 配置systemd管理MySQL
cp /opt/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl daemon-reload
systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld

  用文字分享技术，记录成长! 持续更新中！ 欢迎留言、评论交流！