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 vote102 views1 answer
Update and keep original value sql
SQL
3 votes103 views1 answer
Pl sql escape &
SQL
0 vote101 views1 answer
Postgres statistics
SQL
2 votes102 views2 answers
Select list is not in group by clause
SQL
14 votes144 views1 answer
How to export db from mysql
SQL
34 votes112 views6 answers
Install mysql client ubuntu
SQL
0 vote93 views1 answer
Mysql earlier than date
SQL
0 vote96 views1 answer
Tsql default value when no value returned by query
SQL
3 votes101 views1 answer
Laravel paginate raw sql
SQL
1 vote97 views2 answers
How to check username in mysql command line
SQL