{"id":2530,"date":"2016-08-18T15:53:34","date_gmt":"2016-08-18T19:53:34","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=2530"},"modified":"2017-04-19T15:58:29","modified_gmt":"2017-04-19T19:58:29","slug":"install-mariadb-ubuntu-14","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/","title":{"rendered":"How to install MariaDB on Ubuntu 14"},"content":{"rendered":"

Many have begun to call MariaDB their go-to relational database management system. It started as a fork of MySQL in 2009. Since then, many features have been added \u2013 making it a necessity for companies like Google. These include better performance, new extensions, and \u2013 unlike MySQL \u2013 every component is open source.<\/p>\n

Getting Started<\/h2>\n

Confirm that you have the following before you follow this guide:
\n\u2022 1 Node (Cloud Server<\/a> or Dedicated Server<\/a>) running Ubuntu 14.
\n\u2022 Root access to the node or one sudo non-root user<\/p>\n

Tutorial<\/h2>\n

Make Sure Ubuntu Is Up to Date<\/strong>
\nThe first step is to update your server repositories. This ensures that the packages you receive are current, with patches for performance or security problems. Enter the following command and then your password when prompted.<\/p>\n

apt-get update && apt-get upgrade -y<\/code><\/p>\n

Install the MariaDB server package<\/strong>
\nNow that we\u2019re sure the most recent version is available, let\u2019s install it. Only one package is required: mariadb-server. Use apt-get to initiate the process.<\/p>\n

apt-get install mariadb-server -y<\/code><\/p>\n

The terminal will request your password and ask for permission to install dependencies. After this, MariaDB will prompt you for the password for the \u2018root\u2019 database administrator. Choose something strong, and wait for the process to complete.<\/p>\n

Secure Your Database Server<\/strong>
\nIt\u2019s not enough to have a strong password. Several easy changes should be made to ward off hackers. If you have used MySQL, then mysql_secure_installation may seem familiar. This tool guides you through steps to increase your database\u2019s security. Run the command<\/p>\n

mysql_secure_installation<\/code><\/p>\n

Then, consider making the following decisions:
\n\u2022 Keep the root password that was set earlier.
\n\u2022 Remove anonymous users.
\n\u2022 Disallow remote logins.
\n\u2022 Remove the test database.
\n\u2022 Reload privilege tables.<\/p>\n

Test Your Installation<\/strong>
\nProvided everything installed properly, you can log in using the commands below. Since MariaDB is a fork of MySQL, there are similarities.<\/p>\n

mysql -u root -p<\/code><\/p>\n

Welcome to the MariaDB monitor. Commands end with ; or \\g.
\nYour MariaDB connection id is 42
\nServer version: 5.5.49-MariaDB-1ubuntu0.14.04.1 (Ubuntu)
\nCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.
\nMariaDB [(none)]><\/code><\/p>\n

If you are greeted with a welcome message, your work is done.<\/p>\n

Conclusion<\/h2>\n

You now have a fully-functioning and secure MariaDB server. Much of the front-end interaction will be the same as what is found in MySQL. It\u2019s even possible to directly swap data from an existing MySQL database without problems; that\u2019s the power of open source.<\/p>\n

If found this guide helpful, please be sure to share it with friends. You can also take a look at our other guides where we cover topics such as networking, databases, and server applications.<\/p>\n","protected":false},"excerpt":{"rendered":"

Many have begun to call MariaDB their go-to relational database management system. It started as a fork of MySQL in 2009. Since then, many features have been added \u2013 making it a necessity for companies like Google. These include better performance, new extensions, and \u2013 unlike MySQL \u2013 every component is open source. Getting Started<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[],"class_list":["post-2530","post","type-post","status-publish","format-standard","hentry","category-database","operating_system-ubuntu-14-04"],"yoast_head":"\nHow to install MariaDB on Ubuntu 14 - Globo.Tech<\/title>\n<meta name=\"description\" content=\"This tutorial will show you how to install MariaDB on your Ubuntu 14 server. Read now & Try this relational database management system!\" \/>\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.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/\" \/>\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 14 - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"This tutorial will show you how to install MariaDB on your Ubuntu 14 server. Read now & Try this relational database management system!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-18T19:53:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-19T19:58:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2016\/09\/GloboTech-Logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"963\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/\"},\"author\":{\"name\":\"GloboTech Communications\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\"},\"headline\":\"How to install MariaDB on Ubuntu 14\",\"datePublished\":\"2016-08-18T19:53:34+00:00\",\"dateModified\":\"2017-04-19T19:58:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/\"},\"wordCount\":393,\"commentCount\":0,\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/\",\"url\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/\",\"name\":\"How to install MariaDB on Ubuntu 14 - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#website\"},\"datePublished\":\"2016-08-18T19:53:34+00:00\",\"dateModified\":\"2017-04-19T19:58:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"This tutorial will show you how to install MariaDB on your Ubuntu 14 server. Read now & Try this relational database management system!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-mariadb-ubuntu-14\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install MariaDB on Ubuntu 14\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#website\",\"url\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\\\/\\\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install MariaDB on Ubuntu 14 - Globo.Tech","description":"This tutorial will show you how to install MariaDB on your Ubuntu 14 server. Read now & Try this relational database management system!","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.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/","og_locale":"en_US","og_type":"article","og_title":"How to install MariaDB on Ubuntu 14 - Globo.Tech","og_description":"This tutorial will show you how to install MariaDB on your Ubuntu 14 server. Read now & Try this relational database management system!","og_url":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/","og_site_name":"Globo.Tech","article_published_time":"2016-08-18T19:53:34+00:00","article_modified_time":"2017-04-19T19:58:29+00:00","og_image":[{"width":1920,"height":963,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2016\/09\/GloboTech-Logo.png","type":"image\/png"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/#article","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/"},"author":{"name":"GloboTech Communications","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"headline":"How to install MariaDB on Ubuntu 14","datePublished":"2016-08-18T19:53:34+00:00","dateModified":"2017-04-19T19:58:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/"},"wordCount":393,"commentCount":0,"articleSection":["Database"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/","url":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/","name":"How to install MariaDB on Ubuntu 14 - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"datePublished":"2016-08-18T19:53:34+00:00","dateModified":"2017-04-19T19:58:29+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"This tutorial will show you how to install MariaDB on your Ubuntu 14 server. Read now & Try this relational database management system!","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/install-mariadb-ubuntu-14\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to install MariaDB on Ubuntu 14"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=2530"}],"version-history":[{"count":3,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2530\/revisions"}],"predecessor-version":[{"id":3000,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2530\/revisions\/3000"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=2530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=2530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=2530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}