top ad article

On this tutorial, we are going to look at how to install MariaDB Server 10.5 on Pop!_OS 20.04|20.10|21.04. MariaDB is a type of relational database that is both popular and open source as per the General Public license. It is considered as an upgrade of MySQL and come with much better features. The features include, advanced clustering, compatibility features and temporal data tables among many more. To get deeper in learning about what MariaDB Server 10.5 offers, visit the MariaDB page and get an elaborate knowledge about it.

Install MariaDB Server 10.5 on Pop!_OS 20.04|20.10|21.04

As at the time this article is written the latest version of MariaDB Server is 10.5. For any other versions or new releases, check the MariaDB repositories. Below is a step by step process on how you can install MariaDB Server 10.5 on Pop!_OS. Just focus on this article to the end and you will be able to install MariaDB Server successfully.

Step 1. Update your System

To update your Pop!_OS system, use the command below;

sudo apt update
sudo apt upgrade

Step 2. Install the Software Properties Package

Once the system is fully updated, ensure that you install the common software properties package using the following command;

sudo apt -y install software-properties-common

Step 3. Import the GPG repository Key for MariaDB, then update

To import the repository key, run the command below;

sudo apt-key adv --fetch-keys ''

Step 4. Add the MariaDB APT repository

To add the APT repository, utilize the command below;

sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] focal main'

The output is as follows;

[email protected]:~$ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] focal main'
Repository: 'deb [arch=amd64,arm64,ppc64el] focal main'
Archive for codename: focal components: main
More info:
Adding repository.
Press [ENTER] to continue or Ctrl-c to cancel.
Adding deb entry to /etc/apt/sources.list.d/archive_uri-https_mariadb_mirror_liquidtelecom_com_repo_10_5_ubuntu-groovy.list
Adding disabled deb-src entry to /etc/apt/sources.list.d/archive_uri-https_mariadb_mirror_liquidtelecom_com_repo_10_5_ubuntu-groovy.list
Hit:1 focal InRelease
Hit:2 groovy InRelease                                                                                                                       
Hit:3 groovy InRelease                                                                                                                              
Hit:4 stable InRelease                                                                                                                                 
Hit:5 groovy InRelease                                                                                                                                   
Hit:6 focal InRelease                                                                                                                       
Hit:7 groovy InRelease                                                                                                                                     
Hit:8 groovy-security InRelease                                                                                                                          
Hit:9 groovy InRelease                                                                                                
Hit:10 stable InRelease                                                                                                                            
Hit:11 groovy-updates InRelease                                                                                                                         
Hit:12 focal InRelease                                                                              
Hit:13 groovy InRelease                      
Get:14 stable InRelease [4,501 B]        
Hit:15 groovy-backports InRelease
Err:14 stable InRelease
  The following signatures were invalid: EXPKEYSIG 1F3045A5DF7587C3 Skype Linux Client Repository <[email protected]>
Fetched 4,501 B in 3s (1,616 B/s)
Reading package lists... Done

Step 5. Update the Package List on your System

You need to update the package list so that you can be able to install packages from the MariaDB repositories. To do this, use the command;

sudo apt update

Step 6. Install MariaDB Server 10.5 on Pop!_OS

Now that everything else is set, package list updated, repositories added, you can now install MariaDB Server 10.5 on Pop!_OS using the command below;

sudo apt install mariadb-server

When prompted whether you want to continue with the installation, tap y to allow.

Below is a section of the output of the installation command;

[email protected]:~$ sudo apt install mariadb-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  galera-4 libcgi-fast-perl libcgi-pm-perl libdbd-mariadb-perl libdbi-perl libfcgi-perl libhtml-template-perl libmariadb3 libterm-readkey-perl mariadb-client-10.5 mariadb-client-core-10.5
  mariadb-common mariadb-server-10.5 mariadb-server-core-10.5
Suggested packages:
  libmldbm-perl libnet-daemon-perl libsql-statement-perl libipc-sharedcache-perl mailx mariadb-test
The following NEW packages will be installed:
  galera-4 libcgi-fast-perl libcgi-pm-perl libdbd-mariadb-perl libdbi-perl libfcgi-perl libhtml-template-perl libmariadb3 libterm-readkey-perl mariadb-client-10.5 mariadb-client-core-10.5
  mariadb-common mariadb-server mariadb-server-10.5 mariadb-server-core-10.5
0 upgraded, 15 newly installed, 0 to remove and 1 not upgraded.
Need to get 27.4 MB of archives.
After this operation, 217 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 focal/main amd64 mariadb-common all 1:10.5.10+maria~focal [4,432 B]
Get:2 focal/main amd64 galera-4 amd64 26.4.8-focal [12.4 MB]
Get:3 groovy/main amd64 libdbi-perl amd64 1.643-2 [730 kB]
Get:4 focal/main amd64 libmariadb3 amd64 1:10.5.10+maria~focal [147 kB]
Get:5 focal/main amd64 mariadb-client-core-10.5 amd64 1:10.5.10+maria~focal [775 kB]
Get:6 focal/main amd64 mariadb-client-10.5 amd64 1:10.5.10+maria~focal [1,549 kB]
Get:7 focal/main amd64 mariadb-server-core-10.5 amd64 1:10.5.10+maria~focal [6,947 kB]
Get:8 focal/main amd64 mariadb-server-10.5 amd64 1:10.5.10+maria~focal [4,458 kB]
Get:9 focal/main amd64 mariadb-server all 1:10.5.10+maria~focal [3,212 B]
Get:10 groovy/main amd64 libcgi-pm-perl all 4.50-1 [186 kB]
Get:11 groovy/main amd64 libfcgi-perl amd64 0.79-1 [33.1 kB]
Get:12 groovy/main amd64 libcgi-fast-perl all 1:2.15-1 [10.5 kB]                                                                                         
Get:13 groovy/universe amd64 libdbd-mariadb-perl amd64 1.11-3ubuntu2 [105 kB]                                                                            
Get:14 groovy/main amd64 libhtml-template-perl all 2.97-1 [59.0 kB]                                                                                      
Get:15 groovy/main amd64 libterm-readkey-perl amd64 2.38-1build1 [24.6 kB]                                                                               
Fetched 27.4 MB in 8s (3,649 kB/s)                                                                                                                                                           
Preconfiguring packages ...

Step 7. Verify the installed Type

To check or rather verify the type of MariaDB installed, use the command;

sudo systemctl status mariadb

The output;

[email protected]:~$ sudo systemctl status mariadb
 mariadb.service - MariaDB 10.5.10 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
     Active: active (running) since Wed 2021-06-23 00:35:46 EAT; 7min ago
       Docs: man:mariadbd(8)
   Main PID: 37113 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 9 (limit: 2250)
     Memory: 68.8M
     CGroup: /system.slice/mariadb.service
             └─37113 /usr/sbin/mariadbd

Step 8. Check the Server Version

To check the server version, use the command below;

mysql -V


[email protected]:~$ mysql -V
mysql  Ver 15.1 Distrib 10.5.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Other Posts;

Previous articleInstall VMware Fusion on macOS Big Sur
Next articleHow to install PostgreSQL Server 13 on pop!_OS 20.04|20.10|21.04
Valentine is eager to learn new things, technology and life issues. She is curious enough to write about them. And, she uses her platform to educate others regarding the many sectors in life and most importantly technology.


Please enter your comment!
Please enter your name here