Building MariaDB on Windows
Contents
Build Requirements
To build MariaDB you need the following:
- Visual C++: We currently support Visual Studio 2017 and 2019. Generally we try to support the two most recent VS versions, but build ourselves using the last one. Community editions will work fine; we only use them in our builds. While installing Visual Studio, make sure to add "Desktop Development with C++".
- CMake: We recommend the latest release. Older releases might not support your version of Visual Studio. Visual Studio 2019 requires cmake 3.14 at least.
- Git: Required to
build newer versions from the source tree.
- NOTE: run
git config --global core.autocrlf input
after the installation, otherwise some mtr tests will fail
In the "Adjusting your PATH" dialog, choose "Use Git from Windows command prompt", otherwise wrong (mingw64) git and perl will be in your PATH
- Bison from GnuWin32:
Bison creates parts of the SQL parser. Choose "Complete package except
sources" when downloading.
- NOTE: Do not install this into your default path with spaces
(e.g. under
C:\Program Files\GnuWin32
); the build will break due to this bison bug. Instead, install intoC:\GnuWin32
. - Add
C:\GnuWin32\bin
to your systemPATH
after installation.
- NOTE: Do not install this into your default path with spaces
(e.g. under
- Strawberry perl: Used to run the test suite. ActiveState Perl is another Win32 Perl distribution and should work as well (but it is not as well tested).
- Optional: If you intend to build the MSI packages, install Windows Installer XML version 3.9 or higher
- Gnu Diff, needed if you run mysql-test-run.pl tests.
Verify that bison.exe, bzr.exe or git.exe, cmake.exe and perl.exe can be found in the PATH
environment variable with "where bison
", "where git
", "where perl
" etc. from
the command line prompt.
Building Windows Binaries
The above instructions assume MariaDB 5.5 or higher.
Branch the MariaDB bzr repository, or unpack the source archive. On the command prompt, switch to your source directory, then execute:
mkdir bld cd bld cmake .. cmake --build . --config RelWithDebInfo
The above example builds a release configured for 32 bit systems in a
subdirectory named bld
. "cmake ...
" is the configuration step,
"cmake --build . --config Relwithdebinfo
" is the build step.
Build Variations
Debug Builds
Building Debug version is done with:
cmake --build . --config Debug
32bit and 64 bit Builds
Build 64 bit binary
Visual Studio 2019 cmake generator will use host architecture by default, that is, with the steps above, cmake will build x64 binaries on x64 machine.
Visual Studio 2017 cmake generator will create 32 bit projects by default. For 64 bit, you must pass CMake the "generator" parameter using -G in the configuration step, e.g.:
cmake .. -G "Visual Studio 15 2017 Win64"
Build 32 bit binary
With Visual Studio 2019, pass -A Win32 parameter for CMake, like this
cmake .. -A Win32
With Visual Studio 2017, use corresponding 32bit generator
cmake .. -G "Visual Studio 15 2017"
For a complete list of available generators, call "cmake" without any parameters.
IDE Builds
Instead of calling "cmake --build
" as above, open MySQL.sln
. When Visual Studio starts, choose Build/Compile.
Building the ZIP Package
cmake --build . --config relwithdebinfo --target package
Building the MSI Package
cmake --build . --config relwithdebinfo --target MSI
Including HeidiSQL in the MSI Installer
Starting with MariaDB 5.2.7, it is possible to build an installer which
includes 3rd party products, as described in
MWL#200. Currently only
HeidiSQL support is implemented; it is also
included in the official builds. Use the CMake parameter
-DWITH_THIRD_PARTY=HeidiSQL
to include it in the installer.
Code Signing Support for MariaDB Release Processing
MariaDB builds optionally support authenticode code signing with an optional
parameter SIGNCODE
. Use cmake -DSIGNCODE=1
during the
configuration step to sign the binaries in the ZIP
and MSI
packages.
Important: for SIGNCODE=1
to work, the user that runs the build needs to
install a valid authenticode digital certificate into their certificate store,
otherwise the packaging step will fail.
Building Packages for MariaDB Releases
The full script to create the release in an out-of-source build with Visual Studio with signed binaries might look like:
mkdir bld cd bld cmake .. -DSIGNCODE=1 -DWITH_THIRD_PARTY=HeidiSQL cmake --build . --config relwithdebinfo --target win_package cmake --build . --config relwithdebinfo --target MSI
This command sequence will produce a ZIP package (e.g mariadb-5.2.6-win32.zip)
and MSI package (e.g mariadb-5.2.6-win32.msi) in the bld
directory.