Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.


    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

How to mysqldump in a more secure way?

wyclef

Active Coder
How can I get the following script to be more secure? I am getting a mysqldump warning.

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

[CODE lang="bash" title="mysqldump" highlight="4"]# Dump MySQL in staging area
echo "------------------------------------------------"
echo "Dumping MySQL..."
mysqldump -h "$host" -u "$username" -p"$password" "$dbName" > ~/tmp/"$projectName"/database.sql
echo "Done!"[/CODE]

Thanks!
 
Tried out this solution and am getting the following error.

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect using

Bash:
mysqldump --defaults-extra-file=~/.sqlpwd [database] > ~/tmp/"$projectName"/database.sql

with the .sqlpwd being this

Bash:
[database]
host=domain.abc.com
username=user
password=pass
dbName=database_name

Any ideas?
 

New Threads

Latest posts

Buy us a coffee!

Back
Top Bottom