Skip to content

Instantly share code, notes, and snippets.

@nestoru

nestoru/Solution for mysql Warning: Using a password on the command line interface can be insecure

Last active October 23, 2021 21:20
Show Gist options
  • Star 23 You must be signed in to star a gist
  • Fork 8 You must be signed in to fork a gist
  • Save nestoru/4f684f206c399894952d to your computer and use it in GitHub Desktop.
Save nestoru/4f684f206c399894952d to your computer and use it in GitHub Desktop.
Download ZIP
Solution for mysql Warning: Using a password on the command line interface can be insecure
Raw
Solution for mysql Warning: Using a password on the command line interface can be insecure
# Let us consider the following typical mysql backup script:
mysqldump --routines --no-data -h $mysqlHost -P $mysqlPort -u $mysqlUser -p$mysqlPassword $database
# It succeeds but stderr will get:
# Warning: Using a password on the command line interface can be insecure.
# You can fix this with the below hack:
credentialsFile=/mysql-credentials.cnf
echo "[client]" > $credentialsFile
echo "user=$mysqlUser" >> $credentialsFile
echo "password=$mysqlPassword" >> $credentialsFile
echo "host=$mysqlHost" >> $credentialsFile
mysqldump --defaults-extra-file=$credentialsFile --routines --no-data $database
# This should not be IMO an error. It is just a 'considered best practice'
# Read more from http://thinkinginsoftware.blogspot.com/2015/10/solution-for-mysql-warning-using.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment