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

1 vote360 views2 answers
Oracle difference between two dates in seconds
SQL
3 votes314 views2 answers
Oracle for loop
SQL
0 vote339 views1 answer
Mysql subtract month from timestamp
SQL
3 votes377 views2 answers
Synonym oracle
SQL
1 vote346 views1 answer
Round function in sql oracle
SQL
17 votes369 views2 answers
T_sql contains
SQL
0 vote343 views1 answer
List all indexes postgres
SQL
5 votes310 views1 answer
Mysql select greater than yesterday
SQL
0 vote316 views1 answer
Create new table pl sql
SQL
7 votes368 views1 answer
Show line number in sql server
SQL