Skip to main content

Install MariaDB Latest Version 11.4 in Red Hat Version 9

 This this post i will show you step by step the installation process of mariaDB in red hat version 9.

Step1

Run the command to pull the latest updated packages on applications installed in your system.
-dnf update

If you get Kernal update than reboot the system
-reboot

Step2

Go to official mariaDB site

Make mariadb repository in /etc/yum.repos.d

Place the configuration in this file

# MariaDB 11.4 RedHatEnterpriseLinux repository list - created 2024-09-24 11:12 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# baseurl = https://rpm.mariadb.org/11.4/rhel/$releasever/$basearch
baseurl = https://mirrors.aliyun.com/mariadb/yum/11.4/rhel/$releasever/$basearch
# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey = https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1

Now install the mariaDB with its dependencies packages.
-sudo dnf install MariaDB-server MariaDB-client

Now after successful installation, verify the mariadb
-systemctl status mariadb
-systemctl start mariadb
-systemctl enable mariadb

Step3
Connect to mariaDB Server
sudo mariadb

Let setup password for root user
MariaDB [(none)]> alter user 'root'@'localhost' IDENTIFIED by 'your-password';

Login as root user
-mariadb -u root -p //enter
password: <your-password>

Database Commands
-show databases
-create database bsms
Connect and use the specific database
-use bsms

Import Database
While login into mariaDB and selected the database run this command to import database tables
-SOURCE /root/bsms_project/front_app/development_plan/development_tasks/DB/bsms.sql;

Note: If you are not login than use this command to import database
-mariadb -u root -p bsms</root/bsms.sql





Labels:

Comments

Post a Comment

Popular posts from this blog

Redis installation in Red Hat Linux

 In this post we will see step by step installation of Redis service in Redhat/CentOS operation system. To install Redis, run this command in terminal -dnf install redis This command will install the redis service in your machine. Verify installation -systemctl status redis -systemctl start redis -systemctl enable redis Note: Before start redis service set Linux Kernal overcommit memory to 1 by adding vm.overcommit_memory = 1 to /etc/sysctl.conf file. Why we should do that: As we know redis is in memory data store. It primarily uses RAM to store data. Redis and other processes use RAM memory. We set vm.overcommit_memory = 1 to make sure Kernal not overcommit the memory by allocating memory to new program which required more memory than available memory. In this scenario OOM (Out Of Memory) killer terminate the rest of processes. We also restricting Kernal not to terminate the important services running and also stop swapping redis and other importance service to device i/o device,...
Post a Comment
Read more

MySQL course to learn queries to manage DBMS.

1. Create Table CREATE TABLE statement allows you to create new table in database. The example code is given below.  create table profile( id int, name varchar(50), birth_date date, phone varchar(12), gender varchar(1) ); Code language: SQL (Structured Query Language) ( sql ) 2. Insert data in table INSERT INTO statement is use to insert new record/data into table. INSERT INTO profile (id, name, birth_date, phone, gender) VALUES (2, "Zaib", "1996-03-15", "9238975404", "M"); Code language: SQL (Structured Query Language) ( sql ) 3. Insert multiple records at-once INSERT INTO state is use to insert multiple new record/data into table. INSERT INTO profile (id, name, birth_date, phone, gender) VALUES (1, "Usamn ali", "1990-08-26", "9238785094", "M", 18, "Karachi"), (2, "Aisha", "1997-06-12", "9238974468", "F", 19, "Lahore"), ...
Post a Comment
Read more