.::: Install MariaDB 11.8, 12, 13 In Ubuntu 26.04.1 LTS :::.

 

1. install repository

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-11.4"

2. check mariadb source 

root@teguhth:/data# cat /etc/apt/sources.list.d/mariadb.sources

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
X-Repolib-Name: MariaDB Server
Enabled: yes
Types: deb
URIs: https://dlm.mariadb.com/repo/mariadb-server/11.8/repo/ubuntu
#URIs: https://dlm.mariadb.com/repo/mariadb-server/13.rolling/repo/ubuntu

#URIs: https://dlm.mariadb.com/repo/mariadb-server/12.rolling/repo/ubuntu
Suites: resolute
Components: main main/debug
Architectures: amd64 arm64
Signed-By: /etc/apt/keyrings/mariadb-keyring.gpg
 
# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
#X-Repolib-Name: MariaDB MaxScale
#Enabled: yes
#Types: deb
#URIs: https://dlm.mariadb.com/repo/maxscale/24/apt
#URIs: https://dlm.mariadb.com/repo/maxscale/latest/apt
#Suites: resolute
#Components: main
#Architectures: amd64 arm64
#Signed-By: /etc/apt/keyrings/mariadb-keyring.gpg

root@teguhth:/data#
 

3. install default tool

apt install rsync htop nmon nload net-tools sysstat -y

4. install mariadb 11.8

apt install mariadb-server mariadb-client mariadb-common -y

# for downgrade 

apt install mariadb-server mariadb-client mariadb-common -y --allow-downgrades

5. enable booting & automatic booting 

systemctl enable mariadb
systemctl start mariadb

6. login mariadb

mariadb
mariadb -uroot -p 

7. check version

select @@hostname,@@version;
 

8. check os version 

grep '^PRETTY_NAME=' /etc/os-release | cut -d= -f2- | tr -d '"'
systemctl status mariadb | grep -i database

root@teguhth:/data# grep '^PRETTY_NAME=' /etc/os-release | cut -d= -f2- | tr -d '"'
Ubuntu 26.04.1 LTS
root@teguhth:/data# systemctl status mariadb | grep -i database
? mariadb.service - MariaDB 11.8.9 database server
Nov 06 09:12:16 teguhth systemd[1]: Started mariadb.service - MariaDB 11.8.9 database server.
root@teguhth:/data#

9. check library maria 

root@teguhth:/data# dpkg -l | grep -i mariadb
ii  libdbd-mariadb-perl                              1.22-1ubuntu1                              amd64        Perl5 database interface to the MariaDB/MySQL databases
ii  libmariadb3:amd64                                1:11.8.9+maria~ubu2604                     amd64        MariaDB database client library
ii  mariadb-client                                   1:11.8.9+maria~ubu2604                     amd64        MariaDB database client binaries
ii  mariadb-client-compat                            1:11.8.9+maria~ubu2604                     all          MySQL compatibility links to mariadb-client binaries/scripts.
ii  mariadb-client-core                              1:11.8.9+maria~ubu2604                     amd64        MariaDB database core client binaries
ii  mariadb-common                                   1:11.8.9+maria~ubu2604                     all          MariaDB database common files (e.g. /etc/mysql/mariadb.conf.d/)
ii  mariadb-server                                   1:11.8.9+maria~ubu2604                     amd64        MariaDB database server binaries
ii  mariadb-server-compat                            1:11.8.9+maria~ubu2604                     all          MySQL compatibility links to mariadb-server binaries/scripts.
ii  mariadb-server-core                              1:11.8.9+maria~ubu2604                     amd64        MariaDB database core server files
ii  mysql-common                                     1:11.8.9+maria~ubu2604                     all          MariaDB client common configuration files package (e.g. /etc/mysql/my.cnf)
root@teguhth:/data#