Cloudbooklet
  • News
  • Artificial Intelligence
  • Applications
  • Linux
No Result
View All Result
Cloudbooklet
  • News
  • Artificial Intelligence
  • Applications
  • Linux
No Result
View All Result
Cloudbooklet
No Result
View All Result
Home Google Cloud

How to Install MariaDB on CentOS 8 – Google Cloud

by Cloudbooklet
4 years ago
in Google Cloud, Compute Engine
How To Install Mariadb On Centos 8 - Google Cloud
ShareTweetSendShare
Readers like you help support Cloudbooklet. When you make a purchase using links on our site, we may earn an affiliate commission.

Install MariaDB on CentOS 8 – Google Cloud. In this guide you are going to learn how to install MariaDB which is an open-source relational database management system developed by the original developers of MySQL. With this tutorial you can install MariaDB and secure it on CentOS 8. This tutorial tested on a virtual machine […]

ADVERTISEMENT

Install MariaDB on CentOS 8 – Google Cloud. In this guide you are going to learn how to install MariaDB which is an open-source relational database management system developed by the original developers of MySQL.

With this tutorial you can install MariaDB and secure it on CentOS 8. This tutorial tested on a virtual machine running CentOS 8 on Google Cloud Platform. So this tutorial will work on any cloud hosting or any VPS or any dedicated servers running CentOS.

Prerequisites

  1. A system or a server running CentOS 8.
  2. SSH access to your server with root privileges.
  3. If you are on Google Cloud you can follow this guide to set up your VM Instance in Google Cloud with CentOS 8.

Update CentOS Packages

SSH to your server and start by updating the packages to its latest version using the following commands.

ADVERTISEMENT
sudo dnf update

Install MariaDB on CentOS 8

Once the packages are upto date you can proceed with the MariaDB installation.

You might also like

How To Setup Ssh Keys On Ubuntu

How to Setup SSH Keys on Ubuntu 20.04

4 months ago
Draggan Ai Editing Tool Install And Use Draggan Photo Editor

DragGAN AI Editing Tool Install and Use DragGAN Photo Editor

4 months ago
sudo dnf install @mariadb

This command installs MariaDB and all necessary dependencies.

Once the installation is complete you start the mariaDB server now and enable it to startup automatically on server boot.

ADVERTISEMENT
sudo systemctl enable --now mariadb

To verify the installation you can use the following command to ensure MariaDB is up and running.

sudo systemctl status mariadb

You will get an output similar to the one below which indicates the server is running.

ADVERTISEMENT
Output
● mariadb.service - MariaDB 10.3 database server
    Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
    Active: active (running) since Sun 2019-12-22 07:56:21 UTC; 7s ago
      Docs: man:mysqld(8)
            https://mariadb.com/kb/en/library/systemd/
  Main PID: 22956 (mysqld)
    Status: "Taking your SQL requests now…"
     Tasks: 30 (limit: 9584)
    Memory: 82.9M
    CGroup: /system.slice/mariadb.service
            └─22956 /usr/libexec/mysqld --basedir=/usr

Secure MariaDB server

MariaDB has an inbuilt script mysql_secure_installation which allows you to configure the necessary security steps and setup root password.

Execute the following command to secure your MariaDB.

ADVERTISEMENT
sudo mysql_secure_installation

Now you will be prompted to setup root password and other security related steps and shown in the screenshot.

Install And Secure Mariadb On Centos 8

Once done you are good to use your MariaDB server.

ADVERTISEMENT

Connect to MariaDB Server

It is very simple to connect to your MariaDB with the following command.

mysql -u root -p

Enter the root password you set before while securing your server.

Now you will be greeted with a welcome message.

Output
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.3.11-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

Here you can run all your SQL queries.

Prepare yourself for a role working as an Information Technology Professional with Linux operating system

Conclusion

Now you have learned how to install MariaDB on your VM instance on Google Cloud Platform running CentOS 8.

Thanks for your time. If you face any problem or any feedback, please leave a comment below.

Tags: CentOSGoogle Cloud Platform
ShareTweetSendShare
Cloudbooklet

Cloudbooklet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Related Posts

Set Up Deep Learning With Nvidia, Cuda, Cudnn On Ubuntu

How to Set Up Deep Learning with Nvidia, CUDA, cuDNN on Ubuntu 22.04

7 months ago
How To Install Or Upgrade Php 8.2 On Ubuntu 22.04

How to Install or Upgrade PHP 8.2 on Ubuntu 22.04

9 months ago
How To Change Timezone On Ubuntu 22.04

How to Change Timezone on Ubuntu 22.04

1 year ago
How To Install Ansible On Ubuntu 22.04

How to Install Ansible on Ubuntu 22.04

1 year ago

Follow Us

Trending Articles

Validator Ai

Validator AI: The AI Powered Business Idea Validator

September 20, 2023

HeyGen AI: Free AI Video Generator to Create Amazing Videos

How to Use ChatGPT to Translate Your Website or Blog

AI Annotation Jobs: Everything You Need to Know

5 Free AI Soulmate Maker: Create Your Perfect Match

10 Best AI Song Generator in 2023 (Free and Paid)

Popular Articles

Ai Portrait Generator

Top 5 AI Portrait Generators for Free and Paid Options

September 13, 2023

10 Best WordPress Hosting Providers for 2023(Free and Paid)

How to Create and Customize Stunning Contact Poster on iPhone

18+ Best Free NSFW AI Generators of 2023

Top 7 Free Dating Sites for Men in 2023

10 Best Tools Change Image Background Online Free

Subscribe Now

loader

Subscribe to our mailing list to receives daily updates!

Email Address*

Name

Cloudbooklet Logo

Welcome to our technology blog, where we explore the latest advancements in the field of artificial intelligence (AI) and how they are revolutionizing cloud computing. In this blog, we dive into the powerful capabilities of cloud platforms like Google Cloud Platform (GCP), Amazon Web Services (AWS), and Microsoft Azure, and how they are accelerating the adoption and deployment of AI solutions across various industries. Join us on this exciting journey as we explore the endless possibilities of AI and cloud computing.

  • About
  • Contact
  • Disclaimer
  • Privacy Policy

Cloudbooklet © 2023 All rights reserved.

No Result
View All Result
  • News
  • Artificial Intelligence
  • Applications
  • Linux

Cloudbooklet © 2023 All rights reserved.