Skip to main content

Posts

Showing posts with the label mariadb

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 package...

Create backup and restore databases in mariaDB

=========backup and restore mariaDB databases.=========== Step1: Go to the location where you want to store database backup now i'm creating backup of rbs database. -mysqlidump -u root -p rbs > rbsbak.sql check last lines of DB file to verify the file contains query lines.  -tail -n 10 brainwifibak.sql Step2: delete database Step3:  Restore the backup database  go to location where backup database file is placed.  -mysql -u root -p -h localhost rbs < rbsbak.sql Step 4: Create user with same privileges as super-user GRANT ALL PRIVILEGES ON *.* TO 'tolkien'@'%'; ==================create user in mariaDB===================== Step1: Create new user  -CREATE USER 'root'@'localhost' IDENTIFIED BY 'Pakistan2'; Step2: Grant all privileges to root user to he can access all databases.  -GRANT ALL PRIVILEGES ON *.* TO 'user1'@localhost IDENTIFIED BY 'password1'; Step3: Grant permissionfor only one database Grant all privileges to  ...

Install MariaDB 10.6 on Oracle Linux 8|Rocky Linux 8

  Install MariaDB 10.6 on Oracle Linux 8|Rocky Linux 8 How can I quickly install MariaDB 10.6 on Oracle Linux 8 / Rocky Linux 8?. MariaDB is a free and open-source relational database management system forked from MySQL and community-developed. The database software is released under the GNU General Public License. Our short tutorial will teach you how to install and configure MariaDB 10.6 on Oracle Linux 8 | Rocky Linux 8 Linux system. Install MariaDB 10.6 on Oracle Linux 8|Rocky Linux 8 You should have a running Oracle / Rocky Linux server before you start the installation. This can be a physical server, virtual machine running on VMware, KVM, OpenStack or cloud provider such as AWS. A user that has sudo privileges is also required for the installation. Step 1: Update System Run the command below to pull the latest packages of the applications installed in your system. $ sudo dnf update Transaction Summary =========================================================================...