Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Comments on How to start MariaDB (or MySQL) server on a WSL using systemctl?

Parent

How to start MariaDB (or MySQL) server on a WSL using systemctl?

+1
−0

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.

Set up

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.

Context

I try to "set up a new (development) instance of Codidact/QPixel" on a WSL following this workflow.

History
Why does this post require attention from curators or moderators?
You might want to add some details to your flag.
Why should this post be closed?

0 comment threads

Post
+3
−0

As the error says, WSL doesn't boot using systemd in the same way a native Debian install does, so you can't use systemctl either. The answer is simply to use service instead, which doesn't rely on systemd:

sudo service mysql start
History
Why does this post require attention from curators or moderators?
You might want to add some details to your flag.

1 comment thread

Follow-up error: start failed (1 comment)
Follow-up error: start failed
zetyty‭ wrote over 1 year ago · edited over 1 year ago

The start "failed" with this command... I had to remove completely mariadb-server and follow this workflow: create /etc/mysql/my.cnf and/etc/mysql/debian-start files with default contents and then sudo chmod 755 /etc/mysql/debian-start. Now it works fine...