MariaDB for Ubuntu 24.04 Server

Automated Bash installer script for deploying MariaDB on Ubuntu 24.04 Server using socket authentication for the root account and creating a dedicated local-only admin user supplied at runtime.

This is a production-focused installer, not a demo.

Preparing

Update your package index before running the installer:

sudo apt update -y

Download the Script

Clone the repository from your Git server:

git clone https://git.x-files.dk/database-server/mariadb-ubuntu.git

cd mariadb-ubuntu

Usage

Run the script with your chosen admin username and password:

sudo ./mariadbinstall -u <adminuser> -p <password>

Example

sudo ./mariadbinstall -u mydbuser -p "StrongPassword123"

Important

Always enclose the password in quotes if it contains special characters such as $, !, or &.

Notes

No mysql_secure_installation needed — this scipt is performing the equivalent hardening.
The created admin user is restricted to localhost only for security.
Root remains socket-authenticated by default.

On a side note
I know that on modern Ubuntu systems mysql_secure_installation isn’t strictly necessary anymore — but a bit of paranoia helps me sleep at night. That’s why the script still runs through the whole mysql_secure_installation ritual. It’s not that it’s required — I just don’t want anyone blaming me because it wasn’t done.

More Information

More guides and documentation can be found on wiki.x-files.dk

License

Licensed under the MIT License.

2.0 KiB Raw Permalink Blame History Unescape Escape