How to start MariaDB (or MySQL) server on a WSL using systemctl?
When I try to start MariaDB server (same problem with MySQL) on a fresh Debian 11 install in a Windows Subsystem Linux (WSL) I got the following error:
$ sudo systemctl start mariadb System has not been booted with systemd as init system (PID 1). Can't operate. Failed to connect to bus: Host is down
However the following command to enable MariaDB seems to work:
$ sudo systemctl enable mariadb Synchronizing state of mariadb.service with SysV service script with /lib/systemd/systemd-sysv-install. Executing: /lib/systemd/systemd-sysv-install enable mariadb
I've tried some things like adding
[boot] systemd=true to /etc/wsl.conf (find here) but the error persists.
I've tested with a fresh install of Debian WSL1 installed from the Microsoft Store (Debian GNU/Linux 11 bullseye) on a Windows 10 Professionnel (version 22H2) host and MariaDB installed with
sudo apt install mariadb-server.
I have exactly the same problem on a Ubuntu 22.04.2 LTS WSL1 and Fedora Linux 38 (Container Image) WSL1 (with MySQL), with both installed from the Microsoft Store.
I try to "set up a new (development) instance of Codidact/QPixel" on a WSL following this workflow.