{"id":1978,"date":"2016-02-24T09:32:02","date_gmt":"2016-02-24T09:32:02","guid":{"rendered":"https:\/\/www.botreetechnologies.com\/blog\/?p=1978"},"modified":"2022-12-13T16:14:40","modified_gmt":"2022-12-13T10:44:40","slug":"how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails","status":"publish","type":"post","link":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/","title":{"rendered":"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><a href=\"https:\/\/mariadb.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">MariaDB<\/a>&nbsp;is a community-developed fork of the&nbsp;<a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">MySQL<\/a> relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle &#8211; <em><strong>Wikipedia<\/strong><\/em><\/p><\/blockquote>\n\n\n\n<p><b>Install<\/b> <b>MariaDB<\/b> (on 14.04.4 LTS (Trusty Tahr))<\/p>\n\n\n\n<p>Installation is super easy. Execute the following command in your terminal, one by one in sequence:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt-get install software-properties-common\n\n$ sudo apt-key adv --recv-keys --keyserver \nhkp:\/\/keyserver.ubuntu.com:80 0xcbcb082a1bb943db\n\n$ sudo add-apt-repository 'deb \nhttp:\/\/ftp.osuosl.org\/pub\/mariadb\/repo\/10.0\/ubuntu trusty main'\n\n$ sudo apt-get update\n\n$ sudo apt-get install mariadb-server\n<\/pre>\n\n\n\n<p>Checkout&nbsp;<a href=\"https:\/\/downloads.mariadb.org\/mariadb\/repositories\/\" target=\"_blank\" rel=\"noopener noreferrer\">MariaDB Download page<\/a>&nbsp;to find instructions to install for different linux distros.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Configure Rails<\/h2>\n\n\n\n<p>First you have to install client libraries to connect to MariaDB<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt-get install libmariadbd-dev<\/pre>\n\n\n\n<p>Now add&nbsp;<code>mysql2 gem<\/code>&nbsp;to the&nbsp;<code>Gemfile<\/code> run&nbsp;<code>bundle install.<\/code><\/p>\n\n\n\n<p>Next you will have to configure database.yml which will look like<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">development:\n adapter: mysql2\n encoding: utf8\n pool: 5\n min_messages: warning\n timeout: 5000\n username: root\n password: root\n socket: \/var\/run\/mysqld\/mysqld.sock<\/pre>\n\n\n\n<p>The username and password in above configuration is the one that you configure while installing MariaDB.<\/p>\n\n\n\n<p>That&#8217;s all. Now restart your rails server and start over!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/www.botreetechnologies.com\/ruby-on-rails-development\" target=\"_blank\" rel=\"noopener noreferrer\">Click here for more details&#8230;<\/a><\/h3>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>At <a href=\"https:\/\/www.botreetechnologies.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">BoTree Technologies<\/a>, we build enterprise applications with our RoR team of 25+ engineers.<\/p>\n\n\n\n<p>We also specialize in RPA, AI, Python, Django, JavaScript and ReactJS.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><a href=\"https:\/\/www.botreetechnologies.com\/contact\" target=\"_blank\" rel=\"noopener noreferrer\">Consulting is free<\/a> &#8211; let us help you grow!<\/h3>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB&nbsp;is a community-developed fork of the&nbsp;MySQL relational database management system&#8230;<\/p>\n","protected":false},"author":3,"featured_media":14001,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,10],"tags":[],"class_list":["post-1978","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ruby-on-rails","category-technology"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Install Mariadb on Ubuntu and Connect Ruby on Rails?<\/title>\n<meta name=\"description\" content=\"Learn more about how to install mariadb on Ubuntu and connect ruby on rails? MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.\" \/>\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.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\" \/>\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 and Connect Ruby on Rails?\" \/>\n<meta property=\"og:description\" content=\"Learn more about how to install mariadb on Ubuntu and connect ruby on rails? MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\" \/>\n<meta property=\"og:site_name\" content=\"BoTree Technologies\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BoTreeTechnologies\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-24T09:32:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-13T10:44:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Amit Patel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@BoTreeTech\" \/>\n<meta name=\"twitter:site\" content=\"@BoTreeTech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amit Patel\" \/>\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.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\"},\"author\":{\"name\":\"Amit Patel\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/#\/schema\/person\/86645099906a429b0c5ca4de2bf92c46\"},\"headline\":\"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?\",\"datePublished\":\"2016-02-24T09:32:02+00:00\",\"dateModified\":\"2022-12-13T10:44:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\"},\"wordCount\":194,\"image\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg\",\"articleSection\":[\"Ruby on Rails\",\"Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\",\"url\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\",\"name\":\"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?\",\"isPartOf\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg\",\"datePublished\":\"2016-02-24T09:32:02+00:00\",\"dateModified\":\"2022-12-13T10:44:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/#\/schema\/person\/86645099906a429b0c5ca4de2bf92c46\"},\"description\":\"Learn more about how to install mariadb on Ubuntu and connect ruby on rails? MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage\",\"url\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg\",\"contentUrl\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg\",\"width\":1920,\"height\":1280,\"caption\":\"Install Mariadb on Ubuntu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.botreetechnologies.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/#website\",\"url\":\"https:\/\/www.botreetechnologies.com\/blog\/\",\"name\":\"BoTree Technologies\",\"description\":\"Committed to inspire generation.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.botreetechnologies.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/#\/schema\/person\/86645099906a429b0c5ca4de2bf92c46\",\"name\":\"Amit Patel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2020\/10\/amit-patel-1-150x150.png\",\"url\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2020\/10\/amit-patel-1-150x150.png\",\"contentUrl\":\"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2020\/10\/amit-patel-1-150x150.png\",\"caption\":\"Amit Patel\"},\"description\":\"Amit is the COO and Co-founder of BoTree Technologies. He is a developer advocate and solution architect at the company. He has helped many SME and Large corporations digitize their business operations. He loves hanging out with friends and meditate.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?","description":"Learn more about how to install mariadb on Ubuntu and connect ruby on rails? MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.","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.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/","og_locale":"en_US","og_type":"article","og_title":"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?","og_description":"Learn more about how to install mariadb on Ubuntu and connect ruby on rails? MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.","og_url":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/","og_site_name":"BoTree Technologies","article_publisher":"https:\/\/www.facebook.com\/BoTreeTechnologies\/","article_published_time":"2016-02-24T09:32:02+00:00","article_modified_time":"2022-12-13T10:44:40+00:00","og_image":[{"width":1920,"height":1280,"url":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg","type":"image\/jpeg"}],"author":"Amit Patel","twitter_card":"summary_large_image","twitter_creator":"@BoTreeTech","twitter_site":"@BoTreeTech","twitter_misc":{"Written by":"Amit Patel","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#article","isPartOf":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/"},"author":{"name":"Amit Patel","@id":"https:\/\/www.botreetechnologies.com\/blog\/#\/schema\/person\/86645099906a429b0c5ca4de2bf92c46"},"headline":"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?","datePublished":"2016-02-24T09:32:02+00:00","dateModified":"2022-12-13T10:44:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/"},"wordCount":194,"image":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage"},"thumbnailUrl":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg","articleSection":["Ruby on Rails","Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/","url":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/","name":"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?","isPartOf":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage"},"image":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage"},"thumbnailUrl":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg","datePublished":"2016-02-24T09:32:02+00:00","dateModified":"2022-12-13T10:44:40+00:00","author":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/#\/schema\/person\/86645099906a429b0c5ca4de2bf92c46"},"description":"Learn more about how to install mariadb on Ubuntu and connect ruby on rails? MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.","breadcrumb":{"@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#primaryimage","url":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg","contentUrl":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2016\/02\/how-to-install-mariadb.jpg","width":1920,"height":1280,"caption":"Install Mariadb on Ubuntu"},{"@type":"BreadcrumbList","@id":"https:\/\/www.botreetechnologies.com\/blog\/how-to-install-mariadb-on-ubuntu-14-04-lts-and-connect-ruby-on-rails\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.botreetechnologies.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install Mariadb on Ubuntu and Connect Ruby on Rails?"}]},{"@type":"WebSite","@id":"https:\/\/www.botreetechnologies.com\/blog\/#website","url":"https:\/\/www.botreetechnologies.com\/blog\/","name":"BoTree Technologies","description":"Committed to inspire generation.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.botreetechnologies.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.botreetechnologies.com\/blog\/#\/schema\/person\/86645099906a429b0c5ca4de2bf92c46","name":"Amit Patel","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2020\/10\/amit-patel-1-150x150.png","url":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2020\/10\/amit-patel-1-150x150.png","contentUrl":"https:\/\/www.botreetechnologies.com\/blog\/wp-content\/uploads\/2020\/10\/amit-patel-1-150x150.png","caption":"Amit Patel"},"description":"Amit is the COO and Co-founder of BoTree Technologies. He is a developer advocate and solution architect at the company. He has helped many SME and Large corporations digitize their business operations. He loves hanging out with friends and meditate."}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/1978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/comments?post=1978"}],"version-history":[{"count":3,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/1978\/revisions"}],"predecessor-version":[{"id":18260,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/posts\/1978\/revisions\/18260"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/media\/14001"}],"wp:attachment":[{"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/media?parent=1978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/categories?post=1978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.botreetechnologies.com\/blog\/wp-json\/wp\/v2\/tags?post=1978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}