Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Switch from passwords to options file for MySQL backups #14

Open
beauraines opened this issue Jan 13, 2018 · 0 comments
Open

Switch from passwords to options file for MySQL backups #14

beauraines opened this issue Jan 13, 2018 · 0 comments
Labels
enhancement

Comments

@beauraines
Copy link
Owner

The backup process throws the following warnings

mysqldump: [Warning] Using a password on the command line interface can be insecure.

because the user/pass is passed on the commandline. A more secure method is to use the MySQL options file with --defaults-file
beauraines added a commit that referenced this issue Mar 28, 2019
@beauraines
Switches to MySQL Options files for root credentials
c8fa8ed 
Removes the root user/pass from the configuration file and uses a
mysqloptions file https://dev.mysql.com/doc/refman/8.0/en/option-files.html

This prevents warnings from mysql about using a pssword on the command
line

Sample File make sure its not publicly readable, like your SSH keys.

```
[client]
user=root
password=your_password
```

Closes #14
@beauraines beauraines mentioned this issue Mar 28, 2019
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@beauraines