{"id":3069,"date":"2018-11-11T23:45:58","date_gmt":"2018-11-11T23:45:58","guid":{"rendered":"https:\/\/www.appservgrid.com\/paw92\/?p=3069"},"modified":"2018-11-12T02:46:19","modified_gmt":"2018-11-12T02:46:19","slug":"how-to-install-mariadb-on-ubuntu-16-04","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2018\/11\/11\/how-to-install-mariadb-on-ubuntu-16-04\/","title":{"rendered":"How to Install MariaDB on Ubuntu 16.04"},"content":{"rendered":"

\"How<\/a><\/p>\n

How to install MariaDB on Ubuntu 16.04<\/p>\n

\"installing<\/a>MariaDB is a community-developed fork of MySQL. It is a free and open source, very fast, stable and scalable database server, which makes it one of the most used database servers in the world. It is an improved, drop-in replacement for popular MySQL Database Server. In this tutorial, we will show you how to install MariaDB on Ubuntu 16.04. Installing MariaDB on Ubuntu 16.04 is an easy task, and if you carefully follow the steps of this tutorial, you should have it installed on your system in less than 10 minutes. Let\u2019s get started.<\/p>\n

1. Connect to your server<\/h2>\n

First, you will need to login to your server via SSH as user root:<\/p>\n

ssh root@IP_ADDRESS -p PORT_NUMBER<\/p>\n

and replace \u201cIP_ADDRESS\u201d and \u201cPORT_NUMBER\u201d with your actual server IP address and SSH port number.<\/p>\n

2. Update your system<\/h2>\n

Before we start, let\u2019s make sure your system is up-to-date by running the following commands:<\/p>\n

apt-get update
\napt-get upgrade<\/p>\n

3. Install MariaDB on Ubuntu 16.04<\/h2>\n

Before we start with the MariaDB Server installation, you will need to add the official MariaDB repository.<\/p>\n

First, install the software-properties-common package to your server with the following command:<\/p>\n

apt-get install software-properties-common<\/p>\n

Next, import the MariaDB GnuPG signing key to your system, by executing the following command:<\/p>\n

apt-key adv –recv-keys –keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8<\/p>\n

And finally, add the MariaDB repository with:<\/p>\n

add-apt-repository ‘deb [arch=amd64,arm64,i386,ppc64el] http:\/\/mirror.nodesdirect.com\/mariadb\/repo\/10.3\/ubuntu xenial main’<\/p>\n

To be able to initiate the MariaDB installation from the newly added repository, you will now need to update the package list with:<\/p>\n

apt-get update<\/p>\n

You can now install MariaDB on your server with:<\/p>\n

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

Once the installation is complete, the MariaDB service will be started automatically. To verify if the service is running on your system, you can run the following command:<\/p>\n

systemctl status mariadb<\/p>\n

You should see the following output on your screen:<\/p>\n

\u25cf mariadb.service – MariaDB 10.3.10 database server
\nLoaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)
\nDrop-In: \/etc\/systemd\/system\/mariadb.service.d
\n\u2514\u2500migrated-from-my.cnf-settings.conf
\nActive: active (running) since Sat 2018-10-27 13:37:11 CDT; 1h 3min ago
\nDocs: man:mysqld(8)
\nhttps:\/\/mariadb.com\/kb\/en\/library\/systemd\/
\nMain PID: 15152 (mysqld)
\nStatus: “Taking your SQL requests now…”
\nCGroup: \/system.slice\/mariadb.service
\n\u2514\u250015152 \/usr\/sbin\/mysqld<\/p>\n

And to check the MariaDB version you can type:<\/p>\n

mysql -V
\nmysql Ver 15.1 Distrib 10.3.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2<\/p>\n

4. Securing your MariaDB installation<\/h2>\n

After the installation is complete, you can improve the security of your MariaDB server, by running the mysql_secure_installation script, using the following command:<\/p>\n

mysql_secure_installation<\/p>\n

You will be asked to enter your current password for the MariaDB root user. If you did not set any password during the installation, you can just leave it blank and press Enter:<\/p>\n

In order to log into MariaDB to secure it, we’ll need the current
\npassword for the root user. If you’ve just installed MariaDB, and
\nyou haven’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/p>\n

Enter current password for root (enter for none):<\/p>\n

You can then choose to change your root password or leave it as it is.<\/p>\n

Setting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.<\/p>\n

You already have a root password set, so you can safely answer ‘n’.<\/p>\n

Change the root password? [Y\/n]<\/p>\n

After this, you will get asked a couple of more questions and it is recommended that you answer \u2018yes\u2019 to all of them:<\/p>\n

Remove anonymous users? [Y\/n]<\/p>\n

Disallow root login remotely? [Y\/n]<\/p>\n

Remove test database and access to it? [Y\/n]<\/p>\n

Reload privilege tables now? [Y\/n]<\/p>\n

Once you complete all the steps, the following output will be displayed on your screen:<\/p>\n

All done! If you’ve completed all of the above steps, your MariaDB
\ninstallation should now be secure.<\/p>\n

Thanks for using MariaDB!<\/p>\n

5. Connect to MariaDB<\/h2>\n

Now after you are done with installing and securing MariaDB, you can type the following command to connect to your MariaDB server:<\/p>\n

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

You will be asked for your MariaDB root password that has been set during the installation or during the mysql_secure_installation script.<\/p>\n

This will grant you access to the MariaDB shell:<\/p>\n

Welcome to the MariaDB monitor. Commands end with ; or g.
\nYour MariaDB connection id is 21
\nServer version: 10.3.10-MariaDB-1:10.3.10+maria~xenial-log mariadb.org binary distribution<\/p>\n

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<\/p>\n

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.<\/p>\n

MariaDB [(none)]><\/p>\n

\"install<\/a>Of course, you don\u2019t have to install MariaDB on Ubuntu 16.04, if you use one of our MariaDB Hosting services<\/a>, in which case you can simply ask our expert Linux admins to install and configure MariaDB for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n

PS. If you liked this post on how to install MariaDB on Ubuntu 16.04, please share it with your friends on the social networks using the buttons below or simply leave a reply. Thanks.<\/p>\n

Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

How to install MariaDB on Ubuntu 16.04 MariaDB is a community-developed fork of MySQL. It is a free and open source, very fast, stable and scalable database server, which makes it one of the most used database servers in the world. It is an improved, drop-in replacement for popular MySQL Database Server. In this tutorial, … <\/p>\n

Continue reading “How to Install MariaDB on Ubuntu 16.04”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3069","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/3069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=3069"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/3069\/revisions"}],"predecessor-version":[{"id":3272,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/3069\/revisions\/3272"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=3069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=3069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=3069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}