{"id":5240,"date":"2016-09-06T10:59:55","date_gmt":"2016-09-06T10:59:55","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=5240"},"modified":"2021-02-03T07:25:02","modified_gmt":"2021-02-03T07:25:02","slug":"install-upgrade-mariadb-10-1-12-ubuntu-debian-mint","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/","title":{"rendered":"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint"},"content":{"rendered":"

MariaDB is a drop-in alternative for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. MariaDB provides more storage engines than MySQL, such as Cassandra (NoSQL, in MariaDB Edition 10), XtraDB (drop-in alternative for InnoDB), and OQGRAPH (in MariaDB Edition 10).<\/p>\n

PREREQUISITIES<\/h2>\n
    \n
  1. These guidelines are intended for Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian<\/a> & Mint<\/li>\n
  2. SSH client like Putty<\/a> and proper knowledge to use it.<\/li>\n
  3. Some basic knowledge about common Linux commands.<\/li>\n
  4. 20 minutes of your time with a cup of tea or coffee as always.<\/li>\n<\/ol>\n

    Step 1- Add MariaDB Repositories<\/h2>\n

    By default MariaDB 5.x<\/a> Series included all the Linux distributions and removed MySQL but they didn\u2019t include MariaDB 10.x series. Use the below instructions to add MariaDB Repositories on Ubuntu<\/a>, Debian & Mint.
    \nFor Debian Systems<\/strong><\/p>\n

    \n
    apt-get install software-properties-common\r\napt-key adv --recv-keys --keyserver keyserver.ubuntu.com \r\n0xcbcb082a1bb943db\r\nadd-apt-repository 'deb [arch=amd64,i386] http:\/\/mirrors.opencas.cn\/\r\nmariadb\/repo\/10.1\/debian '$(lsb_release -cs)' main'<\/pre>\n<\/div>\n
    For Ubuntu Systems<\/strong><\/p>\n
    \n
    apt-get install software-properties-common\r\napt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 \r\n0xcbcb082a1bb943db\r\nadd-apt-repository 'deb [arch=amd64,i386] http:\/\/mirrors.opencas.cn\r\n\/mariadb\/repo\/10.1\/ubuntu '$(lsb_release -cs)' main'<\/pre>\n<\/div>\n
    For Mint Systems<\/strong><\/p>\n
    \n
    apt-get install software-properties-common\r\napt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 \r\n0xcbcb082a1bb943db\r\nadd-apt-repository 'deb http:\/\/mirrors.opencas.cn\/mariadb\r\n\/repo\/10.1\/ubuntu trusty main'<\/pre>\n<\/div>\n
    Step 2 – Update System Repository Index<\/h2>\n
    We have added MariaDB Repository and to make it available for system, we have to refresh the system repository.<\/p>\n
    \n
    apt-get update<\/pre>\n<\/div>\n
    Step 3 – Install MariaDB<\/h2>\n
    Once done, just run the below command to install MariaDB 10 on your systems.<\/p>\n
    \n
    apt-get install mariadb-server<\/pre>\n<\/div>\n
    During installation process, it will ask you to set root password<\/a> for MariaDB.
    \nConfirm the root password for MariaDB.<\/p>\n
    Step 4 – Start MariaDB Service<\/h2>\n
    Next Use the below command to start MariaDB server.<\/p>\n
    \n
    For SysVinit Systems \r\nservice mysql start\r\nFor systemd Systems\r\nsystemctl start mysql.service<\/pre>\n<\/div>\n
    Step 5 – Access MariaDB<\/h2>\n
    Now use the below command to access MariaDB service.<\/p>\n
    \n
    mysql -u root -p\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 2\r\nServer version: 10.1.11-MariaDB-1~jessie mariadb.org binary distribution\r\nCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current \r\ninput statement.\r\nMariaDB [(none)]><\/pre>\n<\/div>\n
    Step 6- How to Upgrade MariaDB<\/h2>\n
    Use the below command to Upgrade MariaDB service for new release<\/p>\n
    \n
    apt-get install --only-upgrade mariadb-server<\/pre>\n<\/div>\n
    So this is all you have to do,\u00a0Also read about\u00a0MariaDB 10.1\u00a0<\/strong>installation <\/a>on CentOS, RHEL & Fedora Systems.Please Give your opinion below if you experience any issues or to discuss your ideas and experiences.<\/p>\n","protected":false},"excerpt":{"rendered":"
    MariaDB is a drop-in alternative for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. […]<\/p>\n
    Continue Reading…<\/a><\/p>\n","protected":false},"author":2,"featured_media":5235,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-5240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"yoast_head":"\nInstall & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"MariaDB is a drop-in alternative for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. [...]Continue Reading...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\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:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint\",\"datePublished\":\"2016-09-06T10:59:55+00:00\",\"dateModified\":\"2021-02-03T07:25:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/\"},\"wordCount\":285,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg\",\"articleSection\":[\"Linux\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/\",\"name\":\"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg\",\"datePublished\":\"2016-09-06T10:59:55+00:00\",\"dateModified\":\"2021-02-03T07:25:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg\",\"width\":225,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint - cPanel Plesk","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:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/","twitter_card":"summary_large_image","twitter_title":"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint - cPanel Plesk","twitter_description":"MariaDB is a drop-in alternative for MySQL. MariaDB is an opensource Relational Database Management System (RDBMS) which supports database access. [...]Continue Reading...","twitter_image":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint","datePublished":"2016-09-06T10:59:55+00:00","dateModified":"2021-02-03T07:25:02+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/"},"wordCount":285,"commentCount":0,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg","articleSection":["Linux"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/","url":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/","name":"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg","datePublished":"2016-09-06T10:59:55+00:00","dateModified":"2021-02-03T07:25:02+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#primaryimage","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/09\/Install-Upgrade-MariaDB-10.1.12-on-Centos-RHEL-Fedora.jpg","width":225,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/install-upgrade-mariadb-10-1-12-ubuntu-debian-mint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"Install & Upgrade MariaDB 10.1.12 on Ubuntu, Debian & Mint"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=5240"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/5240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media\/5235"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=5240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=5240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=5240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}