# ---------------------------------------------------- # - Parameter Settings for Script '.restore_database.sh' # ---------------------------------------------------- # - MySQL / MariaDB / Percona credentials # - DATABASE_CREDENTIALS_ARGS # - # - Giving password on command line is insecure an sind mysql 5.5 # - you will get a warning doing so. # - # - Reading username/password from file ist also possible, using MySQL/MariaDB # - commandline parameter '--defaults-file'. # - # - Since Version 5.6, that method is considered as insecure. # - To avoid giving the password on command line, we use an # - encrypted option file # - # - Create (encrypted) option file: # - $ mysql_config_editor set --login-path=local --socket=/var/run/mysqld/mysqld.sock --user=backup --password # - $ Password: # - # - Use of option file: # - $ mysql --login-path=local ... # - # - Example # - # MySQL # - DATABASE_CREDENTIALS_ARGS="--login-path=local" # - DATABASE_CREDENTIALS_ARGS="--defaults-file=/etc/mysql/debian.cnf" (Debian default) # - DATABASE_CREDENTIALS_ARGS="--defaults-file=/usr/local/mysql/sys-maint.cnf" # - # - # MariaDB 10.4.x # - DATABASE_CREDENTIALS_ARGS="-u root -S /run/mysqld/mysqld.sock" # - # - Note: # - Script tries to determin database credentials. So it's a good idea, to leave this # - Parameter empty. Only set it here, if automatic detection failed. # - #DATABASE_CREDENTIALS_ARGS=""