{"id":3901,"date":"2024-11-19T16:06:18","date_gmt":"2024-11-19T10:36:18","guid":{"rendered":"https:\/\/www.hostzop.com\/knowledge\/?post_type=manual_kb&p=3901"},"modified":"2024-11-19T16:48:45","modified_gmt":"2024-11-19T11:18:45","slug":"how-to-install-mariadb-in-debian-server","status":"publish","type":"manual_kb","link":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/","title":{"rendered":"How to install MariaDB in Debian server"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Introduction :<\/strong><\/p>\n

MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL.MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.<\/p>\n

To install MySQL on a Debian-based system, follow these steps:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Step 1:Update Your Package List<\/strong><\/p>

First, update the system package list to make sure your package index is up to date.<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t# sudo apt update<\/span>\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Step 2: Install MariaDB Server<\/strong><\/p>

To install MariaDB, run the following command:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t# sudo apt install mariadb-server<\/span>\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

This will install the MariaDB server package and the necessary dependencies.<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Step 3: Start and Enable MariaDB Service<\/strong><\/p>

MariaDB should start automatically after installation, but you can check the service status and ensure it is running:<\/p>

To check the status of the MariaDB service:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t# sudo systemctl status mariadb<\/span>\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Step 4: Run the MariaDB Secure Installation Script<\/h3>

After installing MariaDB, it’s important to run the mysql_secure_installation script to configure the database securely. This will allow you to set a root password, remove insecure default settings, and configure other security features.<\/p>

Run the following command:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t# sudo mysql_secure_installation<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

You will be prompted with a series of questions:<\/p>

  • Set a root password if you haven’t done so already.<\/li>
  • Remove the test database (recommended).<\/li>
  • Disallow remote root login (recommended).<\/li>
  • Reload privilege tables to apply the changes<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Step 5: Verify MariaDB Installation<\/strong><\/p>

    To verify that MariaDB is working correctly, log in to the MariaDB shell as the root user:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t# sudo mysql -u root -p<\/span>\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
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Enter the root password when prompted.<\/p>

    You should see the MariaDB prompt:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t$ MariaDB [(none)]><\/span>\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
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    You can exit the MariaDB shell by typing:<\/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

    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t# exit<\/span>\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
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Conclusion:<\/strong><\/p>

    By following the installation steps, including securing the database and configuring essential settings, you can ensure that MariaDB is ready for use in production environments.<\/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","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","manualknowledgebasecat":[24],"manual_kb_tag":[],"class_list":["post-3901","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-debian"],"yoast_head":"\nHow to install MariaDB in Debian server - Hostzop - Web Hosting Services<\/title>\n<meta name=\"description\" content=\"MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to install MariaDB in Debian server - Hostzop - Web Hosting Services\" \/>\n<meta property=\"og:description\" content=\"MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Hostzop - Web Hosting Services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hostzop\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-19T11:18:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@hostzop\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-install-mariadb-in-debian-server\\\/\",\"url\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-install-mariadb-in-debian-server\\\/\",\"name\":\"How to install MariaDB in Debian server - Hostzop - Web Hosting Services\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#website\"},\"datePublished\":\"2024-11-19T10:36:18+00:00\",\"dateModified\":\"2024-11-19T11:18:45+00:00\",\"description\":\"MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-install-mariadb-in-debian-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-install-mariadb-in-debian-server\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/knowledgebase\\\/how-to-install-mariadb-in-debian-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install MariaDB in Debian server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/\",\"name\":\"hostzop.com\\\/knowledge\\\/\",\"description\":\"Just another WordPress site\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#organization\",\"name\":\"Hostzop knowledge\",\"url\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/hostzop.com\\\/knowledge\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/logo.png\",\"width\":233,\"height\":103,\"caption\":\"Hostzop knowledge\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostzop.com\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hostzop\\\/\",\"https:\\\/\\\/x.com\\\/hostzop\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install MariaDB in Debian server - Hostzop - Web Hosting Services","description":"MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.","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:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/","og_locale":"en_US","og_type":"article","og_title":"How to install MariaDB in Debian server - Hostzop - Web Hosting Services","og_description":"MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.","og_url":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/","og_site_name":"Hostzop - Web Hosting Services","article_publisher":"https:\/\/www.facebook.com\/hostzop\/","article_modified_time":"2024-11-19T11:18:45+00:00","twitter_card":"summary_large_image","twitter_site":"@hostzop","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/","url":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/","name":"How to install MariaDB in Debian server - Hostzop - Web Hosting Services","isPartOf":{"@id":"https:\/\/www.hostzop.com\/knowledge\/#website"},"datePublished":"2024-11-19T10:36:18+00:00","dateModified":"2024-11-19T11:18:45+00:00","description":"MariaDB is an open-source relational database management system (RDBMS) that is a fork of MySQL. MariaDB is used as the database backend for many web applications, content management systems (CMS), and other data-driven software. It provides a reliable and efficient database solution for developers and system administrators.","breadcrumb":{"@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostzop.com\/knowledge\/knowledgebase\/how-to-install-mariadb-in-debian-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hostzop.com\/knowledge\/"},{"@type":"ListItem","position":2,"name":"How to install MariaDB in Debian server"}]},{"@type":"WebSite","@id":"https:\/\/www.hostzop.com\/knowledge\/#website","url":"https:\/\/www.hostzop.com\/knowledge\/","name":"hostzop.com\/knowledge\/","description":"Just another WordPress site","publisher":{"@id":"https:\/\/www.hostzop.com\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostzop.com\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hostzop.com\/knowledge\/#organization","name":"Hostzop knowledge","url":"https:\/\/www.hostzop.com\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hostzop.com\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2023\/02\/logo.png","contentUrl":"https:\/\/hostzop.com\/knowledge\/wp-content\/uploads\/2023\/02\/logo.png","width":233,"height":103,"caption":"Hostzop knowledge"},"image":{"@id":"https:\/\/www.hostzop.com\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hostzop\/","https:\/\/x.com\/hostzop"]}]}},"_links":{"self":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb\/3901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/comments?post=3901"}],"version-history":[{"count":0,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb\/3901\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/media?parent=3901"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manualknowledgebasecat?post=3901"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/www.hostzop.com\/knowledge\/wp-json\/wp\/v2\/manual_kb_tag?post=3901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}