Skip to content

Instantly share code, notes, and snippets.

@ebta
Last active January 10, 2021 14:24
Show Gist options
  • Save ebta/ce0775a4b659274569102119b69d864c to your computer and use it in GitHub Desktop.
Save ebta/ce0775a4b659274569102119b69d864c to your computer and use it in GitHub Desktop.
Install Minimalist Portable MariaDB 10.4 in Windows 10

General Step (MariaDB Up to 10.4)

Speaking of MariaDB, it is 2 files and 3 directories.

Layout is like this:

  1. bin\mysqld.exe
  2. share\english\errmsg.sys # you can take it from share\english in normal installation or ZIP
  3. data # an empty directory you can start with
bin\mysqld.exe --console --skip-grant-tables  

(last parameter is essential, as you do not have system tables).

It is missing system tables, if you need to create them, this will be a couple of more files.

this tool helps https://mariadb.com/kb/en/mariadb/mysql_install_dbexe/ . mysqld_install_db.exe needs to be placed next to mysqld.exe and then you can create system tables with

mysql_install_db.exe --datadir=C:\your\path\to\data --password=SecretPswd123 --port=3307

UPDATE MariaDB 10.5.3 and later

  1. bin\mysqld.exe
  2. bin\server.dll
  3. bin\mysql_install_db.exe (optional, run once to create data directory, can be removed afterwards)
  4. data Changes compared to the previous versions : server.dll is new (mysqld.exe needs it), errmsg.sys is no more needed

https://stackoverflow.com/a/43163415

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment