Correct MySQL kernel compilation procedure

Compiling the MySQL kernel is often used. The following articles mainly introduce the correct method for compiling the MySQL kernel. If you are curious about compiling the MySQL kernel technology, the following articles will unveil its mysteries. I hope it will help you in this regard. Keywords: MySQL kernel Database Security Configuration User Authentication Module password recovery

Compiling the MySQL kernel is often used. The following articles mainly introduce the correct method for compiling the MySQL kernel. If you are curious about compiling the MySQL kernel technology, the following articles will unveil its mysteries. I hope it will help you in this regard. Keywords: MySQL kernel Database Security Configuration User Authentication Module password recovery

Compiling the MySQL kernel is often used. The following articles mainly introduce the correct method for compiling the MySQL kernel. If you are curious about compiling the MySQL kernel technology, the following articles will unveil its mysteries. I hope it will help you in this regard.

Keywords: MySQL kernel Database Security Configuration User Authentication Module password restoration Stored Procedure writing database index

Summary:

In the latest version, a set of code is used in windows and linux. This article takes the mysql-5.1.7 as the analysis object, explains in detail the method of compiling MySQL kernel.

In the latest version, a set of code is used in windows and linux. For example, the description of the INSTALL-WIN-SOURCE file in the mysql-6.0.4-alpha version:

 
 

  
  
TobuildMySQLonWindowsfromsource,youmustsatisfythe 
  
  
followingsystem,compiler,andresourcerequirements: 
  
  
*Windows2000,WindowsXP,ornewerversion.WindowsVistais 
  
  
notsupporteduntilMicrosoftcertifiesVisualStudio2005on 
  
  
Vista. 
  
  
*CMake,whichcanbedownloadedfromhttp://www.cmake.org. 
  
  
Afterinstalling,modifyyourpathtoincludethecmake 
  
  
binary. 
  
  
*MicrosoftVisualC++2005ExpressEdition,VisualStudio.Net 
  
  
2003(7.1),orVisualStudio2005(8.0)compilersystem. 
  
  
*IfyouareusingVisualC++2005ExpressEdition,youmust 
  
  
alsoinstallanappropriatePlatformSDK.Moreinformationand 
  
  
linkstodownloadsforvariousWindowsplatformsisavailable 
  
  
fromhttp://msdn.microsoft.com/platformsdk/. 
  
  
*IfyouarecompilingfromaBitKeepertreeormakingchanges 
  
  
totheparser,youneedbisonforWindows,whichcanbe 
  
  
downloadedfrom 
  
  
http://gnuwin32.sourceforge.net/packages/bison.htm.Download 
  
  
thepackagelabeled"Completepackage,excludingsources". 
  
  
Afterinstallingthepackage,modifyyourpathtoincludethe 
  
  
bisonbinaryandensurethatthisbinaryisaccessiblefrom 
  
  
VisualStudio. 
  
  
*Cygwinmightbenecessaryifyouwanttorunthetestscript 
  
  
orpackagethecompiledbinariesandsupportfilesintoaZip 
  
  
archive.(Cygwinisneededonlytotestorpackagethe 
  
  
distribution,nottobuildit.)Cygwinisavailablefrom 
  
  
http://cygwin.com. 
  
  
*3GBto5GBofdiskspace. 
 
 

In this way, the project file can be generated and compiled using the vs tool. .

For details about how to compile the MySQL kernel, I chose 5.1.7 as the analysis object.

Steps for installing the Code:

1.decompress the package mysql-5.1.7-beta-win-src.zip.

2. Use vs2003 to open the project file mysql. sln.

3. Set the mysqld project as the startup project.

4. On the properties page of mysqld, set the command parameter to -- console. In this way, you can debug the code in debug mode.

Configure Command Parameters

5. set breakpoints. For example, the total query entry is the handle_select function.

6.compile the mysqlproject and generate mysql.exe in the mysql-5.1.7-betaclient_debugdirectory.

7. Use "Start new instance" or "go to single step to execute new instance" for debugging.

Perform debugging

8. mysql-5.1.7-betaclient_debugdirectory to generate mysql.exe. The execution statement will be executed at the breakpoint for debugging.

Enter the debugging status

9. For the corresponding data file, see the mysql-5.1.7-betadata directory.

The above content describes how to compile the MySQL kernel in detail, hoping to help you in this regard.