Shulou(Shulou.com)06/01 Report--

Operating system: windows server 2012 R2

VS version: visio studio 2015 community

Machine configuration: 4core/4G

Install the required package: cmake,bison,boost,activeperl, the following is the specific version

Cmake-3.15.0-rc3-win64-x64.msi

Boost_1_59.zip (note that the boost version corresponds to the mysql version, and there will be an error message in cmake about which version)

Activeperl.exe

Bison-2.4.1-setup.exe

Related url:

Https://www.boost.org/users/history/version_1_59_0.html

Https://www.qqxiazai.com/down/12006.html#download_addr

Http://gnuwin32.sourceforge.net/packages/bison.htm

Be sure to take the official website description as the king, the official website address, it is best to download MySQL 5.7Reference Manual, this is the most authoritative and comprehensive information of MySQL, reading Chinese materials may have some confusion, and then reading the MySQL reference manual can suddenly enlighten

In addition, if mysql is downloaded from the official website, you can download source code.

Many blogs are required to install Bison, but I have no problem installing Bison. It is very clear in the MySQL5.7 reference manual that using Standard Source Distribution to build projects does not require Bison, but using Development Source Tree requires Bsion. The standard version of the source code ZIP package downloaded directly from the official website is Standard Source Distribution, and the latest development source code downloaded from GitHub is Development Source Tree.

The version I downloaded here on the official website is mysql-5.7.26.zip.

Installation:

Run the installation cmake,activeperl,bison directly, and then extract the boost to a folder without Chinese characters and spaces.

After installing bison, you need to manually add the bison installation directory to the system's environment variables.

C:\ Program Files (x86)\ GnuWin32\ bin

Install visio studio 2015

Generate VS2015 MySQL project

Extract the mysql source code, run cmake-gui, select the source code that needs to be compiled, and the destination directory.

Where is the source code: select the decompressed source code

Where to build to the binaryies: select the destination directory. Here we select the mysql directory under disk C.

That is:

Source code directory: C:/Users/chengbin.liu/Desktop/mysql-5.7.26

Prepare a folder for Build (there can be no Chinese and spaces in the path), and the folder is in C:/mysql

Next, you need to configure the boost library. Click Add Entry to add the boost library configuration item.

Name: WITH_BOOST

Type Select PATH

Value: select the installation directory of the boost library in the first step

After clicking ok, next we click Configure to select the target VS version

After clicking Finish, it will take some time to wait for the run to finish.

Then click configure

End of Configure:

Click Generate to generate VS2015 Project.

Directly click the "open_project" button to call VS2015 to open the project (or enter the build directory, double-click the project file of ALL_BUILD to call VS2015 to open the project)

Compile:

Select ALL_BUILD right-click generation under the rightmost solution.

If there is no error, wait for the compilation to finish. (a long wait)

Congratulations on the successful compilation when you see the following output from the console

You need to initialize the MySQL database before debugging MySQL, otherwise it will report that the mysql.user table does not exist.

The simplest initialization method:

Before VS starts debugging, run mysqld with VS to initialize a default database instance. The debug mysqld subproject must be set to start the project.

Right-click on mysqld-> attribute

-initialize-explicit_defaults_for_timestamp

Debug-> command parameters

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.