Technoracle
    Facebook Twitter Instagram
    • Sitemap
    • Privacy Policy
    • Disclaimer
    • Term of Services
    Facebook Twitter Instagram Pinterest Vimeo
    TechnoracleTechnoracle
    • Tutorials
      • Amazon Cloud
      • Google Cloud
    • How To
    • Blog
    • About
    Subscribe
    Technoracle
    Home»How To»How to Install MariaDB on Ubuntu 20.04 Quickly
    How To

    How to Install MariaDB on Ubuntu 20.04 Quickly

    Rajesh ShivamBy Rajesh ShivamMay 28, 2021No Comments2 Mins Read
    Share Facebook Twitter Pinterest LinkedIn Tumblr Reddit Telegram Email
    Install MariaDB on Ubuntu
    Share
    Facebook Twitter LinkedIn Pinterest Email

    MariaDB is an open-source database management system and replacement of MySQL. You can use MariaDB on LAMP installation, instead of MySQL. In this tutorial, I am going to explain how to install MariaDB on Ubuntu step-by-step.

    So, Let’s get started.

    Page Contents

    • Install MariaDB on Ubuntu 20.04
      • Prerequisites
      • Installation steps of MariaDB
        • Step 1: Install MariaDB
        • Step 2: Configure MariaDB
        • Step 3: Connect MariaDB from the command line
      • Conclusion

    Install MariaDB on Ubuntu 20.04

    Prerequisites

    • Ubuntu 20.04 with non root administrative access.
    • Firewall configured with UFW(Uncomplicated Firewall).

    Installation steps of MariaDB

    Follow the below steps to install MariaDB on Ubuntu 20.04, configure MariaDB, user create, etc.

    Step 1: Install MariaDB

    Update the Ubuntu packages index first.

    $ sudo apt update

    Then install MariaDB by following command.

    $ sudo apt install mariadb-server

    To, make sure the database management system(MariaDB) installed correctly, run following command.

    $ sudo systemctl status mariadb

    Output should be something like this.

    Install MariaDB on Ubuntu 20.04

    Step 2: Configure MariaDB

    Now, run MySQL secure installation to tighten the security of the MariaDB. Also, you can set root password and remove anonymous user.

    $ sudo mysql_secure_installation

    Step 3: Connect MariaDB from the command line

    Now, connect MariaDB from command line using following command to create, modify, drop databases.

    $ mysql -u root -p

    Read Also, How to import and export MySQL databases.

    Conclusion

    In this tutorial, you have learned to install MariaDB on Ubuntu 20.04. If you have any doubt, feel free to comment below. Also, you can join our elite Facebook group to get direct help from me. If you like this article, please share this article on your social media handle.

    Install MariaDB on Ubuntu mysql tutorial ubuntu tips
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
    Previous ArticleHow to Enable PHP Zip Extension in cPanel
    Next Article How to Run Shell Script in Linux Terminal Easily
    Rajesh Shivam

    Hello, everyone, I am Rajesh Shivam, I am a full-time freelancer with more than seven years plus experience in different freelancing platforms, in this blog, I am going to provide complete freelancing tips and tricks.

    Related Posts

    How To

    How to Install Microsoft Teams on Ubuntu 22.04 Easily

    February 22, 2023
    Read More
    How To

    What is Elastic IP and Its Pricing in AWS

    February 22, 2023
    Read More
    How To

    How to Convert PEM to PPK file [Step by Step Guide]

    February 22, 2023
    Read More
    Add A Comment

    Leave A Reply Cancel Reply

    Facebook Twitter Instagram Pinterest
    © 2023 Technoracle

    Type above and press Enter to search. Press Esc to cancel.

    Go to mobile version