KVM MYSQL 8.0.13 单机 FOR OEL7.5 源码编译安装文档

最新推荐文章于 2023-01-18 16:40:15 发布
最新推荐文章于 2023-01-18 16:40:15 发布
阅读量386 收藏
点赞数
分类专栏： MySQL 文章标签： source code Mysql 源码安装
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Gjikcheng/article/details/83903009
版权

1. 虚拟机系统KVM MYSQL 8.0.13 单机 FOR OEL7.5 源码安装文档

2. 安装流程

2.1. 确定平台版本和机器位数。

确定当前MYSQL版本对应各种操作系统 平台是否支持。

https://www.mysql.com/support/supportedplatforms/database.html

2.2. 下载对应版本

2.2.1. 下载二进制安装包

 官方网站
http://dev.mysql.com/downloads/mirrors.html.
 进入后可以选择对应的版本

NOTE:
tar.gz tar.xz 为二进制安装。
RPM 为rpm 安装包。
deb 为 deband linux 安装包.
PKG 为mac 文件安装包。

2.2.2. 下载yum 源配置包（社区版）

https://dev.mysql.com/downloads/repo/yum/

2.2.3. 下载源码编译

 源码现目前在GIT 上托管。

2.3. 验证下载后文件是否正确

  • LINUX AND WINDOWS MD5 验证
shell> md5sum mysql-standard-8.0.13-linux-i686.tar.gz
aaab65abbec64d5e907dcd41b8699945  mysql-standard-8.0.13-linux-i686.tar.gz

shell> md5.exe mysql-installer-community-8.0.13.msi
aaab65abbec64d5e907dcd41b8699945  mysql-installer-community-8.0.13.msi
  • RPM 包验证
shell> rpm --checksig MySQL-server-8.0.13-0.linux_glibc2.5.i386.rpm
MySQL-server-8.0.13-0.linux_glibc2.5.i386.rpm: md5 gpg OK

3. 使用源码安装部署MYSQL到linux

3.1. 安装编译工具

Cmake 可以通过https://cmake.org/download/. 获取
make 安装包http://www.gnu.org/software/make/.

  • linux yum 源安装
    说明: yum 源要打开ol7_optional_latest选项.
yum install cmake gcc  make git  bison boost ncurses \
openssl-devel openssl ncurses-devel numactl \
ncurses*i686  libatomic   cyrus-sasl-lib*i686  openldap-devel gcc-c++ libicu* protobuf* \
protobuf-lite libicu libedit*  libaio-devel* autoconf automake m4 libtool make cmake bison gcc
  • 由于cmake 版本需要3.2.1 以上版本过低需要升级:

wget  https://github.com/Kitware/CMake/releases/download/v3.15.1/cmake-3.15.1.tar.gz
  • make 需要3.75 以上.
gcc : 5.3 以上.
Clang:3.4 以上(xcode7 或macos)
Solaris Studio :12.4
Visual Studio: 2015
Boost C++ libraries  [http://www.boost.org/](http://www.boost.org/)
CMake  3.2.3
ncurses

:::alert-warning
注意:
如果升级了cmake ,gcc ,和make ,请把原有的 rpm 卸载.否则编译得时候会多出步骤,例如指出编译器位置.

:::

3.2. 安装标准源码包

3.2.1. 增加MySQL组

groupadd mysql

3.2.2. 增加MySQL用户

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

3.2.3. 解压源码包

tar -zxvf mysql-VERSION.tar.gz
  • note:没有z 选项
shell> gunzip < mysql-VERSION.tar.gz | tar xvf -
  • note:使用CMAKE 解压
shell> cmake -E tar zxvf mysql-VERSION.tar.gz

3.2.4. 创建编译环境

cd mysql-VERSION
mkdir bld
cd bld

NOTE:

为了保持源码根目录保持原样。创建新目录进行编译生成的新文件都在bld 里面

3.2.5. 配置源码编译目录

cmake ..
  • 使用cmake 可以使用以下选项
    • -DBUILD_CONFIG=mysql_release: 配置Mysql版本的
    • -DCMAKE_INSTALL_PREFIX=dir_name: 配置安装目录的前缀。所有的安装文件都会在这个目录下存在
    • -DCPACK_MONOLITHIC_INSTALL=1: 编译出来的文件只有一个
    • -DWITH_DEBUG=1:开启debug 信息。.
    • -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/mysql-8.0.12/bld: 下载boost 组件并且下载到bld 目录下.

• -DWITH_SYSTEMD=1 :使用systemd 方式管理.
:::alert-warning
注意: 使用了systemd 方式后,跟rpm包安装一样,没有msyql_safe 脚本和mysqld_muti
注意:当你如果升级gcc 后安装目录位/usr/local/* 需要指定给cmake
:::
• -CMAKE_C_COMPILER=/usr/local/gcc
• -CMAKE_CXX_COMPILER=/usr/local/g++

  • 显示显示编译配置信息
shell> cmake .. -L   # overview 总览
shell> cmake .. -LH  # overview with help text 显示每个选项的帮助
shell> cmake .. -LAH # all params with help text 所有选项的帮助
shell> cmake ..     # interactive display 交互式显示
  • 范例：
cmake ..  -DWITH_DEBUG=1 -DCMAKE_INSTALL_PREFIX=/app/mysql -DCPACK_MONOLITHIC_INSTALL=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/mysql-8.0.12/bld


cmake ..  -DCMAKE_INSTALL_PREFIX=/app/mysql  -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/mysql-8.0.12/bld
# 添加systemd 管理方式,且指定安装目录.
cmake  .. -DWITH_SYSTEMD=1 -DCMAKE_INSTALL_PREFIX=/app/  -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/mysql-8.0.15/bld -DCMAKE_CXX_COMPILER=/usr/local/bin/g++ -CMAKE_C_COMPILER=/usr/local/bin/gcc
# 普通编译模式.
cmake  ..  -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/root/mysql-8.0.15/bld

3.2.6. 编译

set(CMAKE_C_COMPILER "/usr/local/gcc")
set(CMAKE_CXX_COMPILER "/usr/local/g++")

shell> make
shell> make VERBOSE=1
#能够显示更多信息.
shell> make -j 20  VERBOSE=1
#如果日志太多不好看,请重定向.
shell> make -j 20   VERBOSE=1 > build.log 2>&1 &

NOTE:

第二个命令显示更多的信息.-j 20 为并发

3.3. 安装MySQL

make install

NOTE:

指定安装目录前缀，注意如果在cmke 节点已经指定目录，则此为安装目录

  • 在此指定安装目录
shell> make install DESTDIR="/app/mysql"

3.3.1. 进入默认安装目录

cd /usr/local/mysql
  • 创建安全认证目录
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files

3.3.2. 初始化数据库

shell> bin/mysqld --initialize --user=mysql
  • 初始化数据库的两种方式
shell> bin/mysqld --initialize --user=mysql
shell> bin/mysqld --initialize-insecure --user=mysql

Note：

两种初始化方式第一种必须强制使用密码登录。
第二种方式可以使用跳过密码
shell> mysql -u root --skip-password
然后更改对应密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
在mysql 8.0 默认加密的密码已经改了。现在默认使用caching_sha2_password 加密方式。
如果还需使用默认的mysql_native_password 加密方式的话使用默认 模式。
初始化的时候，默认路径为/usr/local/mysql

3.3.2.1. 更改默认路径
  • 如果要改变安装目录使用以下目录：
shell> bin/mysqld --initialize --user=mysql \
         --basedir=/opt/mysql/mysql \
         --datadir=/opt/mysql/mysql/data
  • 配置文件:
 [mysqld]
basedir=/opt/mysql/mysql
datadir=/opt/mysql/mysql/data
  • 使用配置文件指定位置:`
shell> bin/mysqld --defaults-file=/etc/my.cnf \
         --initialize-insecure --user=mysql
  • 范例：
 shell> bin/mysqld --initialize-insecure --user=mysql \
--basedir=/app/mysql \
         --datadir=/app/mysql/mysql-files
  • 输出日志：
[root@mysql1 mysql]# bin/mysqld --initialize-insecure --user=mysql \
> --basedir=/app/mysql \
>          --datadir=/app/mysql/mysql-files
2018-09-28T16:18:32.178288Z 0 [System] [MY-013169] [Server] /app/mysql-commercial-8.0.12-el7-x86_64/bin/mysqld (mysqld 8.0.12-commercial) initializing of server in progress as process 5328
2018-09-28T16:18:46.268910Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2018-09-28T16:18:57.082553Z 0 [System] [MY-013170] [Server] /app/mysql-commercial-8.0.12-el7-x86_64/bin/mysqld (mysqld 8.0.12-commercial) initializing of server has completed

3.4. 创建安全连接

  • 帮助说明：
FormatDescription
[–datadir](file:///D:/refman-8.0-en.html-chapter/programs.html#option_mysql_ssl_rsa_setup_datadir)Path to data directory
[–help](file:///D:/refman-8.0-en.html-chapter/programs.html#option_mysql_ssl_rsa_setup_help)Display help message and exit
[–suffix](file:///D:/refman-8.0-en.html-chapter/programs.html#option_mysql_ssl_rsa_setup_suffix)Suffix for X509 certificate Common Name attribute
[–uid](file:///D:/refman-8.0-en.html-chapter/programs.html#option_mysql_ssl_rsa_setup_uid)Name of effective user to use for file permissions
[–verbose](file:///D:/refman-8.0-en.html-chapter/programs.html#option_mysql_ssl_rsa_setup_verbose)Verbose mode
[–version](file:///D:/refman-8.0-en.html-chapter/programs.html#option_mysql_ssl_rsa_setup_version)Display version information and exit
  • 默认目录
shell> bin/mysql_ssl_rsa_setup
  • 指定目录
bin/mysql_ssl_rsa_setup --datadir=/app/mysql/mysql-files/

bin/mysql_ssl_rsa_setup --datadir=/app/mysql/data/

3.5. 安装开发中源码

NOTE:

主要介绍怎样从git 中每一个分支中安装MySQL

  • 从git 中下载源码
git clone https://github.com/mysql/mysql-server.git
  • 进入目录
cd mysql-server
  • 查看分支结构
git branch -r
  • 查看当前分支
git branch
  • 切换分支到8.0
git checkout 8.0
  • 检查
git branch
  • 切换分支到5.7
git checkout 5.7
  • 更新分支
~/mysql-server$ git checkout 8.0
~/mysql-server$ git pull
  • 查看日志log
git log

剩下的操作跟标准源码包安装一样。

4. 启动和关闭

 shell> bin/mysqld_safe --user=mysql &
# 6. Next command is optional

4.1. 拷贝自启动文件

shell> cp /app/mysql/support-files/mysql.server /etc/init.d/

4.2. 编辑my.cnf 文件

basedir=/app/mysql
datadir=/app/mysql/mysql-files

4.3. 重载启动项目

systemctl  daemon-reload

4.4. 查看是否启动MySQL

systemctl  status mysql

4.5. 开机自启动

NOTE:

由于使用二进制安装,则需要配置chkconfig 。RPM 包不需要

chkconfig --add mysql.server
chkconfig mysql.server on

5. MySQL 启动后诊断

5.1. 查看日志

tail host_name.err

5.2. 选择驱动

默认为InnoDB

5.3. 确认数据文件位置是否合适

5.4. 查看所有配置参数和所有的环境变量

mysqld --basedir=/app/mysql --verbose –help | more

5.5. 配置文件环境变量

mysqladmin variables
mysqladmin -h host_name variables

6. 测试MySQL

  • 检查mysql 是否正常运行
mysqladmin version
  • 检查配置变量值
mysqladmin variables
  • 检查是否能登陆
mysqladmin -u root -p version
  • 关闭mysql 服务
mysqladmin -u root shutdown
  • 显示mysql 数据库
mysqlshow
  • 显示某个数据库中的表
mysqlshow mysql
  • shell 界面查询表数据
mysql -e "SELECT User, Host, plugin FROM mysql.user" mysql

NOTE:

以上命令成功执行后则mysql 数据正常。

7. 账户安全

  • 使用mysqld --insecure初始化后的密码更改
mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
  • 如果使用mysqld --initialize-insecure 进行初始化
    则：
mysql -u root --skip-password
  • 更改密码：
ALTER USER 'root'@'localhost' IDENTIFIED BY '3345091'
  • 由于密码复杂度有相关要求：但是测试不需要则
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password.check_user_name    | ON     |
| validate_password.dictionary_file    |        |
| validate_password.length             | 8      |
| validate_password.mixed_case_count   | 1      |
| validate_password.number_count       | 1      |
| validate_password.policy             | MEDIUM |
| validate_password.special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.01 sec)

mysql> set validate_password.policy=0;
ERROR 1229 (HY000): Variable 'validate_password.policy' is a GLOBAL variable and should be set with SET GLOBAL
mysql> set GLOBAL validate_password.policy=0;
  • 设置密码复杂度为低。更方便测试。
ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678';

8. 编译错误解决

查看CMakeCache.txt 错误全部解决后然后删除CMakeCache.txt 重新cmake

编译工具无法找到：
可以使用the CMAKE_C_FLAGS and CMAKE_CXX_FLAGS 指定编译工具

shell> CC=gcc
shell> CXX=g++
shell> export CC CXX

确保这个参数在disable 状态下。因为打开这个参数会把警告变成错误。导致编译无法进行编译下去。

如果遇到以下错误

make: Fatal error in reader: Makefile, line 18:
Badly formed macro assignment
Or:
make: file `Makefile' line 18: Must be a separator (:
Or:
pthread.h: No such file or directory

请升级make 版本。确保make 3.75 以上

如果遇到

"sql_yacc.yy", line xxx fatal: default action causes potential...

这个错误
请升级bison older than 1.75 以上

9. Doxygen 文档生成

NOTE:
> 此文档为开发调优时用到的文档，源代码中的组成部件和组成功能都在文档中有体现。

9.1. 文档须知需要决定MySQL 的版本

MYSQL_VERSION_MAJOR=8
MYSQL_VERSION_MINOR=0
MYSQL_VERSION_PATCH=4
MYSQL_VERSION_EXTRA=-rc

如果MySQL MySQL不是通用版本，则MYSQL_VERSION_EXTRA 值将不是空的。对于例子，
安装编程辅助工具文档内容
MySQL 源码里包含里使用编程辅助器写的文档，

9.2. 安装doxygen

yum install doxygen
or 
http://www.stack.nl/~dimitri/doxygen/download.html

9.3. 下载绘图矢量包

plantuml.jar
http://plantuml.com/download.html

9.4. 安装java

yum install java

9.5. 启动矢量包服务

java -jar path-to-plantuml.jar

9.6. 安装矢量绘图软件graphviz

yum install graphviz
or 
官网下载
http://www.graphviz.org/

9.7. 检测软件是否安装成功

shell> which dot
/usr/bin/dot
shell> dot -V
dot - graphviz version 2.28.0 (20130928.0220)

9.8. 配置矢量包路径

export PLANTUML_JAR_PATH=/root/plantuml.jar

9.9. 在MySQL 源码根目录创建目录

mkdir -p generated/doxygen

9.10. 移动改名Doxyfile

cp Doxyfile-<fdafd> Doxyfile

9.11. 生成文档

doxygen

9.12. 安装浏览器

yum install dbus-x11
yum groupinstall 'Fonts'
yum install firefox

9.13. 启动浏览器开始浏览

firefox generated/doxygen/html/index.html

firefox @DOXYGEN_OUTPUT_DIR@/html/

9.14. 官网浏览网址

https://dev.mysql.com/doc/internals/en/

10. 附录

10.1. 忘记root 密码

  • 方法1：
kill `cat /mysql-data-directory/host_name.pid`
  • 把以下语句保存到文件中
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

例如：/root/mysql-init

  • 开始改变密码
mysqld --init-file=/home/me/mysql-init &

mysql 服务会自动启动。

  • 然后删除保存密码的文件。
    方法2：
    添加my.cnf 选项
--skip-grant-tables:
  • 重启MySQL
  • 更改密码
mysql
FLUSH PRIVILEGES;
update user set password=password("new_pass") where user="root";
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

10.2. 编译选项参数

FormatsDescriptionDefaultIntroducedRemoved
[BUILD_CONFIG](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_build_config)Use same build options as official releases
[BUNDLE_RUNTIME_LIBRARIES](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_bundle_runtime_libraries)Bundle runtime libraries with server MSI and Zip packages for WindowsOFF8.0.11
[CMAKE_BUILD_TYPE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_cmake_build_type)Type of build to produceRelWithDebInfo
[CMAKE_CXX_FLAGS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_cmake_cxx_flags)Flags for C++ Compiler
[CMAKE_C_FLAGS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_cmake_c_flags)Flags for C Compiler
[CMAKE_INSTALL_PREFIX](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_cmake_install_prefix)Installation base directory/usr/local/mysql
[COMPILATION_COMMENT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_compilation_comment)Comment about compilation environment
[CPACK_MONOLITHIC_INSTALL](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_cpack_monolithic_install)Whether package build produces single fileOFF
[DEFAULT_CHARSET](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_default_charset)The default server character setutf8mb4
[DEFAULT_COLLATION](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_default_collation)The default server collationutf8mb4_0900_ai_ci
DISABLE_DATA_LOCKExclude the performance schema data lock instrumentationOFF
[DISABLE_PSI_COND](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_cond)Exclude Performance Schema condition instrumentationOFF
[DISABLE_PSI_ERROR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_error)Exclude the performance schema server error instrumentationOFF
[DISABLE_PSI_FILE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_file)Exclude Performance Schema file instrumentationOFF
[DISABLE_PSI_IDLE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_idle)Exclude Performance Schema idle instrumentationOFF
[DISABLE_PSI_MEMORY](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_memory)Exclude Performance Schema memory instrumentationOFF
[DISABLE_PSI_METADATA](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_metadata)Exclude Performance Schema metadata instrumentationOFF
[DISABLE_PSI_MUTEX](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_mutex)Exclude Performance Schema mutex instrumentationOFF
[DISABLE_PSI_PS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_ps)Exclude the performance schema prepared statementsOFF
[DISABLE_PSI_RWLOCK](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_rwlock)Exclude Performance Schema rwlock instrumentationOFF
[DISABLE_PSI_SOCKET](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_socket)Exclude Performance Schema socket instrumentationOFF
[DISABLE_PSI_SP](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_sp)Exclude Performance Schema stored program instrumentationOFF
[DISABLE_PSI_STAGE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_stage)Exclude Performance Schema stage instrumentationOFF
[DISABLE_PSI_STATEMENT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_statement)Exclude Performance Schema statement instrumentationOFF
[DISABLE_PSI_STATEMENT_DIGEST](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_statement_digest)Exclude Performance Schema statements_digest instrumentationOFF
[DISABLE_PSI_TABLE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_table)Exclude Performance Schema table instrumentationOFF
[DISABLE_PSI_THREAD](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_thread)Exclude the performance schema thread instrumentationOFF
[DISABLE_PSI_TRANSACTION](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_psi_transaction)Exclude the performance schema transaction instrumentationOFF
[DISABLE_SHARED](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_disable_shared)Do not build shared libraries, compile position-dependent codeOFF
[DOWNLOAD_BOOST](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_download_boost)Whether to download the Boost libraryOFF
[DOWNLOAD_BOOST_TIMEOUT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_download_boost_timeout)Timeout in seconds for downloading the Boost library600
[ENABLED_LOCAL_INFILE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enabled_local_infile)Whether to enable LOCAL for LOAD DATA INFILEOFF
[ENABLED_PROFILING](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enabled_profiling)Whether to enable query profiling codeON
[ENABLE_DEBUG_SYNC](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enable_debug_sync)Whether to enable Debug Sync supportON8.0.1
[ENABLE_DOWNLOADS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enable_downloads)Whether to download optional filesOFF
[ENABLE_DTRACE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enable_dtrace)Whether to include DTrace support8.0.1
[ENABLE_EXPERIMENTAL_SYSVARS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enable_experimental_sysvars)Whether to enabled experimental InnoDB system variablesOFF8.0.11
[ENABLE_GCOV](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enable_gcov)Whether to include gcov support
[ENABLE_GPROF](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_enable_gprof)Enable gprof (optimized Linux builds only)OFF
[FORCE_UNSUPPORTED_COMPILER](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_force_unsupported_compiler)Whether to permit unsupported compilerOFF
[IGNORE_AIO_CHECK](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_ignore_aio_check)With -DBUILD_CONFIG=mysql_release, ignore libaio checkOFF
[INSTALL_BINDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_bindir)User executables directoryPREFIX/bin
[INSTALL_DOCDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_docdir)Documentation directoryPREFIX/docs
[INSTALL_DOCREADMEDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_docreadmedir)README file directoryPREFIX
[INSTALL_INCLUDEDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_includedir)Header file directoryPREFIX/include
[INSTALL_INFODIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_infodir)Info file directoryPREFIX/docs
[INSTALL_LAYOUT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_layout)Select predefined installation layoutSTANDALONE
[INSTALL_LIBDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_libdir)Library file directoryPREFIX/lib
[INSTALL_MANDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_mandir)Manual page directoryPREFIX/man
[INSTALL_MYSQLKEYRINGDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_mysqlkeyringdir)Directory for keyring_file plugin data fileplatform specific
[INSTALL_MYSQLSHAREDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_mysqlsharedir)Shared data directoryPREFIX/share
[INSTALL_MYSQLTESTDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_mysqltestdir)mysql-test directoryPREFIX/mysql-test
[INSTALL_PKGCONFIGDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_pkgconfigdir)Directory for mysqlclient.pc pkg-config fileINSTALL_LIBDIR/pkgconfig
[INSTALL_PLUGINDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_plugindir)Plugin directoryPREFIX/lib/plugin
[INSTALL_SBINDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_sbindir)Server executable directoryPREFIX/bin
[INSTALL_SECURE_FILE_PRIVDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_secure_file_privdir)secure_file_priv default valueplatform specific
[INSTALL_SHAREDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_sharedir)aclocal/mysql.m4 installation directoryPREFIX/share
[INSTALL_STATIC_LIBRARIES](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_static_libraries)Whether to install static librariesON
[INSTALL_SUPPORTFILESDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_install_supportfilesdir)Extra support files directoryPREFIX/support-files
[LINK_RANDOMIZE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_link_randomize)Whether to randomize order of symbols in mysqld binaryOFF8.0.1
[LINK_RANDOMIZE_SEED](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_link_randomize_seed)Seed value for LINK_RANDOMIZE optionmysql8.0.1
[MAX_INDEXES](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_max_indexes)Maximum indexes per table64
[MUTEX_TYPE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mutex_type)InnoDB mutex typeevent
[MYSQLX_TCP_PORT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysqlx_tcp_port)TCP/IP port number used by X Plugin33060
[MYSQLX_UNIX_ADDR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysqlx_unix_addr)Unix socket file used by X Plugin/tmp/mysqlx.sock
[MYSQL_DATADIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysql_datadir)Data directory
[MYSQL_MAINTAINER_MODE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysql_maintainer_mode)Whether to enable MySQL maintainer-specific development environmentOFF
[MYSQL_PROJECT_NAME](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysql_project_name)Windows/OS X project nameMySQL
[MYSQL_TCP_PORT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysql_tcp_port)TCP/IP port number3306
[MYSQL_UNIX_ADDR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_mysql_unix_addr)Unix socket file/tmp/mysql.sock
[ODBC_INCLUDES](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_odbc_includes)ODBC includes directory
[ODBC_LIB_DIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_odbc_lib_dir)ODBC library directory
[OPTIMIZER_TRACE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_optimizer_trace)Whether to support optimizer tracing
[REPRODUCIBLE_BUILD](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_reproducible_build)Take extra care to create a build result independent of build location and time8.0.11
[SYSCONFDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_sysconfdir)Option file directory
[SYSTEMD_PID_DIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_systemd_pid_dir)Directory for PID file under systemd/var/run/mysqld
[SYSTEMD_SERVICE_NAME](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_systemd_service_name)Name of MySQL service under systemdmysqld
[TMPDIR](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_tmpdir)tmpdir default value
[USE_LD_GOLD](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_use_ld_gold)Whether to use GNU gold loaderON8.0.0
[WIN_DEBUG_NO_INLINE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_win_debug_no_inline)Whether to disable function inliningOFF
[WITHOUT_SERVER](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_without_server)Do not build the serverOFF
[WITHOUT_xxx_STORAGE_ENGINE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_storage_engine_options “Storage Engine Options”)Exclude storage engine xxx from build
[WITH_ANT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_ant)Path to Ant for building GCS Java wrapper8.0.11
[WITH_ASAN](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_asan)Enable AddressSanitizerOFF
[WITH_ASAN_SCOPE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_asan_scope)Enable AddressSanitizer -fsanitize-address-use-after-scope Clang flagOFF8.0.4
[WITH_AUTHENTICATION_LDAP](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_authentication_ldap)Whether to report error if LDAP authentication plugins cannot be builtOFF8.0.2
[WITH_AUTHENTICATION_PAM](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_authentication_pam)Build PAM authentication pluginOFF
[WITH_AWS_SDK](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_aws_sdk)Location of Amazon Web Services software development kit8.0.2
[WITH_BOOST](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_boost)The location of the Boost library sources
[WITH_CLIENT_PROTOCOL_TRACING](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_client_protocol_tracing)Build client-side protocol tracing frameworkON
[WITH_CURL](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_curl)Location of curl library8.0.2
[WITH_DEBUG](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_debug)Whether to include debugging supportOFF
[WITH_DEFAULT_COMPILER_OPTIONS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_default_compiler_options)Whether to use default compiler optionsON
[WITH_DEFAULT_FEATURE_SET](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_default_feature_set)Whether to use default feature setON
[WITH_EDITLINE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_editline)Which libedit/editline library to usebundled
[WITH_ICU](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_icu)Type of ICU supportbundled8.0.4
[WITH_INNODB_EXTRA_DEBUG](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_innodb_extra_debug)Whether to include extra debugging support for InnoDB.OFF
[WITH_INNODB_MEMCACHED](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_innodb_memcached)Whether to generate memcached shared libraries.OFF
[WITH_KEYRING_TEST](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_keyring_test)Build the keyring test programOFF
[WITH_LIBEVENT](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_libevent)Which libevent library to usebundled
[WITH_LIBWRAP](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_libwrap)Whether to include libwrap (TCP wrappers) supportOFF
[WITH_LTO](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_lto)Enable link-time optimizerOFF8.0.13
[WITH_LZ4](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_lz4)Type of LZ4 library supportbundled
[WITH_LZMA](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_lzma)Type of LZMA library supportbundled8.0.4
[WITH_MECAB](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_mecab)Compiles MeCab
[WITH_MSAN](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_msan)Enable MemorySanitizerOFF
[WITH_MSCRT_DEBUG](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_mscrt_debug)Enable Visual Studio CRT memory leak tracingOFF
[WITH_MYSQLX](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_mysqlx)Whether to disable X ProtocolON8.0.11
[WITH_NUMA](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_numa)Set NUMA memory allocation policy
[WITH_PROTOBUF](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_protobuf)Which Protocol Buffers package to usebundled
[WITH_RAPID](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_rapid)Whether to build rapid development cycle pluginsON
[WITH_RAPIDJSON](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_rapidjson)Type of RapidJSON supportbundled8.0.13
[WITH_RE2](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_re2)Type of RE2 library supportbundled8.0.4
[WITH_SSL](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_ssl)Type of SSL supportsystem
[WITH_SYSTEMD](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_systemd)Enable installation of systemd support filesOFF
[WITH_SYSTEM_LIBS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_system_libs)Set system value of library options not set explicitlyOFF8.0.11
[WITH_TEST_TRACE_PLUGIN](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_test_trace_plugin)Build test protocol trace pluginOFF
[WITH_TSAN](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_tsan)Enable ThreadSanitizerOFF
[WITH_UBSAN](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_ubsan)Enable Undefined Behavior SanitizerOFF
[WITH_UNIT_TESTS](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_unit_tests)Compile MySQL with unit testsON
[WITH_UNIXODBC](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_unixodbc)Enable unixODBC supportOFF
[WITH_VALGRIND](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_valgrind)Whether to compile in Valgrind header filesOFF
[WITH_ZLIB](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_with_zlib)Type of zlib supportbundled
[WITH_xxx_STORAGE_ENGINE](file:///D:/refman-8.0-en.html-chapter/installing.html#option_cmake_storage_engine_options “Storage Engine Options”)Compile storage engine xxx statically into server

左佳明
关注
专栏目录
如何安装JRE（Java 运行环境）/ java运行环境JDE从官网下载网速很慢，有什么解决办法...
diwanmin2006的博客
09-13 2940
1. 点击如下链接进入官网：https://www.java.com/en/download/help/windows_offline_download.xml 点击 “ 手动下载 ” 2. 根据自己电脑选择32位或者64位点击下载 3. 下载完exe文件后，关闭所有应用程序，包括浏览器 双击保存的文件以开始安装过程。 安装过程开始。单击“安装”按钮...
如何在Windows上安装Java（JRE）更新？
cunjiu9486的博客
10-06 5407
Java is a programming language that is very popular amongst developers. In order to run Java applications Java Runtime Environment a.k.a. JRE should be installed. As new features come or security bugs...
KVM MYSQL 8.0.13 单机 FOR OEL7.5 通常安装文档
aming
11-09 357
2. 安装流程 2.1. 确定平台版本和机器位数。 确定当前MYSQL版本对应各种操作系统 平台是否支持。 https://www.mysql.com/support/supportedplatforms/database.html 2.2. 下载对应版本 2.2.1. 下载二进制安装包  官方网站  http://dev.mysql.com/downloads/mirrors.html. ...
KVM MYSQL 5.7 单机 FOR OEL7.5 通常安装文档
conghuozhu3793的博客
05-06 145
2. 安装流程 2.1. 确定平台版本和机器位数。 确定当前MYSQL版本对应各种操作系统...
Oracle Linux7.8配置本地yum源：报错Loaded plugins: ulninfo
君子不怨天的博客
04-27 2583
Linux配置本地yum源 1、将oracle-linux-ol7.repo配置文件备份 cp /etc/yum.repos.d/oracle-linux-ol7.repo /etc/yum.repos.d/oracle-linux-ol7.repo.bak #删除原文件： rm -rf /etc/yum.repos.d/oracle-linux-ol7.repo 2、编辑配置文件仅添加以下内容: vi /etc/yum.repos.d/oracle-linux-ol7.repo [ol7_lates
Docker安装
weixin_39568073的博客
07-01 119
cat /etc/redhat-release yum install -y yum-utils yum-config-manager --enable ol7_optional_latest yum install -y docker-engine yum-config-manager --enable ol7_addons yum install -y docker-engine yum install -y btrfs-progs yum inst..
mysql 8.0.13 解压版安装配置方法图文教程
12-16
mysql8版本没有默认的my.ini文件，需要手动创建，该文件建在解压后的根目录下，如：D:\Developer\mysql-8.0.13-winx64 该文件内容如下： [mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir=D:\\...
mysql8.0.13
12-25
MySQL 8.0更好支持文档型数据库和JSON 不可见索引，开始支持invisible index，在优化SQL的过程中可以设置索引为不可见，优化器不会利用不可见索引 支持降序索引，可以对索引定义 DESC，之前，索引可以被反序扫描...
CentOS7.5 rpm方式安装MySQL8.0.13.txt
05-09
CentOS7.5-x86 ,64位，二进制 rpm方式安装MySQL8.0.13详解！安装步骤简单明了，易上手，值得参考！
mysql 8.0.13手动安装教程
09-09
2018年发布的MySQL 8.0.13就是这样一个更新，它包含了许多新特性，比如对密码策略的增强、优化器的改进和文档化的数据字典等。本文将详细介绍如何在Windows环境下手动安装MySQL 8.0.13版本，这对于学习和掌握MySQL的...
JAVA工程师面试题目大全_绝对值得看
tanzhouxueyuan（JAVA交流群：432764060）的博客
05-16 9329
明天或者后天面试JAVA工程师怎么办？史上最全的全劲爆的JAVA工程师面试题，不得不看？本文集互联网全部的面试题，同时提供各大公司的面试题，助你增加面试成功机会
etmvc+jQuery EasyUI使用教程（二）
wangqiuyun的专栏
11-14 5433
本章我们来学习一下etmvc是如何访问数据库的。 etmvc中访问数据可以使用JDBC,HIBERNATE等，鉴于JDBC的烦琐和HIBERNATE的复杂，etmvc同时提供了一个ORM的简易实现版本ActiveRecord。在大多数中小型WEB系统中，使用ActiveRecord就足够了。 1、先将et-ar.jar, asm.jar, cglib.jar等包引入项目，当然还有mysql-c
Oracle的PL / SQL实用程序
whz110的专栏
07-12 265
This library is a collection of various utility packages for PL/SQL, as well as links to useful libraries hosted and maintained elsewhere. Generate PDF files using PL/SQL http://technology.ami...
MySQL8源代码安装（CentOS8版本）
最新发布
fxtxz2的专栏
01-18 2713
在CentOS8上面，进行MySQL8源码安装。
java 项目中常用的工具类总结
蠢蠢欲动的猫
04-25 1405
java 项目中常用的工具类总结
java.lang.NoClassDefFoundError: Could not initialize class com解决方案
热门推荐
w36680130的博客
01-06 4万+
本文转载自：https://www.cnblogs.com/liuyangfirst/p/6811937.html 作者：liuyangfirst 转载请注明该声明。编写的时候遇到这样一个bug,java.lang.NoClassDefFoundError: Could not initialize class com 纠结了两天多,但是,没有找到答案,这个问题的多方提示就是 (1)缺...
CentOS 7.5中ORACLE安装过程中遇到的问题及解决办法
zhongweill622的博客
08-16 2410
1.[root@esbapp ~]# xhost -bash: xhost: 未找到命令   要执行oracle数据库的图形化界面的安装，必须要安装xhost命令，否则安装过程无法进行下去  以下是解决方法：    https://www.cnblogs.com/xphdbky/p/8243008.html 2.oracle安装过程缺少依赖包  依赖包的网址 http://rpmfi...
unix mysql yum_yum localinstall 安装mysql8.0
weixin_30000735的博客
01-26 251
mysqld --initialize --consolemysqld --verbose --help初始化密码MySQL :: MySQL 8.0 Reference Manual :: 2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository https://dev.mysql.com/doc/refman/8.0/en/l...
CentOS7.5详细指南：RPM方式安装MySQL8.0.13
本文档详细介绍了在CentOS7.5-x86_64系统上，如何使用RPM包管理器来安装MySQL8.0.13的过程。内容包括从MySQL官方网站下载相应版本的安装包，检查并卸载可能存在的MariaDB以避免冲突，以及安装必要的依赖库。 在开始...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值