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

4 votes186 views4 answers
What is primary key
SQL
0 vote187 views1 answer
Partitioning in oracle-base
SQL
1 vote235 views2 answers
Copy table in sql
SQL
0 vote179 views1 answer
Sql beginning of previous month
SQL
13 votes187 views2 answers
Display users in mysql
SQL
7 votes204 views3 answers
Foreign key oracle
SQL
0 vote201 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
-1 vote232 views2 answers
Sql search all tables for attributes
SQL
1 vote217 views2 answers
Mysql extract number from string
SQL
3 votes192 views2 answers
Mysql update row
SQL