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 votes256 views2 answers
Insert all in sql
SQL
5 votes320 views1 answer
Mysql where one year ago
SQL
-1 vote282 views1 answer
Mysql order by on condition
SQL
0 vote293 views1 answer
Mysql row generator
SQL
-1 vote287 views1 answer
Concat two columns in sql server
SQL
2 votes278 views2 answers
Mysql show table column comments sql
SQL
0 vote244 views1 answer
Mysql timeout 30 seconds
SQL
10 votes285 views1 answer
User_dependencies
SQL
0 vote284 views1 answer
Mysql make date from 2 column
SQL
3 votes267 views3 answers
How to set up an auto incrementing id db browser
SQL