Tested with Ubuntu-24.04 and MySQL Server.

---

✅ 1. Update your system

Always start here:

sudo apt update
sudo apt upgrade -y

---

✅ 2. Install MySQL Server (official Ubuntu repo)

Ubuntu 24.04 ships with MySQL 8.0.x, which is solid and supported.

sudo apt install mysql-server -y

---

✅ 3. Verify MySQL is running

MySQL should start automatically.

sudo systemctl status mysql

If it’s not running:

sudo systemctl start mysql
sudo systemctl enable mysql

---

✅ 4. Secure the installation (IMPORTANT)

Run the built-in hardening script:

sudo mysql_secure_installation

Recommended answers:

• Validate password component? → Y (optional but good)
• Password strength → MEDIUM
• Remove anonymous users? → Y
• Disallow root login remotely? → Y
• Remove test database? → Y
• Reload privilege tables? → Y

---

✅ 5. Log in to MySQL (Ubuntu uses socket auth)

On Ubuntu, root logs in via sudo:

sudo mysql

Check version:

SELECT VERSION();

Exit:

exit;

---

✅ 6. (Recommended) Create a database and user

Do NOT use root for apps like Pulse.

sudo mysql

CREATE DATABASE pulse CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE USER 'pulse'@'localhost' IDENTIFIED BY 'StrongPasswordHere';

GRANT ALL PRIVILEGES ON pulse.* TO 'pulse'@'localhost';

FLUSH PRIVILEGES;
EXIT;

---

✅ 7. Allow remote connections (optional)

Only do this if needed (LAN / agents).

Edit MySQL config:

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Change:

bind-address = 127.0.0.1

To:

bind-address = 0.0.0.0

Restart MySQL:

sudo systemctl restart mysql

Then allow firewall access:

sudo ufw allow mysql

---

✅ 8. Test login as app user

mysql -u pulse -p

---

✅ 9. Optional: Tune MySQL (servers / Pulse / metrics)

Check defaults:

mysqltuner

Install:

sudo apt install mysqltuner -y

---

🔥 Notes for Stoxello Pulse

MySQL 8.0 or higher required

• Use utf8mb4 everywhere
• Prefer connection pooling
• Consider MariaDB later only if you need Galera clustering

---