Forked from MySQL, MariaDB has been known to be a drop-in replacement that brings enhancements and performance optimizations over MySQL. This tutorial will show you how to install MariaDB onto Ubuntu 14.04 in two ways.<\/p>\n

Step 1: Download\/Install MariaDB<\/h2>\n

Install from repository<\/h3>\n

This is straightforward, simply run the following:<\/p>\n

apt-get update -y\r\napt-get install mariadb-server\r\n<\/code><\/pre>\n
Manual install from MariaDB mirror (latest version)<\/h3>\n
Ubuntu server doesn’t ship with a way to add repositories from the command line. The following commands install the MariaDB repository onto your server and install MariaDB:<\/p>\n
apt-get install software-properties-common \r\napt-key adv --recv-keys -keyserver hkp:\/\/keyserver.ubuntu.com:80 0xcbcb082a1bb943db \r\nadd-apt-repository 'deb http:\/\/mirror.jmu.edu\/pub\/mariadb\/repo\/10.1\/ubuntu trusty main'\r\n<\/code><\/pre>\n
If you do not wish to execute the previous commands, you could alternatively create a file in\u00a0\/etc\/apt\/sources.list.d\/<\/code>\u00a0and populate it with these contents:<\/p>\n
deb http:\/\/mirror.jmu.edu\/pub\/mariadb\/repo\/10.1\/ubuntu trusty main \r\ndeb-src http:\/\/mirror.jmu.edu\/pub\/mariadb\/repo\/10.1\/ubuntu trusty main\r\n<\/code><\/pre>\n
Next, run the following commands:<\/p>\n
apt-get update\r\napt-get install mariadb-server\r\n<\/code><\/pre>\n
Finish the installation by running:<\/p>\n
\/usr\/bin\/mysql_secure_installation\r\n<\/code><\/pre>\n
If everything is successful, you can proceed to the next step.<\/p>\n
Step 2: Verify that MariaDB is operational<\/h2>\n
After installation, run\u00a0mysql -u root -p<\/code>. Enter your password when prompted. You will see output similar to the following:<\/p>\n
Welcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is XXXX\r\nServer version: 5.5.X\r\n\r\n\r\nCopyright (c) 2000, 2014, Oracle, Monty Program Ab and others.\r\n\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\n\r\nMariaDB [(none)]> \r\n<\/code><\/pre>\n
Congratulations, you have successfully installed MariaDB. If you instead received an error, retry by running the following command:<\/p>\n
service mysql start\r\n<\/code><\/pre>\n
Enjoy!<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","manualknowledgebasecat":[110,242,247],"manual_kb_tag":[391],"_links":{"self":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2665"}],"collection":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/comments?post=2665"}],"version-history":[{"count":1,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2665\/revisions"}],"predecessor-version":[{"id":2666,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb\/2665\/revisions\/2666"}],"wp:attachment":[{"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/media?parent=2665"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manualknowledgebasecat?post=2665"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/support.aklwebhost.com\/wp-json\/wp\/v2\/manual_kb_tag?post=2665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}