{"id":767,"date":"2022-09-01T12:08:02","date_gmt":"2022-09-01T12:08:02","guid":{"rendered":"https:\/\/blog.ngocha.biz\/?p=767"},"modified":"2022-09-01T12:08:02","modified_gmt":"2022-09-01T12:08:02","slug":"install-mariadb-on-ubuntu","status":"publish","type":"post","link":"https:\/\/blog.ngocha.biz\/?p=767","title":{"rendered":"How to Install MariaDB on Ubuntu [Setup & Configurations]"},"content":{"rendered":"

In this blog, you will learn to install <\/strong>MariaDB<\/strong><\/a> on Ubuntu 20.04<\/strong> server using step-by-step guides including important MariaDB<\/strong> configurations.<\/p>\n

Install MariaDB on Ubuntu 20.04<\/h2>\n

Follow the steps given below for installing and configuring MariaDB.<\/p>\n

Step 1: Install the MariaDB server & Client<\/h3>\n

Update the server<\/p>\n

sudo apt update -y<\/code><\/pre>\n
As a recommended practice, we will add the official MariaDB apt repository<\/a> using the following script.<\/p>\n
curl -LsS https:\/\/r.mariadb.com\/downloads\/mariadb_repo_setup | sudo bash<\/code><\/pre>\n
Now, install MariaDB server and client.<\/p>\n
sudo apt-get install mariadb-server mariadb-client -y<\/code><\/pre>\n
Step 2: Validate MariaDB Installtion<\/h3>\n
First, let’s check the installed version of MariaDB using the following command.<\/p>\n
mysql -V<\/code><\/pre>\n
Now, let’s check MariaDB Service Status.<\/p>\n
sudo systemctl status mariadb<\/code><\/pre>\n
You should get an active status output as shown below.<\/p>\n
\"\"<\/figure>\n
Step 3: Secure MariaDB<\/h3>\n
The next step is to secure the MariaDB server by removing all the insecure configurations. Execute the following command to start the configuration.<\/p>\n
sudo mysql_secure_installation<\/code><\/pre>\n
You will be prompted with six questions. Choose options as shown below.<\/p>\n
    \n
  1. Enter current password for root (enter for none):<\/strong> Press enter as there is no password by default.<\/li>\n
  2. Set root password? [Y\/n]: <\/strong>Select Y and enter a new password.<\/li>\n
  3. Remove anonymous users? [Y\/n]:<\/strong> Select Y<\/li>\n
  4. Disallow root login remotely? [Y\/n]<\/strong>: Enter Y<\/li>\n
  5. Remove the test database and access to it? [Y\/n]:<\/strong> Enter Y<\/li>\n
  6. Reload privilege tables now? [Y\/n]:<\/strong> Enter Y<\/li>\n<\/ol>\n
    Step 4: Connect to MariaDB<\/h3>\n
    Now that we have secured MariaDB and set a root password, let’s validate the configurations by connecting to MariaDB.<\/p>\n
    Execute the following command to connect to MariaDB<\/strong>. When prompted, enter the root password you set up in the previous step.<\/p>\n
    mysql -u root -p<\/code><\/pre>\n
    You should be able to connect as shown below.<\/p>\n
    \"\"<\/figure>\n
    MariaDB Remote Connection Configuration<\/h2>\n
    \"\"<\/figure>\n
    By default, MariaDB accepts connections only on the Unix socket and localhost. You can verify it by listing the TCP connection<\/p>\n
    ss -nlt<\/code><\/pre>\n
    \"MariaDB<\/figure>\n
    If you try to connect MariaDB from a remote host, you will get the following error<\/p>\n
    ERROR 2002 (HY000): Can't connect to server on '192.168.6.6' (115)<\/code><\/pre>\n
    To enable remote connection, open the 50-server.cnf<\/code> file. You can find this file in the \/etc\/mysql\/mariadb.conf.d\/ <\/code>location.<\/p>\n
    sudo vi \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/pre>\n
    Find the bind-address<\/code> parameter and replace the bind-address value from 127.0.0.1<\/code> to 0.0.0.0<\/code> as shown below.<\/p>\n
    bind-address            = 0.0.0.0<\/code><\/pre>\n
    \"MariaDB<\/figure>\n
    Restart the MariaDB server for the changes to take effect.<\/p>\n
    sudo systemctl restart mariadb<\/code><\/pre>\n
    Now, if you check the TCP connections, you will see that the MariaDB server is listening on all the interfaces.<\/p>\n
    \"MariaDB<\/figure>\n
    MariaDB Database Access From Remote Clients<\/h2>\n
    Even though the MariaDB server accepts connections from remote hosts, you need to allow host-specific remote database access. If not, you will get the following error.<\/p>\n
    ERROR 1130 (HY000): Host '' is not allowed to connect to this MariaDB server<\/code><\/pre>\n
    Now we need to create a database and a user to allow remote connections. First login using the root user and password.<\/p>\n
    mysql -u root -p<\/code><\/pre>\n
    Create a database using the following command. Replace appdb<\/code> with a database name of your choice.<\/p>\n
    CREATE DATABASE appdb;<\/code><\/pre>\n
    Create a database user named dbadmin<\/code> and grant all the privileges to the appdb<\/code> database from the remote host 192.168.6.6<\/code>. Replace 192.168.6.6<\/code> with your client host IP address from where you need to connect to the Database.<\/p>\n
    GRANT ALL ON appdb.* to 'dbadmin'@'192.168.6.6' IDENTIFIED BY 'myPassword';<\/code><\/pre>\n
    If you want to allow DB connection from anyhost for a user you need to use %<\/code> wildcard instead of host address as shown below.<\/p>\n
    GRANT ALL ON appdb.* to 'user'@'%' IDENTIFIED BY 'myPassword';<\/code><\/pre>\n
    In MariaDB, a user is identified along with the host address. You can list all the users using the following SQL query.<\/p>\n
    SELECT User, Host FROM mysql.user;<\/code><\/pre>\n
    Now, try connecting to the dbadmin<\/code> MariaDB database from the remote host.<\/p>\n
    mysql -u dbadmin -p -h 192.168.10.5<\/code><\/pre>\n
    MariaDB Important Configurations<\/h2>\n
    The following table contains all the important MariaDB configurations.<\/p>\n
    <\/p>\n\n\n\n\n\n\n\n\n
    MariaDB Configuration<\/th>\nDetails<\/th>\n<\/tr>\n<\/thead>\n
    MariaDB default port<\/td>\n3306<\/code><\/td>\n<\/tr>\n
    TCP Socket file<\/td>\n\/run\/mysqld\/mysqld.sock<\/code><\/td>\n<\/tr>\n
    MariaDB Config Files location<\/td>\n\/etc\/mysql\/mariadb.conf.d<\/code><\/td>\n<\/tr>\n
    MariaDB Server Configuration file <\/td>\n\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    <\/p>\n
    MariaDB Server Installation FAQs<\/h2>\n
    How to enable remote access on MariaDB?<\/h3>\n
    To enable remote access, you need to replace the bind address with 0.0.0.0. Also, you need to add a user with the remote host details or a wildcard entry to access the database remotely.<\/p>\n
    Conclusion<\/h2>\n
    This guide looked at the steps to install MariaDB on a Ubuntu server.<\/p>\n
    As a DevOps engineer, it is essential to know the basic administration and configurations involved in a Database.<\/p>\n
    If you are starting your DevOps engineer journey, look at my comprehensive guide to becoming a DevOps engineer<\/a>.<\/p>\n
    \n
    Ngu\u1ed3n:<\/strong> How to Install MariaDB on Ubuntu [Setup & Configurations] \u2014 DevOpsCube<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    Source: https:\/\/devopscube.com\/install-mariadb-on-ubuntu\/<\/p>\n","protected":false},"author":1,"featured_media":768,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-767","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops"],"_links":{"self":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/posts\/767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=767"}],"version-history":[{"count":0,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/posts\/767\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=\/wp\/v2\/media\/768"}],"wp:attachment":[{"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ngocha.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}