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 vote172 views1 answer
Oracle rolling back transactions
SQL
1 vote177 views1 answer
How to start with sql
SQL
0 vote159 views1 answer
Oracle drop default value
SQL
0 vote176 views1 answer
Window function to forward fill
SQL
0 vote152 views1 answer
Sort by last two number sql
SQL
0 vote124 views1 answer
Oracle sql replace string in clob
SQL
8 votes162 views3 answers
Alter table auto_increment
SQL
-2 votes164 views1 answer
Modify column name in tsql
SQL
0 vote190 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote145 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL