{"id":2589,"date":"2019-06-13T12:28:29","date_gmt":"2019-06-13T06:58:29","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=2589"},"modified":"2019-06-16T13:18:59","modified_gmt":"2019-06-16T07:48:59","slug":"how-to-install-mariadb-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","title":{"rendered":"How to install MariaDB on Ubuntu 18.04"},"content":{"rendered":"\n<p>MariaDB Server is one of the most popular database servers in the world. It\u2019s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google. <\/p>\n\n\n\n<p>In this post, we will learn how to install MariaDB on Ubuntu 18.04 using two methods.<\/p>\n\n\n\n<p>Before proceeding, the user must have sudo privileges using which you are logged in.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Installing MariaDB<\/h2>\n\n\n\n<p>1)  Run Updates on Server<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt update <\/pre>\n\n\n\n<p>2) After Packages update, run below command<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt install mariadb-server <\/pre>\n\n\n\n<p> 3) MySQL service will start automatically or run below command <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl start mariadb <\/pre>\n\n\n\n<p>Output would be like<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\u25cf mariadb.service - MariaDB database server\nLoaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset\n Active: active (running) since Sun 2019-06-16 1558 UTC; 20s ago\n Main PID: 25845 (mysqld)\n Status: \"Taking your SQL requests now\u2026\"\n     Tasks: 87 (limit: 600)\n CGroup: \/system.slice\/mariadb.service\n         \u2514\u250025845 \/usr\/sbin\/mysqld<\/pre>\n\n\n\n<p>Check MySQL version:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ mysql -V <\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql  Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Installing MariaDB using MariaDB repo<\/h2>\n\n\n\n<p>1) Add the MariaDB GPG key&nbsp; on the server<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8<\/pre>\n\n\n\n<p>2) Add MariaDB repo<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http:\/\/ftp.utexas.edu\/mariadb\/repo\/10.3\/ubuntu bionic main'<\/pre>\n\n\n\n<p>3) Update package list<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt update<\/pre>\n\n\n\n<p>4) Install MariaDB package<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt install mariadb-server<\/pre>\n\n\n\n<p>MariaDB service will start automatically<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl status mariadb<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">\u25cf mariadb.service - MariaDB 10.3.8 database server\nLoaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\nDrop-In: \/etc\/systemd\/system\/mariadb.service.d\n        \u2514\u2500migrated-from-my.cnf-settings.conf\nActive: active (running) since Sun 2019-06-16 1649 UTC; 56s ago\n    Docs: man:mysqld(8)\n        https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\nMain PID: 18576 (mysqld)\nStatus: \"Taking your SQL requests now...\"\n    Tasks: 32 (limit: 604)\nCGroup: \/system.slice\/mariadb.service\n        \u2514\u250018576 \/usr\/sbin\/mysqld<\/pre>\n\n\n\n<p>Check MySQL version<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ mysql -V <\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql  Ver 15.1 Distrib 10.3.8-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2<\/pre>\n\n\n\n<p>After installation Secure MySQL using below steps<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo mysql_secure_installation<\/pre>\n\n\n\n<p>This command will prompt you for <strong>root password,<\/strong> <strong>remove anonymous users<\/strong>,&nbsp;<strong>disallow remote root login<\/strong>, and&nbsp;<strong>remove the test database and access<\/strong>&nbsp;to secure&nbsp;<strong>MariaDB<\/strong>. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\n      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\n\nIn order to log into MariaDB to secure it, we'll need the current\npassword for the root user.  If you've just installed MariaDB, and\nyou haven't set the root password yet, the password will be blank,\nso you should just press enter here.\n\nEnter current password for root (enter for none):\n\nOK, successfully used password, moving on...\n\nSetting the root password ensures that nobody can log into the MariaDB\nroot user without the proper authorisation.\n\n<strong>Set root password? [Y\/n] Y<\/strong>\n\nNew password:\nRe-enter new password:\nPassword updated successfully!\nReloading privilege tables..\n ... Success!\n\n<strong>Remove anonymous users? [Y\/n] y<\/strong>\n ... Success!\n\nNormally, root should only be allowed to connect from 'localhost'.  This\nensures that someone cannot guess at the root password from the network.\n\n<strong>Disallow root login remotely? [Y\/n] y<\/strong>\n ... Success!\n\nBy default, MariaDB comes with a database named 'test' that anyone can\naccess.  This is also intended only for testing, and should be removed\nbefore moving into a production environment.\n\n<strong>Remove test database and access to it? [Y\/n] y<\/strong>\n - Dropping test database...\n ... Success!\n - Removing privileges on test database...\n ... Success!\n\nReloading the privilege tables will ensure that all changes made so far\nwill take effect immediately.\n\n<strong>Reload privilege tables now? [Y\/n] y<\/strong>\n ... Success!\n\nCleaning up...\n\nAll done!  If you've completed all of the above steps, your MariaDB\ninstallation should now be secure.\n\nThanks for using MariaDB!<\/pre>\n\n\n\n<p>Restart MySQL service<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl restart mariadb.service<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB Server is one of the most popular database servers in the world. It\u2019s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google. In this post, we will learn how to install MariaDB on Ubuntu 18.04 using two methods. Before proceeding, the user must [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[34,166],"tags":[112,165,83],"class_list":["post-2589","post","type-post","status-publish","format-standard","hentry","category-linux","category-ubuntu","tag-linux","tag-mariadb","tag-ubuntu"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to install MariaDB on Ubuntu 18.04 | 24x7serversupport Blog<\/title>\n<meta name=\"description\" content=\"How to install MariaDB on Ubuntu 18.04\" \/>\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.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\" \/>\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 on Ubuntu 18.04 | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"How to install MariaDB on Ubuntu 18.04\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-13T06:58:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-16T07:48:59+00:00\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\",\"name\":\"How to install MariaDB on Ubuntu 18.04 | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"datePublished\":\"2019-06-13T06:58:29+00:00\",\"dateModified\":\"2019-06-16T07:48:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"description\":\"How to install MariaDB on Ubuntu 18.04\",\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install MariaDB on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install MariaDB on Ubuntu 18.04 | 24x7serversupport Blog","description":"How to install MariaDB on Ubuntu 18.04","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.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","og_locale":"en_US","og_type":"article","og_title":"How to install MariaDB on Ubuntu 18.04 | 24x7serversupport Blog","og_description":"How to install MariaDB on Ubuntu 18.04","og_url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","og_site_name":"24x7serversupport Blog","article_published_time":"2019-06-13T06:58:29+00:00","article_modified_time":"2019-06-16T07:48:59+00:00","author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","name":"How to install MariaDB on Ubuntu 18.04 | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"datePublished":"2019-06-13T06:58:29+00:00","dateModified":"2019-06-16T07:48:59+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"description":"How to install MariaDB on Ubuntu 18.04","breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to install MariaDB on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=2589"}],"version-history":[{"count":4,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2589\/revisions"}],"predecessor-version":[{"id":2597,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2589\/revisions\/2597"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=2589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=2589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=2589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}