The Ultimate Guide to High Availability with MariaDB

Installation issues on Windows

Contents

  1. MariaDB 10.4.13
  2. Unsupported Versions of Windows
  3. MariaDB 5.2.5 and earlier
    1. On Windows Vista/7 , changes to database or my.ini are not persistent, when mysqld.exe is run from the command line.
  4. Systems with User Account Control

MariaDB 10.4.13

MariaDB 10.4.13 may not start on Windows. See MDEV-22555.

To resolve this, download, click and install https://aka.ms/vs/16/release/vc_redist.x64.exe and then install 10.4.13.

Unsupported Versions of Windows

Recent versions of MariaDB may not install on unsupported Windows versions. See Deprecated Package Platforms to find the final supported versions.

MariaDB 5.2.5 and earlier

On Windows Vista/7 , changes to database or my.ini are not persistent, when mysqld.exe is run from the command line.

The reason for this behavior is Vista/Win7 file system redirection. Writes to protected locations (in this case a subdirectory of Program Files) are redirected to the user's so-called "Virtual Store".

Workarounds:

  • Run mysqld.exe as service. See answer here on how to create a MariaDB service.
  • Run mysqld.exe from the elevated command prompt.
  • Change the ACL of the data directory and add full control for the current user.

The Windows installer for MariaDB 5.2.6 and higher will set the data directory ACL to include full access rights for the user who runs the setup to prevent this issue from happening.

Systems with User Account Control

Running mysql_install_db.exe from a standard command prompt might cause the error: 

FATAL ERROR: OpenSCManager failed

To get rid of it, use the elevated command prompt, for example on Windows 7 start it via 'Run as administrator' option.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.