{"id":13866,"date":"2024-05-28T20:15:37","date_gmt":"2024-05-28T17:15:37","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=13866"},"modified":"2024-05-28T20:15:38","modified_gmt":"2024-05-28T17:15:38","slug":"how-to-install-mariadb-community-11-3-on-ubuntu-24-04-lts","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/how-to-install-mariadb-community-11-3-on-ubuntu-24-04-lts\/","title":{"rendered":"How To Install MariaDB Community 11.3 on Ubuntu 24.04 LTS"},"content":{"rendered":"\n

MariaDB is a popular, open-source relational database management system that is a fork of MySQL<\/a>. With MariaDB Community 11.3, you get enhanced performance, reliability, and security features. This guide will walk you through the steps to install MariaDB Community 11.3 on your Ubuntu 24.04 LTS system.<\/p>\n\n\n\n

Prerequisites<\/h3>\n\n\n\n

Before starting the installation process, ensure you have:<\/p>\n\n\n\n

    \n
  1. A system running Ubuntu<\/a> 24.04 LTS.<\/li>\n\n\n\n
  2. Sudo privileges to install and configure software.<\/li>\n<\/ol>\n\n\n\n

    Step 1: Update Your System<\/h3>\n\n\n\n

    First, update your package index to ensure you have the latest information on available packages:<\/p>\n\n\n\n

    $ sudo apt update\n$ sudo apt upgrade -y<\/code><\/pre>\n\n\n\n
    Step 2: Add the MariaDB APT Repository<\/h3>\n\n\n\n
    To install MariaDB<\/a> Community 11.3, you need to add the official MariaDB APT repository to your system.<\/p>\n\n\n\n
      \n
    1. Import the MariaDB signing key<\/strong>:<\/li>\n<\/ol>\n\n\n\n
      $ sudo apt-key adv --fetch-keys 'https:\/\/mariadb.org\/mariadb_release_signing_key.asc'<\/code><\/pre>\n\n\n\n
        \n
      1. Add the MariaDB repository<\/strong>:<\/li>\n<\/ol>\n\n\n\n
        $ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el,s390x] http:\/\/mariadb.mirror.serverion.com\/repo\/11.3\/ubuntu focal main'<\/code><\/pre>\n\n\n\n
        Step 3: Install MariaDB<\/h3>\n\n\n\n
        After adding the repository, install MariaDB with the following command:<\/p>\n\n\n\n
        $ sudo apt update\n$ sudo apt install -y mariadb-server<\/code><\/pre>\n\n\n\n
        Step 4: Secure the MariaDB Installation<\/h3>\n\n\n\n
        MariaDB comes with a security script that helps you secure your installation by removing insecure default settings and access:<\/p>\n\n\n\n
        $ sudo mysql_secure_installation<\/code><\/pre>\n\n\n\n
        Follow the prompts to configure the security options. You will be asked to set a root password, remove anonymous users, disallow root login remotely, and remove the test database.<\/p>\n\n\n\n
        Step 5: Verify the Installation<\/h3>\n\n\n\n
        To ensure that MariaDB is installed and running correctly, check the status of the MariaDB service:<\/p>\n\n\n\n
        $ sudo systemctl status mariadb<\/code><\/pre>\n\n\n\n
        You should see output indicating that MariaDB is active and running.<\/p>\n\n\n\n
        Step 6: Log In to MariaDB<\/h3>\n\n\n\n
        Log in to the MariaDB shell using the root account:<\/p>\n\n\n\n
        $ sudo mariadb -u root -p<\/code><\/pre>\n\n\n\n
        You will be prompted to enter the root password you set during the secure installation process.<\/p>\n\n\n\n
        Step 7: Basic MariaDB Commands<\/h3>\n\n\n\n
        Here are some basic MariaDB commands to get you started:<\/p>\n\n\n\n