{"id":164,"date":"2016-10-20T04:21:27","date_gmt":"2016-10-20T04:21:27","guid":{"rendered":"https:\/\/pure-media.info\/?p=164"},"modified":"2017-04-06T03:51:36","modified_gmt":"2017-04-06T03:51:36","slug":"install-mariadb-10-1-stable-on-ubuntu-14-04","status":"publish","type":"post","link":"https:\/\/pure-media.info\/index.php\/2016\/10\/20\/install-mariadb-10-1-stable-on-ubuntu-14-04\/","title":{"rendered":"Install MariaDB 10.1 Stable on Ubuntu 14.04"},"content":{"rendered":"

MariaDB is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.<\/p>\n

MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases.<\/p>\n

MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features.<\/p>\n

First we need to install the Distro Keys to allow the install of MariaDB using the repo.\n<\/p>\n

sudo apt-get install software-properties-common\r\nsudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xcbcb082a1bb943db\r\nsudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] https:\/\/mirrors.evowise.com\/mariadb\/repo\/10.1\/ubuntu trusty main'<\/pre>\n
Now, We need to update the local package lists from the repositories and “updates” them to get information on the newest versions of packages and their dependencies. It will do this for all repositories and PPAs<\/p>\n
sudo apt-get update<\/pre>\n
Once the key is imported and the repository are updated you can install MariaDB<\/p>\n
sudo apt-get install mariadb-server<\/pre>\n
Now that it is installed we need to secure it. This program enables you to improve the security of your MariaDB installation in the following ways:<\/p>\n
    \n
  • You can set a password for root accounts.<\/li>\n
  • You can remove root accounts that are accessible from outside the local host.<\/li>\n
  • You can remove anonymous-user accounts.<\/li>\n
  • You can remove the test database, which by default can be accessed by anonymous users.<\/li>\n<\/ul>\n
    shell> mysql_secure_installation\r\n\r\nExample:\r\nlocalhost:# mysql_secure_installation<\/pre>\n
    Now you have Successfully installed MariaDB and its ready for Use!<\/p>\n
    If you have any questions or Issues please let me know in the comments below.<\/p>\n
     <\/p>\n
     <\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    MariaDB is one of the most popular database servers in the world. It’s made by the original developers of MySQL<\/p>\n","protected":false},"author":1,"featured_media":165,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[85],"tags":[76,235,234,117,40,43,10,229,232,230,233,19,11,231,5,228,9,8,236,7],"class_list":["post-164","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-tip","tag-14-04","tag-complete","tag-fast","tag-faster","tag-guide","tag-how-to","tag-install","tag-mariadb","tag-mysql","tag-root","tag-save","tag-secure","tag-setup","tag-shell","tag-ssh","tag-stable","tag-tahr","tag-trusty","tag-tutorial","tag-ubuntu"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/pure-media.info\/wp-content\/uploads\/2016\/10\/mariadb-ubuntu.png?fit=800%2C450&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7oBs4-2E","jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/posts\/164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/comments?post=164"}],"version-history":[{"count":0,"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/posts\/164\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/media\/165"}],"wp:attachment":[{"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/media?parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/categories?post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pure-media.info\/index.php\/wp-json\/wp\/v2\/tags?post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}