MariaDB is an open-source one of the most popular relational database management system (RDBMS) that is a highly compatible drop-in replacement of MySQL. It is built upon the values of performance, stability, and openness, and MariaDB Foundation ensures contributions will be accepted on technical merit.
MariaDB was developed as a software fork of MySQL in 2009 in response to Oracle’s acquisition of MySQL. MariaDB intends to remain free and open-source software under the GNU General Public License. It is part of most cloud offerings and the default in most Linux distributions.
In this guide we will learn how to install and configure MariaDB in OpenSUSE Leap 15.3.
- How to install Mysql Server 8 on OpenSUSE Leap 15.3
- How to install and Configure Mariadb 10 in Debian 11
- How to install and Configure Mariadb 10 in Ubuntu 20.04
- How to install and Configure Mysql Server 8 on Fedora 34/35
- How to install Mysql 8 on Rocky Linux/Centos 8
- How to Install and Set Up mysql 8 on Ubuntu 20.04
To follow along, ensure you have:
- An up to date OpenSUSE Leap server/workstation
- Root access to the server or user with Sudo access
- Access to the internet from the server
Table of content
- Update system
- Installing Mariadb in OpenSUSE Leap 15.3
- Starting and enabling mariadb service
- Configuring Mariadb in OpenSUSE Leap 15.3
- Testing MariaDB
1. Update the system
Before proceeding let us ensure that the Fedora server is up to date.
In your terminal, type these. The
-y option in
zypper update is to ensure that the system doesn’t pause for us to accept the upgrade.
sudo zypper refresh sudo zypper update -y
2. Installing mariadb in OpenSUSE Leap 15.3
Mariadb can found in the default repos for OpenSUSE. Use this command to install the database server. You can confirm by searching with this command:
sudo dnf search mariadb
Install Mariadb using this command
sudo zypper install -y mariadb
Use this command to get info about the installed mariadb server
~> zypper info mariadb Loading repository data... Reading installed packages... Information for package mariadb: -------------------------------- Repository : Update repository with updates from SUSE Linux Enterprise 15 Name : mariadb Version : 10.5.13-3.12.1 Arch : x86_64 Vendor : SUSE LLC <https://www.suse.com/> Installed Size : 138.2 MiB Installed : Yes Status : up-to-date Source package : mariadb-10.5.13-3.12.1.src Summary : Server part of MariaDB Description : MariaDB is an open-source, multi-threaded, relational database management system. It's a backward compatible, drop-in replacement branch of the MySQL Community Server. This package only contains the server-side programs.
3. Starting and enabling Mariadb
Mariadb will not be started by default. Use this command to start:
sudo systemctl start mariadb
Confirm that the service is up and running by checking its status
~> sudo systemctl status mariadb ● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: active (running) since Mon 2021-12-20 09:39:18 UTC; 55s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 27806 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper install (code=exited, status=0/SUCCESS) Process: 27854 ExecStartPre=/usr/lib/mysql/mysql-systemd-helper upgrade (code=exited, status=0/SUCCESS) Main PID: 27860 (mysqld) Status: "Taking your SQL requests now..." Tasks: 17 (limit: 4587) CGroup: /system.slice/mariadb.service └─27860 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: See the MariaDB Knowledgebase at https://mariadb.com/kb or the Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: MySQL manual for more instructions. Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: Please report any problems at https://mariadb.org/jira Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: The latest information about MariaDB is available at https://mariadb.org/. Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: You can find additional information about the MySQL part at: Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: https://dev.mysql.com Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: Consider joining MariaDB's strong and vibrant community: Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: https://mariadb.org/get-involved/ Dec 20 09:39:18 ip-10-2-40-44 mysql-systemd-helper: 2021-12-20 9:39:18 0 [Note] /usr/sbin/mysqld (mysqld 10.5.13-MariaDB) starting as process 27860 ... Dec 20 09:39:18 ip-10-2-40-44 systemd: Started MariaDB database server.
Now that it is started, let us enable start on boot with this:
~> sudo systemctl enable mariadb Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service. Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.
3. Configuring MariaDB
For new MariaDB installations, the next step is to run the included security script. This script changes some of the less secure default options. We will use it to block remote root logins and to remove unused database users.
Run the security script:
This will take you through a series of prompts where you can make some changes to your MariaDB installation’s security options. The first prompt will ask you to enter the current database root password. Since we have not set one up yet, press
ENTER to indicate “none”.
The next prompt asks you whether you’d like to set up a database root password. Type
N and then press
ENTER. The root account for MariaDB is tied closely to automated system maintenance, so we should not change the configured authentication methods for that account. Doing so would make it possible for a package update to break the database system by removing access to the administrative account. Later, we will cover how to optionally set up an additional administrative account for password access if socket authentication is not appropriate for your use case.
From there, you can press
Y and then
ENTER to accept the defaults for all the subsequent questions. This will remove some anonymous users and the test database, disable remote root logins, and load these new rules so that MariaDB immediately respects the changes you have made.
This is my server’s output
~> sudo mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and haven't set the root password yet, you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password or using the unix_socket ensures that nobody can log into the MariaDB root user without the proper authorisation. You already have your root account protected, so you can safely answer 'n'. Switch to unix_socket authentication [Y/n] Enabled successfully! Reloading privilege tables.. ... Success! You already have your root account protected, so you can safely answer 'n'. Change the root password? [Y/n] New password: Re-enter new password: Password updated successfully! Reloading privilege tables.. ... Success! By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? [Y/n] ... Success! Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] ... Success! By default, MariaDB comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y/n] - Dropping test database... ... Success! - Removing privileges on test database... ... Success! Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? [Y/n] ... Success! Cleaning up... All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB!
5. Testing MariaDB
Now that mariadb is all set up and is running, we need to confirm that it can accept connections.
To test, connect to mariadb with root user –
mysql -h 127.0.0.1 -u root -p
~> mysql -h 127.0.0.1 -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 13 Server version: 10.5.13-MariaDB MariaDB package Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Check mariadb version:
MariaDB [(none)]> SELECT VERSION(); +-----------------+ | VERSION() | +-----------------+ | 10.5.13-MariaDB | +-----------------+ 1 row in set (0.000 sec) MariaDB [(none)]>
For an additional check, you can try connecting to the database using the
mysqladmin tool, which is a client that lets you run administrative commands. For example, this command says to connect to MariaDB as root and return the version using the Unix socket:
sudo mysqladmin version
You should receive output similar to this:
~> sudo mysqladmin version mysqladmin Ver 9.1 Distrib 10.5.13-MariaDB, for Linux on x86_64 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Server version 10.5.13-MariaDB Protocol version 10 Connection Localhost via UNIX socket UNIX socket /run/mysql/mysql.sock Uptime: 7 min 34 sec Threads: 2 Questions: 23 Slow queries: 0 Opens: 21 Open tables: 14 Queries per second avg: 0.050
This means that MariaDB is up and running and that your user is able to authenticate successfully.
In this guide you installed MariaDB to act as an SQL server. During the installation process you also secured the server.