Skip to main content

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  'mike' user, to access only 'rbs' database only.

 -grant all privileges on rbs.* TO 'mike'@'localhost' identified by 'fred';

useful links

1: https://phoenixnap.com/kb/how-to-create-mariadb-user-grant-privileges


Labels:

Comments

Post a Comment

Popular posts from this blog

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...
Post a Comment
Read more

Linux Commands

  Linux Commands 1.  OS-Release -cat /etc/os-release -cat /etc/redhat-release show os //kernal information -uname  show kernal middleware It is intermediator between hardware and software. -uname  -r what is process architect. -uname -p To show all information -uname -a 2.  Date-CAL -date -cal 3.  Booting in Linux (Run-Levels) Shutdown/Close pc -init 0  Single user mode -init 1 Multiple user mode -init 2 Multiple user mode with network plus full support Not use -init 4 Graphical mode init 5 Reboot the system -init 6 4.  Target command in Linux (systemctl) With the help of target we can manage system specific as well as user specific task. Target command is system Control (systemctl). Basically it is utility, which build to replace 'init' command. What systemctl can do ?  We can find its all commands with the help of single command. write systemctl enter twice TAB button. //it will list all its commands. Show current system mode - systemctl...
Post a Comment
Read more