mysql5.7.26编译配置_MySQL5.7.26编译安装

安装环境准备

下载安装包

```

[[email protected] ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.26.tar.gz

[[email protected] ~]# tar zxvf mysql-5.7.26.tar.gz

```

创建所需的安装目录/数据目录/socket文件目录

```

[[email protected] ~]# mkdir -p /app/mysql/{mysql-install,mysql-basedir,data,data1,tmp}

```

安装所需要的组件以及依赖环境

```

[[email protected] ~]#yum install -y cmake make bison bison-devel libaio-devel gcc gcc-c++ ncurses-devel

```

编译安装

添加编译参数

```

[[email protected] mysql-5.7.26]# cmake \

-DCMAKE_INSTALL_PREFIX=/app/mysql/mysql-install\

-DMYSQL_DATADIR=/app/mysql/data \

-DMYSQL_UNIX_ADDR=/app/mysql/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS=all \

-DSYSCONFDIR=/etc\

-DWITH_MEMORY_STORAGE_ENGINE=1\

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITH_ZLIB=bundled \

-DWITH_SSL=bundled \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_EMBEDDED_SERVER=1 \

-DENABLE_DOWNLOADS=1 \

-DWITH_DEBUG=0

```

*** 报错：***

```

CMake Error at cmake/boost.cmake:81 (MESSAGE):

You can download it with -DDOWNLOAD_BOOST=1 -DWITH_BOOST=

This CMake script will look for boost in . If it is not there,

it will download and unpack it (in that directory) for you.

If you are inside a firewall, you may need to use an http proxy:

export http_proxy=http://example.com:80

Call Stack (most recent call first):

cmake/boost.cmake:238 (COULD_NOT_FIND_BOOST)

CMakeLists.txt:508 (INCLUDE)

-- Configuring incomplete, errors occurred!

See also "/app/mysql-5.7.26/CMakeFiles/CMakeOutput.log".

See also "/app/mysql-5.7.26/CMakeFiles/CMakeError.log".

```

解决方法：

```

[[email protected] ~]#wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

[[email protected] app]# tar zxvf boost_1_59_0.tar.gz -C /app/

[[email protected] app]# mv boost_1_59_0/ boost

[[email protected] mysql-5.7.26]# cmake \

-DCMAKE_INSTALL_PREFIX=/app/mysql/mysql-install\

-DMYSQL_DATADIR=/app/mysql/data \

-DMYSQL_UNIX_ADDR=/app/mysql/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS=all \

-DSYSCONFDIR=/etc\

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITH_ZLIB=bundled \

-DWITH_SSL=bundled \

-DWITH_BOOST=/app/boost \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_EMBEDDED_SERVER=1 \

-DENABLE_DOWNLOADS=1 \

-DWITH_DEBUG=0

```

编译安装

```

[[email protected] mysql-5.7.26]# make && make install

```

安装收尾

授权mysql目录

```

[[email protected] app]# chown -R mysql.mysql /app/mysql

```

编辑主配置文件

```

[[email protected] data]# cat /etc/my.cnf

[mysqld]

basedir=/app/mysql/mysql-install

datadir=/app/mysql/data

socket=/app/mysql/tmp/mysql.sock

user=mysql

log_error=/tmp/mysql.log

skip_name_resolve

log_bin=/app/mysql/data/mysql-bin

server_id=5706

```

拷贝启动脚本

#### /etc/init.d

```

[[email protected] mysql-install]# cp -rp support-files/mysql.server /etc/init.d/

```

#### systemctl

```

[[email protected] bin]# vim /etc/systemd/system/mysql.service

[Unit]

Description=MySQL Server

Documentation=man:mysqld(8)

Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html

After=network.target

After=syslog.target

[Install]

WantedBy=multi-user.target

[Service]

User=mysql

Group=mysql

ExecStart=/app/mysql/mysql-install/bin/mysqld --defaults-file=/etc/my.cnf

LimitNOFILE = 5000

```

目录授权并添加环境变量

```

[[email protected] bin]# echo "export PATH=$PATH:/app/mysql/mysql-install/bin">>/etc/profile

[[email protected] bin]# source /etc/profile

```

mysql初始化

```

[[email protected] data1]# /app/mysql/mysql-install/bin/mysqld --initialize-insecure --user=mysql --basedir=/app/mysql/mysql-basedir --datadir=/app/mysql/data1

```

启动mysql

```

[[email protected] data1]# systemctl start mysql

[[email protected] data1]# systemctl status mysql

● mysql.service - MySQL Server

Loaded: loaded (/etc/systemd/system/mysql.service; disabled; vendor preset: disabled)

Active: active (running) since Mon 2020-04-06 20:41:59 CST; 5s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Main PID: 40365 (mysqld)

CGroup: /system.slice/mysql.service

└─40365 /app/mysql/mysql-install/bin/mysqld --defaults-file=/etc/my.cnf

Apr 06 20:41:59 wencq systemd[1]: Started MySQL Server.

```

原文：https://www.cnblogs.com/wenhaha/p/12642950.html