Introduction
MariaDB is a widely-used open-source relational database management system. This tutorial will guide you through the process of installing the latest version of MariaDB on Ubuntu 22.04.
Prerequisites
Before you begin, ensure you have:
- An Ubuntu 22.04 server or desktop system
- SSH access to the server or administrative access to the desktop system
- Root or sudo privileges
Step 1: Update System
Before installing any new software, it's always a good idea to update the package repository and installed packages:
sudo apt update
sudo apt upgrade -y
Step 2: Install MariaDB Server
Install the MariaDB server package using the following command:
sudo apt install -y mariadb-server
Step 3: Secure MariaDB Installation
Run the following command to secure the MariaDB installation:
sudo mysql_secure_installation
Follow the on-screen prompts to set the root password, remove anonymous users, disallow root login remotely, and remove the test database and access to it.
Step 4: Start and Enable MariaDB Service
Start the MariaDB service and enable it to start on system boot:
sudo systemctl start mariadb
sudo systemctl enable mariadb
Step 5: Verify MariaDB Installation
Verify that MariaDB is running:
sudo systemctl status mariadb
If MariaDB is running, you should see an active status.
Step 6: Access MariaDB
Access the MariaDB command-line interface by running:
sudo mysql -u root -p
You will be prompted to enter the root password you set during the installation process.
Conclusion
You have successfully installed the latest MariaDB database on Ubuntu 22.04. You can now use MariaDB to create and manage databases for your applications.