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 vote150 views1 answer
Oracle turn off constraint
SQL
0 vote167 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote133 views1 answer
Equi joins in oracle
SQL
1 vote148 views1 answer
How to print longest name in sql
SQL
0 vote159 views1 answer
Savepoint mysql script
SQL
0 vote164 views4 answers
Rownum in sql
SQL
0 vote150 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote138 views1 answer
Ignore case in string sql
SQL
0 vote94 views1 answer
Check sql query executed wp
SQL
0 vote140 views1 answer
Suse status MySQL
SQL