MariaDB is a high performance community-developed database engine that’s commonly used by big systems. we will install the latest version of MariaDB on Ubuntu 20.04
1. Before you in Install MariaDB on Ubuntu, update and upgrade the repositories by the below two commands:
root@iRedMail-doesnt-exist:~# apt update
root@iRedMail-doesnt-exist:~# apt upgrade
Sometimes during the upgrade process apt upgrade
command, you get popups like the one below about updating the packages configuration, don’t change anything, just hit Enter key and keep it as default. Do this for any similar popup.

2. Install the software-properties-common package, we already installed it before installing the PHP, so you don’t need to do anything if you already installed the PHP.
root@iRedMail-doesnt-exist:~# apt install software-properties-common
3. Import MariaDB gpg key by running the command:
root@iRedMail-doesnt-exist:~# apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'

4. Add the APT repository for MariaDB. Until writing this article, 10.5 is the latest. This step will allow the MariaDB version to be upgraded automatically when you upgrade the packages on your server (when running: apt upgrade).
root@iRedMail-doesnt-exist:~# add-apt-repository 'deb [arch=amd64] http://mariadb.mirror.globo.tech/repo/10.5/ubuntu focal main'
For Ubuntu 22.04 LTS, the latest stable version on June 4, 2023 is: 10.11, so run this command:
root@iRedMail-doesnt-exist:~# add-apt-repository 'deb [arch=amd64] http://mariadb.mirror.globo.tech/repo/10.11/ubuntu jammy main'

To remove the repository we’ve just added, run the below command, you can use this command in case you added wrong repository.
root@iRedMail-doesnt-exist:~# add-apt-repository -r 'deb [arch=amd64] http://mariadb.mirror.globo.tech/repo/10.5/ubuntu focal main'
Or enter the file which contains the repositories by running the command and delete it from there:
root@iRedMail-doesnt-exist:~# nano /etc/apt/sources.list
5. Update the APT repository:
root@iRedMail-doesnt-exist:~# apt update
6. Now, let’s install the MariaDB server, by running the command:
root@iRedMail-doesnt-exist:~# apt install mariadb-server
You will be asked to confirm the installation, type: y (or: Y) then hit Enter key. If you don’t want to proceed with the installation, type: n, then hit Enter key.

You will see the below progress:

And here once it’s done:

7. Let’s now check the version installed of MariaDB, run any of the following commands, they are same.
root@iRedMail-doesnt-exist:~# mariadb -V
root@iRedMail-doesnt-exist:~# mysql -V

Assign Password to Root User
8. Let’s add password to root
user, first login to MySQL console by running:
root@iRedMail-doesnt-exist:~# mysql

Run the below MySQL command to assign password to root
user. We will assign the password: abcdefgh
as an example, you should assign so strong password.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'abcdefgh';

Note that if you want to clean the MariaDB console, just press Ctrl + L.
9. Quit MariaDB Console by pressing: Ctrl + c, or type: quit
or exit
. Now your next login to MariaDB console again needs password not like before, run the below command to login:
root@iRedMail-doesnt-exist:~# mysql -u root -p
Enter the root password to login as you see below.

Use CNF File to Login to MariaDB on Ubuntu Without a Password
10. If you want to login to MySQL console without entering the root password everytime, we need to create CNF file in the base directory of your server and add the password there, so next time you login to MySQL console by just typing: mysql
as before when we had no password.
To proceed, open CNF file by running the below command:
root@iRedMail-doesnt-exist:~# nano .my.cnf
Add the user and the password inside the file as below, use a strong password please.
[client]
user=root
password="abcdefgh"

Close and save the file and now try to login to MySQL console via the command:
root@iRedMail-doesnt-exist:~# mysql
Super! Now you can access MySQL console easily and you don’t need to run the command: mysql -u root -p
nor to type the password every time you login to your MySQL console.
Our next step is to create new MySQL database for the new WordPress website that we will start.