MySQL and phpMyAdmin are the go-to combo for managing databases in web projects.

Whether you're building something serious or just tinkering, self-hosting your own stack gives you full control — and it’s easier than you think.

In this guide, I’ll show you how to:

1. Install MySQL on Ubuntu
2. Secure your database
3. Set up phpMyAdmin
4. Add real uptime monitoring — so you know when something breaks

🧰 What You’ll Need

• A fresh Ubuntu 22.04 server
• sudo/root access
• A domain name (optional, but recommended for phpMyAdmin)
• 10–15 minutes

⚡ Step 1: Install MySQL Server

Update your server:

sudo apt update && sudo apt upgrade -y

Install MySQL:

sudo apt install mysql-server -y

Secure your installation:

sudo mysql_secure_installation

Answer the prompts to remove anonymous users, disallow remote root login, etc.

🔐 Step 2: Create a MySQL User and Database

Log in to MySQL:

sudo mysql

Then run:

CREATE DATABASE myapp_db;  
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'strongpassword';  
GRANT ALL PRIVILEGES ON myapp_db.* TO 'myuser'@'localhost';  
FLUSH PRIVILEGES;  
EXIT;

🌐 Step 3: Install phpMyAdmin

Install required dependencies:

sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl -y

During setup:

• Choose Apache (if prompted)
• Configure a MySQL application password

Enable extensions:

sudo phpenmod mbstring  
sudo systemctl restart apache2

Now access it at:

http://your-server-ip/phpmyadmin

🌍 Step 4: (Optional) Set Up a Domain for phpMyAdmin

Point a subdomain (like db.yourdomain.com) to your server’s IP.

Then set up a reverse proxy (e.g. with NGINX) and secure it with HTTPS via Let’s Encrypt.

🛡️ Step 5: Secure phpMyAdmin Access

Protect access by:

• Adding .htpasswd authentication
• Restricting by IP
• Moving it to a non-obvious path (/mydbadmin)

✅ Step 6: Monitor Your MySQL Stack with Garmingo Status

Congrats — your DB stack is running.

But what happens if it goes down?

💡 Don’t wait to find out the hard way. Add uptime monitoring now:

• Create a free Garmingo Status account
• Add a monitor for:
  • http(s)://yourdomain.com/phpmyadmin
  • Port 3306 (MySQL)
  • Your public IP (Ping monitor)

You’ll get:

• Real-time alerts (Slack, Email, Telegram, etc.)
• Public or private status pages
• Downtime logs & SLA tracking
• PDF uptime reports

🆓 100% free plan. No credit card. Instant peace of mind.

👉 Get started here

🧘 TL;DR

• ✅ Install MySQL
• ✅ Set up phpMyAdmin
• 🔒 Secure everything
• 📈 Monitor it with Garmingo Status

If your database goes down and no one's watching… is it really running?

👉 Start monitoring your stack today