centos 8 源码安装 mysql8

本文CentOS版本：CentOS 8

MySQL版本：mysql-8.0.18

系统约定

软件源代码包存放位置：/usr/local/src

源码包编译安装位置：/usr/local/软件名字

yum 安装的依赖包

yum install apr* autoconf automake bison bzip2 bzip2* cpp curl cmake curl-devel fontconfig fontconfig-devel \
freetype-devel gcc gcc-c++ gd gd-devel gettext gettext-devel glibc \
kernel kernel-headers keyutils keyutils-libs-devel krb5-devel libcom_err-devel \
libpng libpng-devel libjpeg* libsepol-devel libselinux-devel libstdc++-devel libtool* libgomp \
libxml2 libxml2-devel libXpm* libxml* libXaw-devel libXmu-devel libtiff libtiff* make openssl openssl-devel \
patch pcre-devel perl policycoreutils telnet wget zlib-devel ncurses-devel libtirpc-devel gtk* ntpstat na* bison* -y

下载软件包

cd /usr/local/src

1、mysql

curl -O https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18.tar.gz

2、rpcsvc-proto #CentOS 8编译安装MySQL8需要

curl -O https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4/rpcsvc-proto-1.4.tar.gz

3、boost_1_70_0 #CentOS 8编译安装MySQL8需要

curl -O https://dl.bintray.com/boostorg/release/1.70.0/source/boost_1_70_0.tar.gz

安装相应的源码包

tar zxvf rpcsvc-proto-1.4.tar.gz

cd rpcsvc-proto-1.4

./configure

make

make install

tar -zxvf mysql-8.0.18.tar.gz

cd mysql-8.0.18 

mkdir build 

cd build 

cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DWITH_DEBUG=OFF \
-DENABLED_PROFILING=ON \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_INNOBASE_STORAGE_ENGINE=ON \
-DWITH_FEDERATED_STORAGE_ENGINE=ON \
-DWITH_ARCHIVE_STORAGE_ENGINE=ON \
-DWITH_EMBEDDED_SERVER=OFF \
-DWITH_BLACKHOLE_STORAGE_ENGINE=ON \
-DWITH_UNIT_TESTS=OFF \
-DENABLE_DTRACE=OFF \
-DWITH_BOOST=/usr/local/src \
-DMYSQL_DATADIR=/data/mysql

make -j N ( 根据自己系统性能设置，为了加快编译)

make install 

make install

/usr/local/mysql/bin/mysqld \
--initialize-insecure=off
--user=mysql \
--basedir=/usr/local/mysql/ \
--datadir=/data/mysql/

具体的安装细节可以看前面写过的安装MYSQL8的细节，这边不在详细些了，把一些关键的命令记录一下

https://www.cnblogs.com/centos-python/articles/10860421.html 

我使用的是CentOS8，其内置的gcc与cmake都是达到了安装mysql8.0.15以上版本的要求，但需要 安装rpcsvc-proto 来实现编译相关的安装

https://github.com/thkukuk/rpcsvc-proto/releases/

 可能遇到的报错

#启动报错的问题
#perl: warning: Setting locale failed.
#perl: warning: Please check that your locale settings:
#LANGUAGE = (unset),
#LC_ALL = (unset),
#LANG = "en_US.UTF-8" are supported and installed on your system.
#perl: warning: Falling back to the standard locale ("C").

 参考这篇文章

export LC_ALL=C

或者写到环境变量文件里面

https://www.cnblogs.com/djiankuo/p/6653180.html?utm_source=itdadao&utm_medium=referral