{"id":28980,"date":"2018-11-09T13:48:23","date_gmt":"2018-11-09T19:48:23","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=28980"},"modified":"2022-12-09T06:10:49","modified_gmt":"2022-12-09T12:10:49","slug":"how-to-install-mariadb-on-ubuntu-16-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/","title":{"rendered":"How to Install MariaDB on Ubuntu 16.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"size-full wp-image-30872 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg\" alt=\"how to install mariadb on ubuntu 16.04\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-28986\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/installing-mariadb-on-ubuntu-16.04.jpg\" alt=\"installing mariadb on ubuntu 16.04\" width=\"150\" height=\"100\" \/> We&#8217;ll show you, how to install MariaDB on Ubuntu 16.04. MariaDB is a community-developed fork of MySQL. It is a free and open source, very fast, stable and scalable database server, which makes it one of the most used database servers in the world. It is an improved, drop-in replacement for popular MySQL Database Server. In this tutorial, we will show you how to install MariaDB on Ubuntu 16.04. Installing MariaDB on Ubuntu 16.04 is an easy task, and if you carefully follow the steps of this tutorial, you should have MariaDB installed on your Ubuntu 16.04 server in less than 10 minutes. Let&#8217;s get started.<\/p>\n<p><!--more--><\/p>\n<h2><img decoding=\"async\" class=\"size-full wp-image-30873 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-in-ubuntu-16.04.jpg\" alt=\"How to Install the MariaDB on Ubuntu 16.04\" width=\"750\" height=\"212\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-in-ubuntu-16.04.jpg 750w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-in-ubuntu-16.04-150x42.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-in-ubuntu-16.04-300x85.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/h2>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_1 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69c29c0584364\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69c29c0584364\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#1-Connect-to-your-server\" >1. Connect to your server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#2-Update-your-system\" >2. Update your system<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#3-Installing-MariaDB-on-Ubuntu-1604\" >3. Installing MariaDB on Ubuntu 16.04<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#4-Securing-your-MariaDB-installation-on-Ubuntu-1604\" >4. Securing your MariaDB installation on Ubuntu 16.04<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#5-Connect-to-MariaDB\" >5. Connect to MariaDB<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1-Connect-to-your-server\"><\/span>1. Connect to your server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First, you will need to login to your server via SSH as user root:<\/p>\n<pre>ssh root@IP_ADDRESS -p PORT_NUMBER<\/pre>\n<p>and replace &#8220;IP_ADDRESS&#8221; and &#8220;PORT_NUMBER&#8221; with your actual server IP address and SSH port number.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2-Update-your-system\"><\/span>2. Update your system<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we start, let&#8217;s make sure your system is up-to-date by running the following commands:<\/p>\n<pre>apt-get update\r\napt-get upgrade<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-Installing-MariaDB-on-Ubuntu-1604\"><\/span>3. Installing MariaDB on Ubuntu 16.04<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we start with the MariaDB Server installation, you will need to add the official MariaDB repository.<\/p>\n<p>First, install the <code>software-properties-common<\/code> package to your server with the following command:<\/p>\n<pre>apt-get install software-properties-common<\/pre>\n<p>Next, import the MariaDB GnuPG signing key to your system, by executing the following command:<\/p>\n<pre>apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8<\/pre>\n<p>And finally, add the MariaDB repository with:<\/p>\n<pre>add-apt-repository 'deb [arch=amd64,arm64,i386,ppc64el] http:\/\/mirror.nodesdirect.com\/mariadb\/repo\/10.3\/ubuntu xenial main'<\/pre>\n<p>To be able to initiate the MariaDB installation from the newly added repository, you will now need to update the package list with:<\/p>\n<pre>apt-get update<\/pre>\n<p>You can now install MariaDB on your server with:<\/p>\n<pre>apt-get install mariadb-server<\/pre>\n<p>Once the installation is complete, the MariaDB service will be started automatically. To verify if the service is running on your system, you can run the following command:<\/p>\n<pre>systemctl status mariadb<\/pre>\n<p>You should see the following output on your screen:<\/p>\n<pre>\u25cf mariadb.service - MariaDB 10.3.10 database server\r\nLoaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\r\nDrop-In: \/etc\/systemd\/system\/mariadb.service.d\r\n\u2514\u2500migrated-from-my.cnf-settings.conf\r\nActive: active (running) since Sat 2018-10-27 13:37:11 CDT; 1h 3min ago\r\nDocs: man:mysqld(8)\r\nhttps:\/\/mariadb.com\/kb\/en\/library\/systemd\/\r\nMain PID: 15152 (mysqld)\r\nStatus: \"Taking your SQL requests now...\"\r\nCGroup: \/system.slice\/mariadb.service\r\n\u2514\u250015152 \/usr\/sbin\/mysqld<\/pre>\n<p>And to check the MariaDB version you can type:<\/p>\n<pre>mysql\u00a0 -V\r\nmysql  Ver 15.1 Distrib 10.3.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2\r\n\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"4-Securing-your-MariaDB-installation-on-Ubuntu-1604\"><\/span>4. Securing your MariaDB installation on Ubuntu 16.04<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After the installation is complete, you can improve the security of your MariaDB server, by running the\u00a0<code>mysql_secure_installation<\/code> script, using the following command:<\/p>\n<pre>mysql_secure_installation<\/pre>\n<p>You will be asked to enter your current password for the MariaDB root user. If you did not set any password during the installation, you can just leave it blank and press Enter:<\/p>\n<pre>In order to log into MariaDB to secure it, we'll need the current\r\npassword for the root user. If you've just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank,\r\nso you should just press enter here.\r\n\r\nEnter current password for root (enter for none):<\/pre>\n<p>You can then choose to change your root password or leave it as it is.<\/p>\n<pre>Setting the root password ensures that nobody can log into the MariaDB\r\nroot user without the proper authorisation.\r\n\r\nYou already have a root password set, so you can safely answer 'n'.\r\n\r\nChange the root password? [Y\/n]<\/pre>\n<p>After this, you will get asked a couple of more questions and it is recommended that you answer \u2018yes\u2019 to all of them:<\/p>\n<pre>Remove anonymous users? [Y\/n]\r\n\r\nDisallow root login remotely? [Y\/n]\r\n\r\nRemove test database and access to it? [Y\/n]\r\n\r\nReload privilege tables now? [Y\/n]<\/pre>\n<p>Once you complete all the steps, the following output will be displayed on your screen:<\/p>\n<pre>All done! If you've completed all of the above steps, your MariaDB\r\ninstallation should now be secure.\r\n\r\nThanks for using MariaDB!<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"5-Connect-to-MariaDB\"><\/span>5. Connect to MariaDB<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now after you are done with installing and securing MariaDB, you can type the following command to connect to your MariaDB server:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>You will be asked for your MariaDB root password that has been set during the installation or during the\u00a0<code>mysql_secure_installation<\/code> script.<\/p>\n<p>This will grant you access to the MariaDB shell:<\/p>\n<pre>Welcome to the MariaDB monitor. Commands end with ; or \\g.\r\nYour MariaDB connection id is 21\r\nServer version: 10.3.10-MariaDB-1:10.3.10+maria~xenial-log mariadb.org binary distribution\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]&gt;\r\n<\/pre>\n<p>And that&#8217;s it, with the completion of this step we are done installing MariaDB on Ubuntu 16.04.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-28987\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/install-mariadb-on-ubuntu-16.04.jpg\" alt=\"install mariadb on ubuntu 16.04\" width=\"150\" height=\"100\" \/> Of course, you don\u2019t have to\u00a0<strong>install MariaDB on Ubuntu 16.04<\/strong>, if you use one of our\u00a0<a href=\"https:\/\/www.rosehosting.com\/mariadb-hosting.html\">MariaDB Hosting services<\/a>, in which case you can simply ask our expert Linux admins to install and configure MariaDB on your Ubuntu 16.04 server. They are available <strong>24\u00d77<\/strong> and will take care of the installation and configuration immediately.<\/p>\n<p><span style=\"color: #ff0000;\">PS.<\/span> If you liked this post on<strong> Installing MariaDB on Ubuntu 16.04<\/strong>, please share it with your friends on the social networks using the buttons below or simply leave a reply. Thanks.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;ll show you, how to install MariaDB on Ubuntu 16.04. MariaDB is a community-developed fork of MySQL. It is a &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install MariaDB on Ubuntu 16.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#more-28980\" aria-label=\"Read more about How to Install MariaDB on Ubuntu 16.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":30872,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,13,1698],"tags":[296,59],"class_list":["post-28980","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-tutorials","category-ubuntu","tag-mariadb","tag-ubuntu","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.1 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install MariaDB on Ubuntu 16.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to Install MariaDB on Ubuntu 16.04 | RoseHosting\" \/>\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.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-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 16.04\" \/>\n<meta property=\"og:description\" content=\"How to Install MariaDB on Ubuntu 16.04 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-09T19:48:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-09T12:10:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install MariaDB on Ubuntu 16.04\",\"datePublished\":\"2018-11-09T19:48:23+00:00\",\"dateModified\":\"2022-12-09T12:10:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/\"},\"wordCount\":565,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg\",\"keywords\":[\"mariadb\",\"ubuntu\"],\"articleSection\":[\"Databases\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/\",\"name\":\"How to Install MariaDB on Ubuntu 16.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg\",\"datePublished\":\"2018-11-09T19:48:23+00:00\",\"dateModified\":\"2022-12-09T12:10:49+00:00\",\"description\":\"How to Install MariaDB on Ubuntu 16.04 | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg\",\"width\":742,\"height\":372,\"caption\":\"how to install mariadb on ubuntu 16.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install MariaDB on Ubuntu 16.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Install MariaDB on Ubuntu 16.04 | RoseHosting","description":"How to Install MariaDB on Ubuntu 16.04 | RoseHosting","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.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install MariaDB on Ubuntu 16.04","og_description":"How to Install MariaDB on Ubuntu 16.04 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2018-11-09T19:48:23+00:00","article_modified_time":"2022-12-09T12:10:49+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install MariaDB on Ubuntu 16.04","datePublished":"2018-11-09T19:48:23+00:00","dateModified":"2022-12-09T12:10:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/"},"wordCount":565,"commentCount":1,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg","keywords":["mariadb","ubuntu"],"articleSection":["Databases","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/","name":"How to Install MariaDB on Ubuntu 16.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg","datePublished":"2018-11-09T19:48:23+00:00","dateModified":"2022-12-09T12:10:49+00:00","description":"How to Install MariaDB on Ubuntu 16.04 | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/how-to-install-mariadb-on-ubuntu-16.04.jpg","width":742,"height":372,"caption":"how to install mariadb on ubuntu 16.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mariadb-on-ubuntu-16-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install MariaDB on Ubuntu 16.04"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/28980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=28980"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/28980\/revisions"}],"predecessor-version":[{"id":43951,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/28980\/revisions\/43951"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/30872"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=28980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=28980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=28980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}