mysql 5.7.12源码_MySQL 5.7.12 源码编译安装

最新推荐文章于 2021-09-13 19:07:38 发布

白苏艾

最新推荐文章于 2021-09-13 19:07:38 发布

阅读量158

点赞数

文章标签： mysql 5.7.12源码

本文链接：https://blog.csdn.net/weixin_42136791/article/details/113588677

版权

本文详细介绍了如何在CentOS 7.2环境下，通过源码编译安装MySQL 5.7.12。包括清理环境、创建用户和目录、解决编译安装过程中的问题，如安装编译环境、下载Boost库、安装ncurses-devel，以及后续的配置、启动和权限设置等步骤。

摘要由CSDN通过智能技术生成

环境准备：

mysql 安装包：mysql-boost-5.7.12.tar.gz

系统版本：CentOS Linux release 7.2.1511 (Core)

一清理环境

yum list installed *mysql*

yum remove installed *mysql*

二创建mysql组和用户

groupadd mysql

useradd -r -g mysql -s /bin/false mysql

注：mysql 用户设置为禁止登陆，分配有限资源，以便限制访问

三创建数据库使用目录

mkdir /usr/local/mysql

mkdir -p /data/mysql_data

chown -R mysql:mysql /data/mysql_data

四编译安装

1)安装编译环境

yum install cmake make gcc gcc-c++ ncurses-devel

2)cmake 生成 makefile 以供指导安装

tar -xvf mysql-boost-5.7.12.tar.gz

cd mysql-5.7.12

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql_data -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost/boost_1_59_0/

注：cmake 使用你的编译解释：

注：这里遇到的问题：

错误一：

-- Running cmake version 2.8.11

-- Could NOT find Git (missing: GIT_EXECUTABLE)

-- Configuring with MAX_INDEXES = 64U

-- The C compiler identification is unknown

-- The CXX compiler identification is unknown

CMake Error: your C compiler: "CMAKE_C_COMPILER-NOTFOUND" was not found. Please set CMAKE_C_COMPILER to a valid compiler path or name.

CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found. Please set CMAKE_CXX_COMPILER to a valid compiler path or name.

CMake Error at cmake/os/Linux.cmake:41 (MESSAGE):

Unsupported compiler!

Call Stack (most recent call first):

CMakeLists.txt:162 (INCLUDE)

解决方法：yum install gcc gcc-c++

错误二：

-- Could not find (the correct version of) boost.

-- MySQL currently requires boost_1_59_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:451 (INCLUDE)

解决方法：

从MySQL 5.7.5开始Boost库是必需的

下载 mysql-boost-5.7.12.tar.g 在 cmake 指定参数 -DWITH_BOOST=boost/boost_1_59_0/

或直接cmake指定参数 -DDOWNLOAD_BOOST=1 -DWITH_BOOST= 系统会下载 boost

错误三：

-- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)

CMake Error at cmake/readline.cmake:64 (MESSAGE):

Curses library not found. Please install appropriate package,

remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):

cmake/readline.cmake:107 (FIND_CURSES)

cmake/readline.cmake:181 (MYSQL_USE_BUNDLED_EDITLINE)

CMakeLists.txt:479 (MYSQL_CHECK_EDITLINE)

解决方法：yum install ncurses-devel

3)编译安装

make && make install

4)mysql 命令添加到环境变量中

vi /etc/profile

source /etc/profile

# mysql env

PATH=/usr/local/mysql/bin:$PATH

export PATH

五安装设置mysql 服务，并开机自启动

chown -R mysql.mysql /usr/local/mysql/

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

chmod 755 /etc/init.d/mysqld

#增加一个mysqld 服务器

chkconfig --add mysqld

#设置MySQL服务器在运行级别2345上运行

chkconfig mysql on

chkconfig --list

Note: This output shows SysV services only and does not include native

systemd services. SysV configuration data might be overridden by native

systemd configuration.

If you want to list systemd services use 'systemctl list-unit-files'.

To see services enabled on particular target use

'systemctl list-dependencies [target]'.

mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

六安装数据库

cd /usr/local/mysql

mkdir -p /data/mysql_data

./bin/mysql_install_db --user=mysql --datadir=/data/mysql_data

echo $?

七创建配置文件

vim /etc/my.cnf(注：以下配置仅供参考)

[mysqld]

datadir=/data/mysql_data

socket=/usr/local/mysql/mysql.sock

user=mysql

symbolic-links=0

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

key_buffer_size = 8144M

table_cache_size = 1024M

read_buffer_size = 128M

sort_buffer_size = 32M

query_cache_size = 100M

thread_cache_size = 16

thread_concurrency = 32

max_heap_table_size = 400M

tmp_table_size = 400M

max_connections = 500

# The end

说明：

八启动数据库

/etc/init.d/mysqld start

或

service mysqld start

[root@f823a1ce09a8 local]# /etc/init.d/mysqld start

Starting MySQL. SUCCESS!

[root@f823a1ce09a8 local]# ps -aux | grep mysql

root 20149 0.0 0.1 11772 2772 ? S 08:13 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql_data --pid-file=/data/mysql_data/f823a1ce09a8.pid

mysql 20439 0.7 9.8 2465512 201608 ? Sl 08:13 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql_data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/data/mysql_data/f823a1ce09a8.pid --socket=/usr/local/mysql/mysql.sock

root 20468 0.0 0.0 9044 804 ? S+ 08:13 0:00 grep --color=auto mysql

九登陆数据库

mysql5.7会生成一个初始化密码，而在之前的版本首次登陆不需要登录

查看root 密码

[root@f823a1ce09a8 mysql_data]# cat /root/.mysql_secret

# Password set for user 'root@localhost' at 2016-05-09 08:38:54

ia8GCm:d>(bo

mysql -u root -p 登陆

十修改权限

1)修改密码

修改root密码：

mysqladmin -u root -p -h CentOS-StandAlone password 'newpassword'