build MYSQL source code Using visual studio 2017

https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html

xiaai cmake-3.15.6-win64-x64.msi

https://cmake.org/download/

XIAZAI https://slproweb.com/products/Win32OpenSSL.html WIN64 版本

安装 OpenSSL-Win64到PATH D:mysqlsourcemysql-server-8.0_2mysql-server-8.0cmakeOpenSSL-Win64

设置环境变量 OPENSSL_ROOT_DIR: D:mysqlsourcemysql-server-8.0_2mysql-server-8.0cmakeOpenSSL-Win64

下载安装 BISON 安装路径 C:GnuWin32 ，C:GnuWin32in 添加至环境变量 PATH

https://sourceforge.net/projects/gnuwin32/files/bison/2.4.1/bison-2.4.1-setup.exe/download?use_mirror=nchc

开启 vs 2015 DEVELOPER CMD

CD D:mysqlsourcemysql-server-8.0_2mysql-server-8.0cmake

cmake .. -G "Visual Studio 14 2015 Win64" -DDOWNLOAD_BOOST=1 -DWITH_BOOST=boostdir -DOPENSSL_ROOT_DIR=OpenSSL-Win64 -DOPENSSL_LIBRARIES=OpenSSL-Win64/lib

--defaults-extra-file=D:mysqlsourcemysql-server-8.0mysql-server-8.0ldsqlmy.ini --user=mysql --datadir=D:mysqlsourcemysql-server-8.0mysql-server-8.0ldsqldata

CD D:mysqlsourcemysql-server-8.0_2mysql-server-8.0cmake untime_output_directoryDebug

mysqld --initialize-insecure

mysqld -u root --port=33066

https://dev.mysql.com/doc/refman/8.0/en/connecting.html

mysql --host=localhost --user=myname --password=password mydb

mysql --host=remote.example.com --port=13306

以特定的port启东MYSQL

mysqld --initialize-insecure

mysqld -u root --port=33066

D:mysqlsourcemysql-server-8.0mysql-server-8.0ld untime_output_directoryDebugmysql --host=localhost --user=root --password --port=33066

How can you find out which process is listening on a port on Windows?

netstat -a -b

https://www.cloudinsidr.com/content/how-to-install-the-most-recent-version-of-openssl-on-windows-10-in-64-bit/

https://slproweb.com/products/Win32OpenSSL.html

It is a common misunderstanding: CMake does not need environment variables to know where the library and include dir are but CMake variables.

Since CMake can not find your OpenSSL lib and include directory, you will have to manually tell him where they are with its command line when you call it. Use the option -D to set constants in CMake from the command line. You will need to set the constants OPENSSL_ROOT_DIR and OPENSSL_LIBRARIES since they are the one triggering the error.

cmake -DOPENSSL_ROOT_DIR=/usr/local/ssl -DOPENSSL_LIBRARIES=/usr/local/ssl/lib

如何在本地调试mysqlY源码
1，cd D:mysqlsourcemysql-server-8.0mysql-server-8.0ld
untime_output_directoryDebug
2,  start command by ：mysqld -u root --port=33066 --datadir=D:mysqlsourcemysql-server-8.0mysql-server-8.0ldsqldata
3 OPEN VS AND ATTACH THE PROCESS mysqld

4，OPEN new COMMAND  AND TYPE : mysql --host=localhost --user=root  --port=33066

4，show databases;