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

0 vote231 views2 answers
Null value in column violates not-null constraint
SQL
9 votes249 views3 answers
Mysql show table column full description
SQL
1 vote239 views1 answer
Delete specific row in sql
SQL
0 vote231 views1 answer
Sql beginning of previous month
SQL
-1 vote207 views1 answer
Plsql while
SQL
0 vote253 views1 answer
Oracle list partitions
SQL
3 votes252 views1 answer
Where id is in list sql
SQL
7 votes240 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote205 views1 answer
CREATE MULTIPLE FK
SQL
4 votes249 views4 answers
Oracle tablespace tables list
SQL