The Ultimate Guide to High Availability with MariaDB

Installation issues on Windows

You are viewing an old version of this article. View the current version here.

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 subdirectory of Program Files) are redirected to so-called user's Virtual Store.

Workarounds:

  • Start mysqld.exe as service.
  • Run mysqld.exe from the elevated command line
  • Change ACL of the data directory and add full access for the current user.

Installer for MariaDB 5.2.6 and higher will set data directory ACL to include full access rights for the user who runs the setup, so that this issue is not likely to happen.

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.