How To Use Mariadb In Windows

MSI packages are available for both x86 (32 bit) and x64 (64 bit) processor architectures. We'll utilise screenshots from an x64 installation below (the 32 bit installer is very similar).

Contents

1. Installation UI
   1. Welcome
   2. License Agreement
   3. Custom Setup
   4. Database Authentication/Security Related Properties
   5. Other Database Properties
   6. Ready to Install
   7. End
2. New Entries in Start Card
3. Uninstall UI
4. Silent Installation
   1. Properties
   2. Features
   3. Silent Installation Examples
   4. Silent Uninstall
5. Installation Logs
6. Running 32 and 64 Bit Distributions on the Same Motorcar

Installation UI

This is the typical mode of installation. To start the installer, just click on the mariadb-<major>.<small-scale>.<patch>.msi

Welcome

License Agreement

Click on "I accept the terms"

Custom Setup

Here, you can choose what features to install. By default, all features are installed with the exception of the debug symbols. If the "Database instance" characteristic is selected, the installer will create a database instance, past default running as a service. In this case the installer will present additional dialogs to control diverse database properties. Note that y'all do not necessarily have to create an example at this stage. For instance, if you already have MySQL or MariaDB databases running as services, you can just upgrade them during the installation. Also, yous tin can create additional database instances afterward the installation, with the mysql_install_db.exe utility.

Annotation: Past default, if you install a database instance, the information directory will be in the "information" folder nether the installation root. To alter the data directory location, select "Database case" in the feature tree, and use the "Browse" button to point to another identify.

This dialog is shown if yous selected the "Database instance" characteristic. Here, yous tin gear up the countersign for the "root" database user and specify whether root tin access database from remote machines. The "Create anonymous account" setting allows for anonymous (non-authenticated) users. It is off by default and information technology is not recommended to change this setting.

Other Database Properties

• Install as service

• Defines whether the database should be run as a service. If information technology should be run as a service, then it as well defines the service name. It is recommended to run your database instance every bit a service as it profoundly simplifies database management. In MariaDB 10.iv and later, the default service name used by the MSI installer is "MariaDB". In ten.3 and earlier, the default service name used by the MSI installer is "MySQL". Note that the default service name for the --install and --install-transmission options for mysqld.exe is "MySQL" in all versions of MariaDB.

• Enable Networking

• Whether to enable TCP/IP (recommended) and which port MariaDB should listen to. If security is a concern, yous can change the bind-accost parameter post-installation to bind to only local addresses. If the "Enable networking" checkbox is deselected, the database will apply named pipes for advice.

• Optimize for Transactions

• If this checkbox is selected, the default storage engine is set to Innodb (or XtraDB) and the sql_mode parameter is set to "NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES". You can also ascertain the Innodb/Xtradb buffer pool size. The default buffer pool size is 12.five% of RAM and depending on your requirements you can requite innodb more than (up to 70-fourscore% RAM). 32 chip versions of MariaDB have restrictions on maximum buffer pool size, which is approximately 1GB, due to virtual address space limitations for 32bit processes.

Set to Install

At this point, all installation settings are collected. Click on the "Install" button.

End

Installation is finished now. If you lot accept upgradable instances of MariaDB/MySQL, running as services, this dialog will present a "Do you want to upgrade existing instances" checkbox (if selected, it launches the Upgrade Sorcerer post-installation).

If you installed a database instance as service, the service will exist running already.

Installation volition add some entries in the Get-go Menu:

• MariaDB Client - Starts control line client mysql.exe

• Command Prompt - Starts a command prompt. Environment is set such that "bin" directory of the installation is included into PATH environment variable, i.e y'all tin use this command prompt to outcome MariaDB commands (mysqldadmin, mysql etc...)

• Database directory - Opens the data directory in Explorer.

• Error log - Opens the database mistake log in Notepad.

• my.ini - Opens the database configuration file my.ini in Notepad.

• Upgrade Wizard - Starts the Wizard to upgrade an existing MariaDB/MySQL database instance to this MariaDB version.

Uninstall UI

In the Explorer applet "Programs and Features" (or "Add/Remove programs" on older Windows), find the entry for MariaDB, choose Uninstall/Change and click on the "Remove" button in the dialog below.

If yous installed a database instance, you volition need to make up one's mind if you want to remove or keep the data in the database directory.

Silent Installation

The MSI installer supports silent installations likewise. In its simplest form silent installation with all defaults can exist performed from an elevated command prompt like this:

          msiexec /i path-to-bundle.msi /qn        

Notation: the installation is silent due to msiexe.exe's /qn switch (no user interface), if you omit the switch, the installation will accept the full UI.

Properties

Silent installations also back up installation backdrop (a property would correspond for example to checked/unchecked land of a checkbox in the UI, user countersign, etc). With backdrop the command line to install the MSI package would look like this:

msiexec /i path-to-bundle.msi [PROPERTY_1=VALUE_1 ... PROPERTY_N=VALUE_N] /qn        

The MSI installer package requires belongings names to exist all capitals and contain simply English messages. By convention, for a boolean belongings, an empty value means "faux" and a non-empty is "truthful".

MariaDB installation supports the post-obit properties:

Features

Feature is a Windows installer term for a unit of measurement of installation. Features can be selected and deselected in the UI in the feature tree in the "Custom Setup" dialog.

Silent installation supports calculation features with the special holding ADDLOCAL=Feature_1,..,Feature_N and removing features with REMOVE=Feature_1,..., Feature_N

Features in the MariaDB installer:

Silent Installation Examples

All examples here require running equally administrator (and elevated command line in Vista and later)

• Install default features, database example every bit service, non-default datadir and port

  msiexec /i path-to-bundle.msi SERVICENAME=MySQL DATADIR=C:\mariadb5.two\information PORT=3307 /qn            

• Install service, add debug symbols, practise non add development components (client libraries and headers)

  msiexec /i path-to-packet.msi SERVICENAME=MySQL ADDLOCAL=DEBUGSYMBOLS REMOVE=DEVEL /qn

Silent Uninstall

To uninstall silently, apply the REMOVE=ALL property with msiexec:

msiexec /i path-to-packet.msi REMOVE=ALL /qn

To keep the data directory during an uninstall, y'all will demand to pass an boosted parameter:

msiexec /i path-to-package.msi REMOVE=ALL CLEANUPDATA="" /qn

Installation Logs

If y'all encounter a problems in the installer, the installer logs should exist used for diagnosis. Please attach verbose logs to the bug reports you create. To create a verbose installer log, start the installer from the command line with the /fifty*five switch, like so:

          msiexec.exe /i path-to-parcel.msi  /l*v path-to-logfile.txt        

Running 32 and 64 Fleck Distributions on the Same Machine

It is possible to install 32 and 64 bit packages on the same Windows x64.

Apart from testing, an example where this feature tin can exist useful is a development scenario, where users want to run a 64 scrap server and develop both 32 and 64 flake customer components. In this case the full 64 bit package can be installed, including a database instance plus development-related features (headers and libraries) from the 32 scrap packet.

Source: https://mariadb.com/kb/en/installing-mariadb-msi-packages-on-windows/

Posted by: mcquaiddeak1989.blogspot.com

Share this post