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

8 votes278 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote246 views1 answer
Grant access on table in oracle
SQL
0 vote275 views1 answer
Compare subqueries oracle
SQL
0 vote258 views1 answer
Sql server query database space available
SQL
1 vote281 views1 answer
Print year of a date sql
SQL
0 vote261 views1 answer
Char vs varchar2 in sql
SQL
0 vote244 views1 answer
Object Information
SQL
4 votes263 views6 answers
Second max salary in sql
SQL
1 vote256 views1 answer
Drop table if exists oracle
SQL
0 vote260 views1 answer
Sqlalchemy query join many to many
SQL