{"id":1185,"date":"2020-03-14T15:49:17","date_gmt":"2020-03-14T20:49:17","guid":{"rendered":"https:\/\/www.linuxcloudvps.com\/blog\/?p=1185"},"modified":"2020-03-14T15:49:17","modified_gmt":"2020-03-14T20:49:17","slug":"how-to-install-mariadb-on-debian-9","status":"publish","type":"post","link":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-debian-9\/","title":{"rendered":"How to Install MariaDB on Debian 9"},"content":{"rendered":"

In this article, we will show you how to install MariaDB on a Debian 9 Cloud VPS<\/a>.<\/p>\n

\"\"MariaDB is a free and open-source, backwards-compatible, enhanced and drop-in replacement of the popular MySQL database management server software. It is very fast, stable, and scalable, making this database server ideal for almost everyone, which is why it’s one of the most used database servers in the world. Let’s get started with the installation.<\/span><\/p>\n

<\/p>\n

Step 1. Log into your Server<\/h2>\n

First things first, login to your Debian 9 Cloud VPS via SSH as the root user:<\/p>\n

ssh root@<span style="color: #ff0000;">IP_Address<\/span> -p <span style="color: #ff0000;">Port_number<\/span><\/pre>\n
Make sure to replace IP_Address<\/span> and Port_number<\/span> with your server’s IP and SSH port.<\/p>\n
Step 2. Install MariaDB<\/h2>\n
Method 1. Install from the Debian Repository<\/h3>\n
Installing MariaDB from the Debian base repository is a straightforward method of installing MariaDB, but doing this may lead to an older version being installed. If you need the latest version of MariaDB, you can install it through the official MariaDB repository, as shown in Method 2<\/strong>.<\/p>\n
sudo apt update\r\nsudo apt -y install mariadb-server mariadb-client<\/pre>\n
Run the command\u00a0mysql_secure_installation<\/code> to perform the initial setup of MariaDB server once you’ve installed it. Let’s see how:<\/p>\n
Method 2. Install MariaDB from MariaDB Repositories<\/h3>\n
Before continuing with the installation you can visit the MariaDB Repository page and check the latest MariaDB version. At the time of writing this article, the latest version of MariaDB was 10.3.<\/p>\n
To install MariaDB 10.3 on your Debian 9 system, follow these steps:<\/p>\n
The first step is to enable the MariaDB repository and import the repository GPG key to your system. To do so, run the following commands:<\/p>\n
sudo apt install software-properties-common dirmngrsudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8\r\nsudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http:\/\/mirrors.dotsrc.org\/mariadb\/repo\/10.3\/debian stretch main'<\/pre>\n
Once the repository is enabled, update the packages list and install MariaDB with these next two commands:<\/p>\n
sudo apt update\r\nsudo apt install mariadb-server<\/pre>\n
In case you want to start\/stop MariaDB, you can use the following commands.<\/p>\n
sudo systemctl start mariadb\r\nsudo systemctl stop mariadb<\/pre>\n
Let’s verify that MariaDB is running.<\/p>\n
sudo systemctl status mariadb<\/pre>\n
\u25cf mariadb.service - MariaDB 10.3.8 database server\r\n    Loaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\r\n    Drop-In: \/etc\/systemd\/system\/mariadb.service.d\r\n            \u2514\u2500migrated-from-my.cnf-settings.conf\r\n    Active: active (running) since Sun 2018-07-29 19:36:30 UTC; 56s ago\r\n        Docs: man:mysqld(8)\r\n            https:\/\/mariadb.com\/kb\/en\/library\/systemd\/\r\n    Main PID: 16417 (mysqld)\r\n    Status: "Taking your SQL requests now..."\r\n        Tasks: 31 (limit: 507)\r\n    CGroup: \/system.slice\/mariadb.service\r\n            \u2514\u250016417 \/usr\/sbin\/mysqld<\/pre>\n
To enable the MariaDB service on system boot, run the following command:<\/p>\n
systemctl enable mariadb<\/pre>\n
In case you want MariaDB disabled on system boot, run the following command:<\/p>\n
systemctl disable mariadb<\/pre>\n
Step 3. Secure MySQL Installation<\/h2>\n
Execute the following command on your server.\u00a0 For the highest level of security, answer all prompts with\u00a0yes<\/strong> by entering the character “y<\/strong>“.<\/p>\n
sudo mysql_secure_installation\r\n<\/pre>\n
This program enables you to improve the security of your MariaDB installation in the following ways:<\/p>\n
    \n
  1. Sets a password for root accounts.<\/li>\n
  2. Remove root accounts that are accessible from outside the local host.<\/li>\n
  3. Removes anonymous user accounts.<\/li>\n
  4. Removes the test database.<\/li>\n<\/ol>\n
    The script is fully interactive and prompts for each step in the process.<\/p>\n
    Now that MariaDB is installed and secured, let’s go over logging into the MariaDB CLI.<\/p>\n
    Connect to MariaDB from the Command Line<\/h2>\n
    To connect to the MariaDB server through the terminal using the root account, type and execute the following command:<\/p>\n
    mysql -u root -p<\/pre>\n
    You will be prompted to enter the root password you have previously set up using the mysql_secure_installation<\/code> script.<\/p>\n
    Once you enter the password, you should be able to see the following output:<\/p>\n
    Welcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MariaDB connection id is 5635\r\nServer version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1\r\n\r\nCopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]><\/pre>\n
    You can now create a database by typing the following command:<\/p>\n
    CREATE DATABASE your_database;\r\nCREATE USER 'your_user'@'localhost' IDENTIFIED BY 'password'; \r\nGRANT ALL PRIVILEGES ON your_database.* TO your_user@localhost; \r\nFLUSH PRIVILEGES; \r\nquit<\/pre>\n
    To view MariaDB\u2019s command list from within the client, type:<\/p>\n
    \\h<\/pre>\n
    General information about MariaDB can be found at\r\n
    MariaDB Foundation<\/a><\/blockquote>