Mariabackup backup - account

Mariabackup backup - account

Colleagues hello to all.

In today's article, we'll talk about what MariaDB user you need in order for Mariabackup to backup your database. Mariabackup needs to be authorized on the database server when a backup operation is performed.

 

The username can be absolutely anything, but it is not publicly customary to call such a user the same name as the program is called, mariabackup. The user must be local.

Create a user:

mariadb>  CREATE USER 'mariabackup'@'localhost' IDENTIFIED BY 'Qwerty123';

mariadbbackup_user

 

After the user mariabackup has been created, now it needs to be assigned the necessary rights.

Assign rights:

mariadb> GRANT RELOAD, PROCESS, LOCK TABLES, BINLOG MONITOR, REPLICATION CLIENT ON *.* TO 'mariabackup'@'localhost';

mariadbbackup_user

 

Permission descriptions:

  • RELOAD - makes it possible to execute the FLUSH command.
  • PROCESS - allows you to view active processes, SHOW PROCESSLIST.
  • LOCK TABLES - allows you to lock tables.
  • BINLOG MONITOR - allows you to view binary logs.
  • REPLICATION CLIENT - allows you to execute the SHOW BINARY LOGS command.

 

After all that we have done now we can try to create our first backup of the MariaDB database, you can see how to do it in my article Mariabackup backup and restore

 

Thank you all, I hope that my article helped you in some way.

SIMILAR ARTICLES

MariaDB - ERROR Incorrect definition of table
MariaDB - ERROR Incorrect definition of table
MARIADB
Read more
Mariabackup backup - gzip compression
Mariabackup backup - gzip compression
MARIADB
Read more
Mariabackup error - Error writing file UNKNOWN errno 32 Broken pipe
Mariabackup error - Error writing file UNKNOWN errno 32 Broken pipe
MARIADB
Read more