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





Comments

Popular posts from this blog

How to find out if a package is installed in Linux?

1) How to find out if a package is installed or not in Linux There are multiple ways to check find locate package is installed in linux machine or not 1.a) Using which command The  ‘which’  command returns an executable path that can be executed when the command is entered in the terminal. # which vi /usr/bin/vi 1.b) Using whereis command The  ‘whereis’  command is used to search the binary, source, and man page files for a given command. # whereis vi vi: /usr/bin/vi /usr/share/man/man1/vi.1p.gz /usr/share/man/man1/vi.1.gz 1.c) Using locate command The  ‘locate’  command performs faster than the find command because it uses an updatedb database, whereas the find command searches in real time. # locate --basename '\nano' /usr/bin/nano /usr/share/nano /usr/share/doc/nano 2) How to find out whether a package is installed or not in Linux, using package manager 2.a) On CentOS / Red Hat (RHEL) 6/7 Use  yum command  or  rpm command  to deter...

Default login form code in laravel

  <div class="container">     <div class="row justify-content-center">         <div class="col-md-8">             <div class="card">                 <div class="card-header">{{ __('Login') }}</div>                 <div class="card-body">                     <form method="POST" action="{{ route('login') }}">                         @csrf                         <div class="form-group row">                             <label for="email" class="col-md-4 col-form-label text-md-right">{{ __('E-Mail Address') }}</label>         ...