How to install MariaDB on Ubuntu 24.04
MariaDB is one of the most popular open-source relational database management systems (RDBMS). Created by the original developers of MySQL, it offers high performance, robust scalability, and complete compatibility with MySQL databases, making it an ideal choice for modern web applications and enterprise systems.
In this video I will show you how to install it
🎁 SPECIAL OFFER:
Use the promo code NEW20_MIVO to get a 20% discount for 3 months on all "Virtual" services on our website!
Useful Links:
MivoCloud Hosting - https://clients.mivocloud.com/aff.php...
Read more useful articles in our Knowledge Base - https://mivocloud.com/blog
WARNING - ANGLED BRACKETS AREN'T ALLOWED IN DESCRIPTION SO BE ATTENTIVE TO THE VIDEO IN NANO EDITOR
⏰ Timestamps:
00:00 - Introduction & Overview
00:10 - MivoCloud Hosting Intro
00:25 - Step 1: Update Server Packages
00:39 - Step 2: Install MariaDB Server & Client
00:48 - Step 3: Secure MariaDB Installation
01:17 - Special Promo Code (20% Off MivoCloud)
01:30 - Step 4: Login & Verify MariaDB Version
01:36 - Step 5: Create Database, User & Grant Privileges
02:00 - Step 6: Test Login with New User & Outro
Commands Used:
sudo apt update && sudo apt upgrade -y
sudo apt install mariadb-server mariadb-client -y
sudo mariadb-secure-installation
sudo mariadb -u root -p
SELECT VERSION();
CREATE DATABASE my_app_db;
CREATE USER 'app_user'@'localhost' IDENTIFIED BY 'your_strong_password';
GRANT ALL PRIVILEGES ON my_app_db.* TO 'app_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;
mariadb -u app_user -p -D my_app_db
#MariaDB #Ubuntu2404 #LinuxTutorial #DatabaseManagement #MivoCloud #SysAdmin #OpenSource