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

0 vote194 views3 answers
Mysql delete if not in another table
SQL
1 vote203 views1 answer
Psql import backup file for windows
SQL
0 vote197 views1 answer
Hoq to import database source
SQL
3 votes185 views1 answer
Oracle list dates without weekends
SQL
1 vote190 views1 answer
Mysql query where in select
SQL
0 vote231 views1 answer
Get create sql of hibernqte entity
SQL
4 votes219 views6 answers
Second max salary in sql
SQL
0 vote192 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote193 views1 answer
Search mysql database for column
SQL
0 vote254 views1 answer
Postgresql conectar
SQL