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

最新推荐文章于 2023-01-28 15:15:40 发布
最新推荐文章于 2023-01-28 15:15:40 发布
阅读量388 收藏
点赞数
分类专栏： 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

左佳明
关注
专栏目录
mysql 8.0.13 解压版安装配置方法图文教程
12-16
mysql8版本没有默认的my.ini文件，需要手动创建，该文件建在解压后的根目录下，如：D:\Developer\mysql-8.0.13-winx64 该文件内容如下： [mysqld] # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir=D:\\...
Oracle Linux7.8配置本地yum源：报错Loaded plugins: ulninfo
君子不怨天的博客
04-27 2590
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 120
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..
如何安装JRE（Java 运行环境）/ java运行环境JDE从官网下载网速很慢，有什么解决办法...
diwanmin2006的博客
09-13 2947
1. 点击如下链接进入官网：https://www.java.com/en/download/help/windows_offline_download.xml 点击 “ 手动下载 ” 2. 根据自己电脑选择32位或者64位点击下载 3. 下载完exe文件后，关闭所有应用程序，包括浏览器 双击保存的文件以开始安装过程。 安装过程开始。单击“安装”按钮...
java必备的官网链接
CDZAllier的博客
10-30 6086
小bai必备开发工具 idea工具官网下载 https://www.jetbrains.com/idea/download/#section=windows 注：这些官网有时是打不开的哟 小bai必备官方文档 Maven——apahce依赖管理（英文） https://mvnrepository.com/artifact/org.apache.httpcomponents 微信官方文档 https://developers.weixin.qq.com/doc/ Layui开发使用文档 h
如何在Windows上安装Java（JRE）更新？
cunjiu9486的博客
10-06 5439
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...
mysql 8.0.13手动安装教程
09-09
2018年发布的MySQL 8.0.13就是这样一个更新，它包含了许多新特性，比如对密码策略的增强、优化器的改进和文档化的数据字典等。本文将详细介绍如何在Windows环境下手动安装MySQL 8.0.13版本，这对于学习和掌握MySQL的...
CentOS7.5 rpm方式安装MySQL8.0.13.txt
05-09
CentOS7.5-x86 ,64位，二进制 rpm方式安装MySQL8.0.13详解！安装步骤简单明了，易上手，值得参考！
MySQL 8.0.13 下载安装教程图文详解
09-09
MySQL 8.0.13 是一款广泛应用的关系型数据库管理系统，尤其适合于网站开发和企业数据存储。在本文中，我们将详细讲解如何下载并安装这个版本的MySQL。 首先，访问MySQL官方网站...
Oracle12c+OEL7+RAC安装操作实例
05-05
Oracle Linux 7+Oracle 12c Rac安装操作实例，详细描述虚拟机环境下的每一步RAC搭建，可以比对前一篇11g的RAC搭建文档观察从操作系统到数据库的安装差异。
JAVA工程师面试题目大全_绝对值得看
tanzhouxueyuan（JAVA交流群：432764060）的博客
05-16 9345
明天或者后天面试JAVA工程师怎么办？史上最全的全劲爆的JAVA工程师面试题，不得不看？本文集互联网全部的面试题，同时提供各大公司的面试题，助你增加面试成功机会
JMeter性能测试系列一初识JMeter
最新发布
软件自动化测试技术交流、资源分享
01-28 149
Apache组织的Stefano Mazzocchi是JMeter项目的创始人。编写JMeter最初的目的是为了测试server的性能(后期被Tomcat替代)。随后，JMeter在Apache组织内部开始被其他项目所使用，并最终推广出来，成为独立的软件项目并不断更新，提高能力。
MySQL和MySQL驱动mysql-connector-java升级到8.0.X版本
热门推荐
AOBO516的专栏
06-22 5万+
目录 一、MySQL升级到8.0.X版本 1、升级的原因及MySQL8.0版本新特性 2、下载MySQL 3、备份数据 4、卸载原版本MySQL 5、安装下载的新版本。 6、MySQL升级后的兼容性问题 二、升级MySQL驱动mysql-connector-java升级到8.0.X版本 1、为什么要升级驱动版本 2、升级版本 3、修改配置 4、mysql-connector...
[JAVA EE] JPA 技术实践：完成增、删、改、查操作
Dust的博客
09-04 486
先看下效果： id是自动生成的，跳数了是因为之前删过数据 删除后 一些术语、概念 entity-dao-service-web层 准备工作 新建 Spring Boot 项目：jpademo2 MySQL数据库：还是testdb user表 添加相关依赖： pom.xml <!-- Spring Data JPA 依赖 --> <dependency> <groupId>org.springframework.b
etmvc+jQuery EasyUI使用教程（二）
wangqiuyun的专栏
11-14 5434
本章我们来学习一下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 267
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 2721
在CentOS8上面，进行MySQL8源码安装。
Java网页搭建--HTML入门
Java小白的自学之路
03-25 1557
HTML： 文档结构组成： 测试代码： <!DOCTYPE html> <html> <head> <meta charset = "UTF-8"> <title> html document</title> </head> <body> hello imooc ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值