{"id":60936,"date":"2023-01-03T09:01:31","date_gmt":"2023-01-03T01:01:31","guid":{"rendered":"https:\/\/version-2.com\/?p=60936"},"modified":"2023-02-22T14:31:32","modified_gmt":"2023-02-22T06:31:32","slug":"how-to-install-and-secure-mariadb-in-rhel-9","status":"publish","type":"post","link":"https:\/\/version-2.com\/en\/2023\/01\/how-to-install-and-secure-mariadb-in-rhel-9\/","title":{"rendered":"How to Install and Secure MariaDB in RHEL 9"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"60936\" class=\"elementor elementor-60936\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-35fe5dd post-content elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"35fe5dd\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[{&quot;jet_parallax_layout_image&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;_id&quot;:&quot;cef08c3&quot;,&quot;jet_parallax_layout_image_tablet&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_image_mobile&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_speed&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:50,&quot;sizes&quot;:[]},&quot;jet_parallax_layout_type&quot;:&quot;scroll&quot;,&quot;jet_parallax_layout_direction&quot;:&quot;1&quot;,&quot;jet_parallax_layout_fx_direction&quot;:null,&quot;jet_parallax_layout_z_index&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_x&quot;:50,&quot;jet_parallax_layout_bg_x_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_x_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_y&quot;:50,&quot;jet_parallax_layout_bg_y_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_y_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_size&quot;:&quot;auto&quot;,&quot;jet_parallax_layout_bg_size_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_size_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_animation_prop&quot;:&quot;transform&quot;,&quot;jet_parallax_layout_on&quot;:[&quot;desktop&quot;,&quot;tablet&quot;]}]}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-409a2e9a\" data-id=\"409a2e9a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5a8be8f elementor-widget elementor-widget-text-editor\" data-id=\"5a8be8f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p align=\"center\"><img decoding=\"async\" class=\"head-img\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png\" alt=\"\" ><\/p>\n\n<p><a href=\"#step1\" class=\"jcloud-btn\">Jump to Tutorial<\/a><\/p> <p><a href=\"https:\/\/mariadb.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB<\/a> is an open source and community-developed fork of MySQL. It is a widely used <a href=\"https:\/\/jumpcloud.com\/blog\/using-ldap-authenticate-mysqlticate-mysql\">relational database management system<\/a> (RDMS) used to store data both in production and for personal and experimental projects. It was designed by the original developers of the MySQL database server, with the objective of remaining open source under the GNU GPL license.<\/p> <p>Some of the advantages of using MariaDB over MySQL include:<\/p> <ol><li><strong>Strong security <\/strong>thanks to additional security features such as user roles, PAM and LDAP authentication, data encryption, and role-based access control (RBAC).<\/li><li><strong>High performance<\/strong> thanks to more and better storage engines such as Aria and XtraDB. The former replaces MyISAM in MySQL and offers better caching. XtraDB replaces InnoDB and improves performance.<\/li><li><strong>Galera clustering <\/strong>which ensures scalability, high availability, and zero loss of data through replication.<\/li><li><strong>Integrated monitoring<\/strong> using microsecond precision and extended user statistics.<\/li><\/ol> <p>In this guide, we will demonstrate how to install and secure MariaDB on RHEL 9.<\/p> <h2 id=\"step1\">Step 1: Upgrade Software Packages<\/h2> <p>To get started, log into your server as a sudo user via SSH. Next, upgrade all the packages and refresh the repositories as follows:<\/p> <p><code>$ sudo dnf update<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"106\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-1.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-1.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-1-300x62.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73249\"><\/figure> <p>The MariaDB Server package is provided by the official AppStream repositories. You can confirm this by searching for the package on the repositories as shown:<\/p> <p><code>$ sudo dnf search mariadb-server<\/code><\/p> <p>The following output confirms that MariaDB is hosted on the default repositories.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"130\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-2.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-2.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-2-300x76.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73250\"><\/figure> <h2 id=\"step2\">Step 2: Install MariaDB Server on RHEL 9<\/h2> <p>The next step is to install the MariaDB Server. To do so, run the following command:<\/p> <p><code>$ sudo dnf install mariadb-server -y<\/code><\/p> <p>The command installs the MariaDB server alongside other dependencies and additional packages required by the database server.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"144\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-3.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-3.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/tutorial-3-300x84.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73251\"><\/figure> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"322\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4-300x189.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73252\"><\/figure> <p>Once the installation is complete, confirm that MariaDB is installed using the following command:<\/p> <p><code>$ rpm -qi mariadb-server<\/code><\/p> <p>Running this command displays comprehensive details about the MariaDB Server package including the name, version, architecture, installation date, and installed size to name a few.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"282\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/5.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/5.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/5-300x165.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73253\"><\/figure> <h2 id=\"step3\">Step 3: Start and Enable MariaDB Server<\/h2> <p>Up to this point, we have successfully installed the MariaDB Server. By default, the MariaDB service does not start automatically. As such you need to start it by running the following command:<\/p> <p><code>$ sudo systemctl start mariadb<\/code><\/p> <p>In addition, set it to start automatically on system startup.<\/p> <p><code>$ sudo systemctl enable mariadb<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"110\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/6.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/6.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/6-300x64.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73254\"><\/figure> <p>To verify that MariaDB is up and running, run the command:<\/p> <p><code>$ sudo systemctl status mariadb<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"154\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/7.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/7.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/7-300x90.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73255\"><\/figure> <p>MariaDB listens on TCP port 3306. You can confirm this using the command:<\/p> <p><code>$ sudo ss -pnltu | grep mariadb<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"77\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/8.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/8.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/8-300x45.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73256\"><\/figure> <h2 id=\"step4\">Step 4: Secure MariaDB Server<\/h2> <p>The default settings for the MariaDB database server are considered weak and not robust in the face of a breach or intrusion. As such, you need to go an extra step and secure the database server. To do this, run the <code>mysql_secure_installation<\/code> script as shown:<\/p> <p><code>$ sudo mysql_secure_installation<\/code><\/p> <p>Running the script will present you with a series of prompts.<\/p> <p>First, you will be required to provide the root password. Next, switch to <strong>unix_socket authentication<\/strong> which allows the user to use operating system credentials when connecting to the MariaDB database server.<\/p> <p>You can then decide to change the root user or let it remain exactly the way it is.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"337\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/9.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/9.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/9-300x197.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73257\"><\/figure> <p>For the remaining prompts, press \u201cY\u201d in order to secure MariaDB to the recommended standards. This does the following:<\/p> <ol><li><strong>Removes anonymous users from the database server.<\/strong> This prevents the risk of having anyone log into MariaDB without having a user account.<\/li><li><strong>Disallows remote root login.<\/strong> This ensures that only the root user is allowed to connect from \u2018localhost\u2019 or the server on which MariaDB is installed. This prevents brute-force attacks using the root user password.<\/li><li><strong>Removes a test database<\/strong> called test which can be accessed by anyone and is only used for testing. Its removal is recommended before transitioning to a producing environment.<\/li><li><strong>Reloads the privilege tables.<\/strong> Hence, saves all the changes made.<\/li><\/ol> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"424\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/10.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/10.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/10-300x248.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73258\"><\/figure> <p>MariaDB is now secured using the recommended security standards after installation.<\/p> <h2 id=\"step5\">Step 5: Log Into MariaDB Server<\/h2> <p>To log in to the MariaDB database server, run the command:<\/p> <p><code>$ sudo mysql -u root -p<\/code><\/p> <p>Provide the root password for MariaDB and press ENTER. This ushers you to the MariaDB shell.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"158\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/11.png\" alt=\"\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/11.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/11-300x93.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73259\"><\/figure> <p>To check the version of MariaDB installed, run the command:<\/p> <p><code>SELECT VERSION();<\/code><\/p> <p>From the output, you can see that we are running MariaDB 10.5.16.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"167\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/12.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/12.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/12-300x98.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73260\"><\/figure> <p>To list all the databases, run the command:<\/p> <p><code>SHOW DATABASES;<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"179\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/13.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/13.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/13-300x105.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73261\"><\/figure> <h2 id=\"step6\">Step 6: Create Database and Database User (Optional)<\/h2> <p>This step illustrates how to create a database and a database user.<\/p> <p>To create a database in the MariaDB Server, run the following command where <code>test_db <\/code>is the database name:<\/p> <p><code>CREATE DATABASE test_db;<\/code><\/p> <p>Next, create a database user on the system with a password. Here, <code>test_user <\/code>is the name of the database user and <code>P@ssword321@ <\/code>is the user\u2019s password. Be sure to provide a stronger password for your user.<\/p> <p><code>CREATE USER 'test_user'@'localhost' IDENTIFIED BY 'Password321@';<\/code><\/p> <p>Next, grant privileges to the database user on the database. This determines the rights that the user has on the database, e.g., ALTER, CREATE, DELETE, DROP, SELECT, UPDATE, etc. This command will grant user rights to the database.<\/p> <p><code>GRANT ALL ON test_db.* TO 'test_user'@'localhost' WITH GRANT OPTION;<\/code><\/p> <p>Lastly, reload the grant tables in order to save the changes made as follows:<\/p> <p><code>FLUSH PRIVILEGES<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"199\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/14.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/14.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/14-300x117.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73262\"><\/figure> <p>To confirm the creation of the database, again, run the following SQL query:<\/p> <p><code>SHOW DATABASES;<\/code><\/p> <p>This time around, an additional database named <code>test_db <\/code>appears on the list.<\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"237\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/15.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/15.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/15-300x139.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73263\"><\/figure> <p>To view a list of all the users in the database server, run the following query:<\/p> <p><code>SELECT User, Host FROM mysql.user;<\/code><\/p> <figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"205\" src=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/16.png\" alt=\"screenshot of code\" srcset=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/16.png 512w, https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/16-300x120.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" class=\"wp-image-73264\"><\/figure> <h2>Conclusion<\/h2> <p>In this guide, you learned how to install and secure the MariaDB database server on RHEL 9. For more information about MariaDB, check out the <a href=\"https:\/\/mariadb.com\/kb\/en\/documentation\/\" target=\"_blank\" rel=\"noreferrer noopener\">official documentation<\/a>.<\/p> <p>Looking for more ways to secure your Linux servers and devices? Learn <a href=\"https:\/\/jumpcloud.com\/blog\/new-linux-security-policies-july-2022\">how to improve Linux security posture<\/a> with JumpCloud\u2019s MDM policies.&nbsp;<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2004c86 elementor-widget elementor-widget-shortcode\" data-id=\"2004c86\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\">\t\t<div data-elementor-type=\"page\" data-elementor-id=\"18103\" class=\"elementor elementor-18103\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-748947f elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"748947f\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[{&quot;jet_parallax_layout_image&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;_id&quot;:&quot;c4f773e&quot;,&quot;jet_parallax_layout_image_tablet&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_image_mobile&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_speed&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:50,&quot;sizes&quot;:[]},&quot;jet_parallax_layout_type&quot;:&quot;scroll&quot;,&quot;jet_parallax_layout_direction&quot;:&quot;1&quot;,&quot;jet_parallax_layout_fx_direction&quot;:null,&quot;jet_parallax_layout_z_index&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_x&quot;:50,&quot;jet_parallax_layout_bg_x_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_x_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_y&quot;:50,&quot;jet_parallax_layout_bg_y_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_y_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_size&quot;:&quot;auto&quot;,&quot;jet_parallax_layout_bg_size_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_size_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_animation_prop&quot;:&quot;transform&quot;,&quot;jet_parallax_layout_on&quot;:[&quot;desktop&quot;,&quot;tablet&quot;]}]}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7995c19\" data-id=\"7995c19\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a437045 elementor-widget elementor-widget-image-box\" data-id=\"a437045\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-image-box-wrapper\"><div class=\"elementor-image-box-content\"><h3 class=\"elementor-image-box-title\">About Version 2 Digital<\/h3><p class=\"elementor-image-box-description\">Version 2 Digital is one of the most dynamic IT companies in Asia. The company distributes a wide range of IT products across various areas including cyber security, cloud, data protection, end points, infrastructures, system monitoring, storage, networking, business productivity and communication products.\n<br><br>\nThrough an extensive network of channels, point of sales, resellers, and partnership companies, Version 2 offers quality products and services which are highly acclaimed in the market. Its customers cover a wide spectrum which include Global 1000 enterprises, regional listed companies, different vertical industries, public utilities, Government, a vast number of successful SMEs, and consumers in various Asian cities.<\/p><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t\n\t\t<div data-elementor-type=\"page\" data-elementor-id=\"57539\" class=\"elementor elementor-57539\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6b25dc0d elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"6b25dc0d\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[{&quot;_id&quot;:&quot;c4f773e&quot;,&quot;jet_parallax_layout_image&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_image_tablet&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_image_mobile&quot;:{&quot;url&quot;:&quot;&quot;,&quot;id&quot;:&quot;&quot;,&quot;size&quot;:&quot;&quot;},&quot;jet_parallax_layout_speed&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:50,&quot;sizes&quot;:[]},&quot;jet_parallax_layout_type&quot;:&quot;scroll&quot;,&quot;jet_parallax_layout_direction&quot;:&quot;1&quot;,&quot;jet_parallax_layout_fx_direction&quot;:null,&quot;jet_parallax_layout_z_index&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_x&quot;:50,&quot;jet_parallax_layout_bg_x_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_x_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_y&quot;:50,&quot;jet_parallax_layout_bg_y_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_y_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_size&quot;:&quot;auto&quot;,&quot;jet_parallax_layout_bg_size_tablet&quot;:&quot;&quot;,&quot;jet_parallax_layout_bg_size_mobile&quot;:&quot;&quot;,&quot;jet_parallax_layout_animation_prop&quot;:&quot;transform&quot;,&quot;jet_parallax_layout_on&quot;:[&quot;desktop&quot;,&quot;tablet&quot;]}]}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3cc1b37d\" data-id=\"3cc1b37d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52c4a230 elementor-widget elementor-widget-text-editor\" data-id=\"52c4a230\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>About JumpCloud<\/strong><br \/>At JumpCloud, our mission is to build a world-class cloud directory. Not just the evolution of Active Directory to the cloud, but a reinvention of how modern IT teams get work done. The JumpCloud Directory Platform is a directory for your users, their IT resources, your fleet of devices, and the secure connections between them with full control, security, and visibility.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Jump to Tutorial MariaDB is an open source and communit [&hellip;]<\/p>","protected":false},"author":143524195,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1075,1016,61],"tags":[1017,1076],"class_list":["post-60936","post","type-post","status-publish","format-standard","hentry","category-year2023","category-jumpcloud","category-press-release","tag-jumpcloud","tag-1076"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Install and Secure MariaDB in RHEL 9 - Version 2<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install and Secure MariaDB in RHEL 9 - Version 2\" \/>\n<meta property=\"og:description\" content=\"Jump to Tutorial MariaDB is an open source and communit [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9\" \/>\n<meta property=\"og:site_name\" content=\"Version 2\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-03T01:01:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-22T06:31:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png\" \/>\n<meta name=\"author\" content=\"version2hk\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"version2hk\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/version-2.com\\\/2023\\\/01\\\/how-to-install-and-secure-mariadb-in-rhel-9\\\/\"},\"author\":{\"name\":\"version2hk\",\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#\\\/schema\\\/person\\\/d14d2d3cd77ffdb618b9f1330fe084db\"},\"headline\":\"How to Install and Secure MariaDB in RHEL 9\",\"datePublished\":\"2023-01-03T01:01:31+00:00\",\"dateModified\":\"2023-02-22T06:31:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/version-2.com\\\/2023\\\/01\\\/how-to-install-and-secure-mariadb-in-rhel-9\\\/\"},\"wordCount\":894,\"publisher\":{\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jumpcloud.com\\\/\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/4.png\",\"keywords\":[\"JumpCloud\",\"2023\"],\"articleSection\":[\"2023\",\"JumpCloud\",\"Press Release\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/version-2.com\\\/2023\\\/01\\\/how-to-install-and-secure-mariadb-in-rhel-9\\\/\",\"url\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9\",\"name\":\"How to Install and Secure MariaDB in RHEL 9 - Version 2\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/jumpcloud.com\\\/\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/4.png\",\"datePublished\":\"2023-01-03T01:01:31+00:00\",\"dateModified\":\"2023-02-22T06:31:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#primaryimage\",\"url\":\"https:\\\/\\\/jumpcloud.com\\\/\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/4.png\",\"contentUrl\":\"https:\\\/\\\/jumpcloud.com\\\/\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jumpcloud.com\\\/blog\\\/how-to-install-mariadb-rhel-9#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\\\/\\\/version-2.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install and Secure MariaDB in RHEL 9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#website\",\"url\":\"https:\\\/\\\/version-2.com\\\/zh\\\/\",\"name\":\"Version 2\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/version-2.com\\\/zh\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#organization\",\"name\":\"Version 2\",\"url\":\"https:\\\/\\\/version-2.com\\\/zh\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/version-2.com\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/v2-hk-hor-4.png?fit=1795%2C335&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/version-2.com\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/v2-hk-hor-4.png?fit=1795%2C335&ssl=1\",\"width\":1795,\"height\":335,\"caption\":\"Version 2\"},\"image\":{\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/version-2.com\\\/zh\\\/#\\\/schema\\\/person\\\/d14d2d3cd77ffdb618b9f1330fe084db\",\"name\":\"version2hk\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d280627252b42d7489de74dd88aa04043a495f25e258575000dc767e287bf94c?s=96&d=identicon&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d280627252b42d7489de74dd88aa04043a495f25e258575000dc767e287bf94c?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d280627252b42d7489de74dd88aa04043a495f25e258575000dc767e287bf94c?s=96&d=identicon&r=g\",\"caption\":\"version2hk\"},\"sameAs\":[\"http:\\\/\\\/version2xfortcom.wordpress.com\"],\"url\":\"https:\\\/\\\/version-2.com\\\/en\\\/author\\\/version2hk\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install and Secure MariaDB in RHEL 9 - Version 2","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9","og_locale":"en_US","og_type":"article","og_title":"How to Install and Secure MariaDB in RHEL 9 - Version 2","og_description":"Jump to Tutorial MariaDB is an open source and communit [&hellip;]","og_url":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9","og_site_name":"Version 2","article_published_time":"2023-01-03T01:01:31+00:00","article_modified_time":"2023-02-22T06:31:32+00:00","og_image":[{"url":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png","type":"","width":"","height":""}],"author":"version2hk","twitter_card":"summary_large_image","twitter_misc":{"Written by":"version2hk","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#article","isPartOf":{"@id":"https:\/\/version-2.com\/2023\/01\/how-to-install-and-secure-mariadb-in-rhel-9\/"},"author":{"name":"version2hk","@id":"https:\/\/version-2.com\/zh\/#\/schema\/person\/d14d2d3cd77ffdb618b9f1330fe084db"},"headline":"How to Install and Secure MariaDB in RHEL 9","datePublished":"2023-01-03T01:01:31+00:00","dateModified":"2023-02-22T06:31:32+00:00","mainEntityOfPage":{"@id":"https:\/\/version-2.com\/2023\/01\/how-to-install-and-secure-mariadb-in-rhel-9\/"},"wordCount":894,"publisher":{"@id":"https:\/\/version-2.com\/zh\/#organization"},"image":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png","keywords":["JumpCloud","2023"],"articleSection":["2023","JumpCloud","Press Release"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/version-2.com\/2023\/01\/how-to-install-and-secure-mariadb-in-rhel-9\/","url":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9","name":"How to Install and Secure MariaDB in RHEL 9 - Version 2","isPartOf":{"@id":"https:\/\/version-2.com\/zh\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#primaryimage"},"image":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png","datePublished":"2023-01-03T01:01:31+00:00","dateModified":"2023-02-22T06:31:32+00:00","breadcrumb":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#primaryimage","url":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png","contentUrl":"https:\/\/jumpcloud.com\/\/wp-content\/uploads\/2022\/12\/4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/version-2.com\/"},{"@type":"ListItem","position":2,"name":"How to Install and Secure MariaDB in RHEL 9"}]},{"@type":"WebSite","@id":"https:\/\/version-2.com\/zh\/#website","url":"https:\/\/version-2.com\/zh\/","name":"Version 2","description":"","publisher":{"@id":"https:\/\/version-2.com\/zh\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/version-2.com\/zh\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/version-2.com\/zh\/#organization","name":"Version 2","url":"https:\/\/version-2.com\/zh\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/version-2.com\/zh\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/version-2.com\/wp-content\/uploads\/2020\/08\/v2-hk-hor-4.png?fit=1795%2C335&ssl=1","contentUrl":"https:\/\/i0.wp.com\/version-2.com\/wp-content\/uploads\/2020\/08\/v2-hk-hor-4.png?fit=1795%2C335&ssl=1","width":1795,"height":335,"caption":"Version 2"},"image":{"@id":"https:\/\/version-2.com\/zh\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/version-2.com\/zh\/#\/schema\/person\/d14d2d3cd77ffdb618b9f1330fe084db","name":"version2hk","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d280627252b42d7489de74dd88aa04043a495f25e258575000dc767e287bf94c?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d280627252b42d7489de74dd88aa04043a495f25e258575000dc767e287bf94c?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d280627252b42d7489de74dd88aa04043a495f25e258575000dc767e287bf94c?s=96&d=identicon&r=g","caption":"version2hk"},"sameAs":["http:\/\/version2xfortcom.wordpress.com"],"url":"https:\/\/version-2.com\/en\/author\/version2hk\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pbQRKm-fQQ","post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/posts\/60936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/users\/143524195"}],"replies":[{"embeddable":true,"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/comments?post=60936"}],"version-history":[{"count":10,"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/posts\/60936\/revisions"}],"predecessor-version":[{"id":60946,"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/posts\/60936\/revisions\/60946"}],"wp:attachment":[{"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/media?parent=60936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/categories?post=60936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/version-2.com\/en\/wp-json\/wp\/v2\/tags?post=60936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}