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

11 votes355 views2 answers
Insert current date sql
SQL
7 votes357 views2 answers
Oracle sql drop index
SQL
1 vote323 views1 answer
Input in mysql
SQL
0 vote364 views1 answer
Normalization in database
SQL
6 votes371 views2 answers
Difference between join vs union
SQL
6 votes356 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes419 views3 answers
Mysql unix timestamp to date
SQL
0 vote337 views1 answer
Postgresql alter column nullable
SQL
1 vote368 views1 answer
Update from select oracle
SQL
13 votes387 views2 answers
Oracle select into and inner join
SQL