MariaDB

MariaDB on Windows

Basics

Download MariaDB Windows ZIP package (mariadb-12.3.2-winx64.zip)
Extract package, then create a new folder called mariadb in the root of your C: disk.
Copy extracted MariaDB folder to C:\mariadb.

Start PowerShell, change directory to C:\mariadb\mariadb-12.3.2-winx64\bin
Run command:

./mysql_install_db.exe --datadir=C:\mariadb\mariadb-12.3.2-winx64\data --port=3306

This generates a my.ini configuration file that's saved in the data directory (C:\mariadb\mariadb-12.3.2-winx64\data)

Start up MariaDB server (from the C:\mariadb\mariadb-11.4.2-winx64\bin directory):

./mysqld --console

If a prompt is displayed, asking you to allow network access, select the private network option and click OK.

Start another instance of PowerShell, change directory to C:\mariadb\mariadb-12.3.2-winx64\bin
Run command:

./mysql -u root

At this point, no root password is set so you can log on without providing one.

At the MariaDB command prompt, run the command show databases;

You should see this:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.00 sec)

Set a password for the root account

NOTE: In the following example command, you should replace password with a password of your own.
At the MariaDB command prompt, run this command:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
Next time you're about to log in on the MariaDb server, run this command:
./mysql -u root -p
Then, when asked for a password, type the one you created for the root account.

To log out of the MariaDB server, at the MariaDB command prompt, run the command exit;

Once logged out, close the active PowerShell window.

To shut down the MariaDB server, make the other PowerShell window active and then press Ctrl C

To top