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 vote163 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote109 views1 answer
Sql count how many times a value appears
SQL
0 vote147 views1 answer
How to find username and password in oracle 18c
SQL
1 vote150 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
2 votes142 views4 answers
Duplicate record mysql
SQL
39 votes256 views5 answers
Sql drop column
SQL
1 vote170 views2 answers
This month mysql where
SQL
0 vote146 views1 answer
Sql find leading space
SQL
0 vote179 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote150 views1 answer
Sql pivot without aggregate
SQL