Do database backup under unprivileged user #425
Labels
area/documentation
area/infrastructure
area/security
environment/prod
Issue affects only production environment
ready
techdebt
trivial
Milestone
We can create special user
backup
for doing backups. He will have limited amount of permissions and also we can use its password in~/home/mystamps/.my.cnf
file.The following steps should be done:
backup
user in MySQL should be created (with limited access: only from localhost and it should have permissions that allows to doing backup only)/data/mystamps/.my.cnf
file should be updated on the server with new login/password/etc/cron.d/mystamps
should be modified to usebackup
usermystamps-backup
Ansible role should be updated to reflect this changesTech debt for: #116
Quote from mysqldump documentation:
The text was updated successfully, but these errors were encountered: