Derek Coleman & Associates Inc logoDerek Coleman & Associates Inc

Home / Support / MariaDB 11.4 on Ubuntu 24.04 LTS

MariaDB 11.4 on Ubuntu 24.04 LTS — Support & Quick Start

Production-ready MariaDB 11.4 LTS on Ubuntu 24.04. Drop-in MySQL-compatible database with a per-VM generated root password.

Fixed on image version 2026.916.1341 (published 2026-09-16)

First boot now authenticates its own `FLUSH PRIVILEGES` (it used to run unauthenticated and die with ERROR 1045), verifies `root` against the running server and only then writes /root/.mariadb-initial-password and the completion marker. The password survives reboots.

If you deployed this VM before 2026-09-16, it came from the older image and is not changed by the new publication — redeploy from the current Marketplace version, or apply the one-time repair below:

  1. On that image the root password in /root/.mariadb-initial-password applies on the FIRST boot only. If this VM has never been rebooted the file still holds the live password: sign in now with `mariadb -u root -p` and store it safely.
  2. Stop the old first-boot script from regenerating a password it can no longer apply, by writing the completion marker it failed to write (taken from the fixed script, not sweep-run).
  3. Already rebooted and the password was never stored? Reset root with MariaDB's documented `--init-file` procedure, or email support and we will walk you through it. MariaDB itself is running normally throughout.
sudo mkdir -p /etc/app && sudo touch /etc/app/.firstboot-complete

Image change: see the pull request.

Source: the Marketplace live version set for this offer, read from Partner Center on 2026-09-16. New deployments take the newest version by default.

At a glance

Application ports3306 (MariaDB)
Admin credential filesudo cat /root/.mariadb-initial-password
Sign in asroot (root@localhost, password auth)
Service(s)mariadb
Configuration/etc/mysql/mariadb.conf.d/50-server.cnf (bind-address)
Logsjournalctl -u mariadb -f; /var/log/mysql/error.log
VersionMariaDB 11.4 LTS (MariaDB repository)
PlatformUbuntu 24.04 LTS

Quick start

  1. SSH into the VM with the username and key you chose at deploy.
  2. MariaDB runs as the `mariadb` systemd service on port 3306; the in-image ufw allows 3306, the NSG does not until you open it.
  3. Connect locally with `mariadb -u root -p` using the generated password (command below), create your application user and schema, then open 3306 to your app tier only.

First login / credentials

This image generates its admin credential on the VM at first boot — nothing is pre-set. SSH into the VM with the username + key you chose at deploy, then print the generated credential:

ssh <your-username>@<VM-IP>
sudo cat /root/.mariadb-initial-password

Sign in as root (root@localhost, password auth).

  1. Print the generated root password from the file.
  2. Connect locally: mariadb -u root -p (plain `sudo mariadb` is refused — root is switched to password auth at first boot).
  3. Create your application user and schema, change the root password (ALTER USER), and delete the file.

This is the MariaDB root password set at first boot (root@localhost is switched to password auth, so plain `sudo mariadb` is refused). Connect with `mariadb -u root -p`, change it with ALTER USER, and delete the file once stored securely.

Still stuck?

Email support@dcassociatesgroup.com (response within 1 business day) or send a message via the contact form. Include the offer name, VM size, region, and any log output — sudo journalctl -u <service> -n 100 usually tells the story.