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 'https://mariadb.org/mariadb_release_signing_key.asc'

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] https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal main'

The output is as follows;

[email protected]:~$ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal main'
Repository: 'deb [arch=amd64,arm64,ppc64el] https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal main'
Description:
Archive for codename: focal components: main
More info: https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu
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 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal InRelease
Hit:2 http://ppa.launchpad.net/libreoffice/ppa/ubuntu groovy InRelease                                                                                                                       
Hit:3 https://download.docker.com/linux/ubuntu groovy InRelease                                                                                                                              
Hit:4 http://dl.google.com/linux/chrome/deb stable InRelease                                                                                                                                 
Hit:5 http://us.archive.ubuntu.com/ubuntu groovy InRelease                                                                                                                                   
Hit:6 http://download.virtualbox.org/virtualbox/debian focal InRelease                                                                                                                       
Hit:7 http://apt.pop-os.org/proprietary groovy InRelease                                                                                                                                     
Hit:8 http://us.archive.ubuntu.com/ubuntu groovy-security InRelease                                                                                                                          
Hit:9 http://ppa.launchpad.net/ondrej/php/ubuntu groovy InRelease                                                                                                
Hit:10 http://packages.microsoft.com/repos/edge stable InRelease                                                                                                                            
Hit:11 http://us.archive.ubuntu.com/ubuntu groovy-updates InRelease                                                                                                                         
Hit:12 https://dl.winehq.org/wine-builds/ubuntu focal InRelease                                                                              
Hit:13 http://ppa.launchpad.net/system76/pop/ubuntu groovy InRelease                      
Get:14 https://repo.skype.com/deb stable InRelease [4,501 B]        
Hit:15 http://us.archive.ubuntu.com/ubuntu groovy-backports InRelease
Err:14 https://repo.skype.com/deb 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 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 mariadb-common all 1:10.5.10+maria~focal [4,432 B]
Get:2 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 galera-4 amd64 26.4.8-focal [12.4 MB]
Get:3 http://us.archive.ubuntu.com/ubuntu groovy/main amd64 libdbi-perl amd64 1.643-2 [730 kB]
Get:4 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 libmariadb3 amd64 1:10.5.10+maria~focal [147 kB]
Get:5 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 mariadb-client-core-10.5 amd64 1:10.5.10+maria~focal [775 kB]
Get:6 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 mariadb-client-10.5 amd64 1:10.5.10+maria~focal [1,549 kB]
Get:7 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 mariadb-server-core-10.5 amd64 1:10.5.10+maria~focal [6,947 kB]
Get:8 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 mariadb-server-10.5 amd64 1:10.5.10+maria~focal [4,458 kB]
Get:9 https://mariadb.mirror.liquidtelecom.com/repo/10.5/ubuntu focal/main amd64 mariadb-server all 1:10.5.10+maria~focal [3,212 B]
Get:10 http://us.archive.ubuntu.com/ubuntu groovy/main amd64 libcgi-pm-perl all 4.50-1 [186 kB]
Get:11 http://us.archive.ubuntu.com/ubuntu groovy/main amd64 libfcgi-perl amd64 0.79-1 [33.1 kB]
Get:12 http://us.archive.ubuntu.com/ubuntu groovy/main amd64 libcgi-fast-perl all 1:2.15-1 [10.5 kB]                                                                                         
Get:13 http://us.archive.ubuntu.com/ubuntu groovy/universe amd64 libdbd-mariadb-perl amd64 1.11-3ubuntu2 [105 kB]                                                                            
Get:14 http://us.archive.ubuntu.com/ubuntu groovy/main amd64 libhtml-template-perl all 2.97-1 [59.0 kB]                                                                                      
Get:15 http://us.archive.ubuntu.com/ubuntu 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
             └─migrated-from-my.cnf-settings.conf
     Active: active (running) since Wed 2021-06-23 00:35:46 EAT; 7min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   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

Output;

[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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here