Tutorial MariaDb (installation and usage) on Windows OS

on

Follow these steps :

* Download MariaDb as zip format: https://mariadb.org/mariadb/all-releases

* Choose version. In this case, I download and use v10.11.11

* After download completed, extract into specified path,

   for example D:\programs\mariadb-v10.11.11-p3307

* Create folder named: data

   inside D:\programs\mariadb-v10.11.11-p3307

* Now open/run CMD as Administrator

$ D: (enter)

$ cd D:\programs\mariadb-v10.11.11-p3307\bin (enter)


Install MariaDb

$ .\mariadb-install-db.exe --datadir=..\data --service=MariaDB-v10.11.11-p3307 --password=PswdPswdPswd19450817!($%)*!& --port=3307 --allow-remote-root-access --large-pages

Check Service MariaDb is running or not on Windows OS

$ sc query state= all | findstr "MariaDB-v10.11.11-p3307 MariaDB-v10.11.11-p3307 STATE"

Start Service MariaDb on Windows OS

$ sc start MariaDB-v10.11.11-p3307

Stop Service MariaDb on Windows OS

$ sc stop MariaDB-v10.11.11-p3307

Remove Service MariaDb on Windows OS

$ sc delete MariaDB-v10.11.11-p3307


If you want to change port and accessed by ip address tcp, edit my.ini

inside path D:\programs\mariadb-v10.11.11-p3307\data

[mysqld]

port = 3307

bind-address = 0.0.0.0


MariaDb LTS versions : 

v10.6, v10.11, v11.4

https://mariadb.com/kb/en/mariadb-server-release-dates/ 

 

MariaDb Storage Engines :

https://mariadb.com/kb/en/storage-engines/ 


MariaDb Choosing the Right Storage Engine :

https://mariadb.com/kb/en/choosing-the-right-storage-engine/


Source :

https://mariadb.com/kb/en/mariadb-install-db-exe/

https://stackoverflow.com/questions/12172997/how-to-collect-each-service-name-and-its-status-in-windows

https://git-maspaad.blogspot.com/2024/11/tutorial-install-mariadb-on-linux.html

Comments

Post a Comment