Supported Windows Versions

Installation UI
Welcome
License Agreement
MSI packages for Mariadb are available starting with version 5.2.6. The packages are available for both x86 (2 bit! and x6" (6" bit! processor
architect#res. $e%ll #se screenshots fro& an x6" installation below (the 2 bit installer is ver' si&ilar!.
Important: (o&patibilit' with )SIS installers for 5.2.5 or earlier.
If 'o# install the MSI package for Maria*+ 5.2 on a &achine where 5.2.5 or earlier is installed, the MSI package will fail and tell 'o# to
#ninstall the older 5.2 version. This behavior is b' design. -o# can proceed b' #ninstalling 5.2.x witho#t worries. .xisting databases will not
be re&oved.
The Maria*+ MSI packages work on the following versions of $indows/
$indows 01
$indows 2ista
$indows 3
$indows 8
$indows Server 244
$indows Server 2448
$indows Server 2452
This is the t'pical &ode of installation. To start the installer, 6#st click on the &ariadb78&a6or9.8&inor9.8patch9.&si
:o&e ; <eso#rces ; =nowledge +ase ; Maria*+ ; Maria*+ *oc#&entation ; >etting Started ; >etting, Installing, and ?pgrading Maria*+ ;
Maria*+ +inar' 1ackages ; Installing Maria*+ MSI packages on $indows
Installing MariaDB MSI packages on Windows
Custom Setup
Database autentication!securit" related properties
(lick on @I accept the ter&s@
:ere, 'o# can choose what feat#res to install. +' defa#lt, all feat#res are installed with the exception of the deb#g s'&bols. If the @*atabase
instance@ feat#re is selected, the installer will create a database instance, b' defa#lt r#nning as a service. In this case the installer will present
additional dialogs to control vario#s database properties. )ote that 'o# do not necessaril' have to create an instance at this stage. Aor exa&ple, if
'o# alread' have M'SBC or Maria*+ databases r#nning as services, 'o# can 6#st #pgrade the& d#ring the installation. Dlso, 'o# can create
additional database instances after the installation, with the mysql_install_db.exe #tilit'.
#$%&/ +' defa#lt, if 'o# install a database instance, the data director' will be in the @data@ folder #nder the installation root. To change the
data director' location, select @*atabase instance@ in the feat#re tree, and #se the @+rowse@ b#tton to point to another place.
$ter database properties
'ead" to Install
This dialog is shown if 'o# selected the @*atabase instance@ feat#re. :ere, 'o# can set the password for the @root@ database #ser and specif'
whether root can access database fro& re&ote &achines. The @(reate anon'&o#s acco#nt@ setting allows for anon'&o#s (non7a#thenticated!
#sers. It is off b' defa#lt and it is not reco&&ended to change this setting.
Install as service
*efines if the database sho#ld be r#n as a service and the service na&e. It is reco&&ended to r#n 'o#r database instance as a service as it
greatl' si&plifies database &anage&ent. The defa#lt service na&e is @M'SBC@, for co&patibilit' reasons (this is the sa&e na&e that
@ mysqld.exe install @ wo#ld choose too!.
.nable networking
$hether to enable T(1EI1 (reco&&ended! and which port Maria*+ sho#ld listen to. If sec#rit' is a concern, 'o# can change the @bind7address@
para&eter post7installation to bind to onl' local addresses. If the @.nable networking@ checkbox is deselected, the database will #se na&ed pipes
for co&&#nication.
Fpti&iGe for transactions
If this checkbox is selected, the defa#lt storage engine is set to Innodb (or 0tra*+! and the sql_mode para&eter is set to
@ NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABES @. -o# can also define the InnodbE0tradb b#ffer pool siGe. The defa#lt b#ffer pool siGe is 52.5H
of <DM and depending on 'o#r reI#ire&ents 'o# can give innodb &ore (#p to 34784H <DM!. 2 bit versions of Maria*+ have restrictions on
&axi&#& b#ffer pool siGe, which is approxi&atel' 5>+, d#e to virt#al address space li&itations for 2bit processes.
User account control (UAC) popup
&nd
#ew entries in Start Menu
Dt this point, all installation settings are collected. (lick on the @Install@ b#tton.
If #ser acco#nt control is enabled (2ista or later!, 'o# will see this dialog. (lick on @-es@.
Installation is finished now. If 'o# have #pgradable instances of Maria*+EM'SBC, r#nning as services, this dialog will present a @*o 'o# want to
#pgrade existing instances@ checkbox (if selected, it la#nches the ?pgrade $iGard post7installation!.
If 'o# installed a database instance as service, the service will be r#nning alread'.
Installation will add so&e entries in the Start Men#/
Uninstall UI
M'SBC (lient 7 Starts co&&and line client &'sIl.exe
(o&&and 1ro&pt 7 Starts a co&&and pro&pt. .nviron&ent is set s#ch that @bin@ director' of the installation is incl#ded into 1DT: environ&ent
variable, i.e 'o# can #se this co&&and pro&pt to iss#e Maria*+ co&&ands (&'sIldad&in, &'sIl etc...!
*atabase director' 7 Fpens the data director' in .xplorer.
.rror log 7 Fpens the database error log in )otepad.
&'.ini 7 Fpens the database config#ration file &'.ini in )otepad.
?pgrade $iGard 7 Starts the $iGard to #pgrade an existing Maria*+EM'SBC database instance to this Maria*+ version.
In the .xplorer applet @1rogra&s and Aeat#res@ (or @DddE<e&ove progra&s@ on older $indows!, find the entr' for Maria*+, choose
?ninstallE(hange and click on the @<e&ove@ b#tton in the dialog below.
If 'o# installed a database instance, 'o# will need to decide if 'o# want to re&ove or keep the data in the database director'.
Silent installation
*roperties
+eatures
Silent installation e,amples
The MSI installer s#pports silent installations as well. In its si&plest for& silent installation with all defa#lts can be perfor&ed fro& an elevated
co&&and pro&pt like this/
msiexe! "i #at$to#a!%a&e.msi "qn
#ote: the installation is silent d#e to &siexe.exe%s EIn switch (no #ser interface!, if 'o# o&it the switch, the installation will have the f#ll ?I.
Silent installations also s#pport installation properties (a propert' wo#ld correspond for exa&ple to checkedE#nchecked state of a checkbox in the ?I,
#ser password, etc!. $ith properties the co&&and line to install the MSI package wo#ld look like this/
msiexe! "i #at$to#a!%a&e.msi '(RO(ERT)_*+,AUE_* ... (RO(ERT)_N+,AUE_N- "qn
The MSI installer package reI#ies propert' na&es to be all capitals and contain onl' .nglish letters. +' convention, for a boolean propert', an
e&pt' val#e &eans @false@ and a non7e&pt' is @tr#e@.
Maria*+ installation s#pports following properties/
*ropert" name De-ault .alue Description
I)STDCC*I<
H1rogra&AilesHJMaria*+
8version9J
Installation root
1F<T 46 77port para&eter for the server
DCCF$<.MFT.<FFTD((.SS Dllow re&ote access for root #ser
+?AA.<1FFCSIK. <DME8 +#fferpoolsiGe for innodb
(C.D)?1*DTD 5 <e&ove the data director' (#ninstall onl'!
*DTD*I< I)STDCC*I<Jdata Cocation of the data director'
*.AD?CT?S.< Dllow anon'&o#s #sers
1DSS$F<* 1assword of the root #ser
S.<2I(.)DM. )a&e of the $indows service. D service is not created if this val#e is e&pt'.
S=I1).T$F<=I)> Skip networking
ST*(F)AI> 5
(orresponds to @opti&iGe for transactions@ in the >?I, defa#lt engine innodb,
strict sIl &ode
?TA8 if set, adds character7set7serverL#tf8 to &'.ini file (added in Maria*+ 5.5.2M!
Feature is a $indows installer ter& for a #nit of installation. Aeat#res can be selected and deselected in the ?I in the feat#re tree in the @(#sto&
Set#p@ dialog.
Silent installation s#pports adding feat#res with the special propert' A..OCA+/eat01e_*,..,/eat01e_N and re&oving feat#res with
RE2O,E+/eat01e_*,..., /eat01e_N
Aeat#res in the Maria*+ installer/
+eature id Installed b" de-ault/ Description
*+Instance 'es Install database instance
(lient 'es (o&&and line client progra&s
M-SBCS.<2.< 'es Install server
*eb#g+inaries 'es Install &'sIld7deb#g, and deb#g versions of client libraries
SharedCibraries 'es Install client shared librar'
*.2.C 'es install (E(NN header files and client libraries
.&bedded no e&bedded server librar'
*.+?>S-M+FCS no install deb#g s'&bols
Dll exa&ples here reI#ire r#nning as ad&inistrator (and elevated co&&and line in 2ista and later!
Install defa#lt feat#res, database instance as service, non7defa#lt datadir and port
Silent uninstall
Installation logs
'unning 01 and 23 bit distributions on te same macine4
msiexe! "i #at$to#a!%a&e.msi SER,ICENA2E+2yS3 .ATA.IR+C45ma1iadb6.75data (ORT+889: "qn
Install service, add deb#g s'&bols, do not add develop&ent co&ponents (client libraries and headers!
msiexe! "i #at$to#a!%a&e.msi SER,ICENA2E+2yS3 A..OCA+.EBUGS)2BOS RE2O,E+.E,E "qn
To #ninstall silentl', #se the RE2O,E+A propert' with &siexec/
msiexe! "i #at$to#a!%a&e.msi RE2O,E+A "qn
To keep the data director' d#ring an #ninstall, 'o# will need to pass an additional para&eter/
msiexe! "i #at$to#a!%a&e.msi RE2O,E+A CEANU(.ATA+;; "qn
If 'o# enco#nter a b#g in the installer, the installer logs sho#ld be #sed for diagnosis. 1lease attach logs to the b#g reports 'o# create. To create an
installer log, start the installer fro& the co&&and line with the "l switch, like so/
msiexe!.exe "i #at$to#a!%a&e.msi "l #at$tolo&<ile.txt
It is possible to install 2 and 6" bit packages on the sa&e $indows x6".
Dpart fro& testing, an exa&ple where this feat#re can be #sef#l is a develop&ent scenario, where #sers want to r#n a 6" bit server and develop
both 2 and 6" bit client co&ponents. In this case the f#ll 6" bit package can be installed, incl#ding a database instance pl#s develop&ent7related
feat#res (headers and libraries! fro& the 2 bit package.
O Installing Maria*+ <1M Ailes P Maria*+ +inar' 1ackages P Installing Maria*+ $indows KI1 packages Q
Comments
No comments
R 245 7 245" Sk'SBC (orporation Db. Sk'SBC and Maria*+ are trade&arks or registered trade&arks of Sk'SBC (orporation Db in the .#ropean ?nion and ?nited States of
D&erica andEor other co#ntries. M'SBC is a trade&ark of Fracle (orporation Inc. Trade&arks State&ent