Mysqldump password

add this to .my.cnf file
user can be omitted

[mysqldump]
user=mysqluser
password=secret

The -p option must be excluded from the command in order to use the password in the config file.
Correct:
mysqldump –u my_username my_db > my_db.sql
Wrong:
mysqldump –u my_username -p my_db > my_db.sql

Source: stackoverflow.com

Mysqldump password in file

[mysqldump]
user=mysqluser
password=secret

Source: stackoverflow.com

Similar codes

2 votes381 views3 answers
Row number mssql
SQL
0 vote352 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote342 views1 answer
Date diff sql
SQL
0 vote411 views1 answer
SQL joins in python
SQL
0 vote355 views1 answer
Setval postgres example table id
SQL
6 votes373 views2 answers
Non relational database
SQL
2 votes351 views2 answers
Get all columns from table sql
SQL
4 votes331 views2 answers
Oracle set date format
SQL
0 vote394 views2 answers
Select a row include list of array with join two table SQL
SQL
1 vote374 views1 answer
Postgresql datetrunc too slow
SQL