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 votes200 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote202 views1 answer
Osm2pgsql mac
SQL
54 votes352 views6 answers
Sql rename column
SQL
0 vote147 views1 answer
Sql server set complex constraints
SQL
3 votes107 views1 answer
System.debug apex
SQL
0 vote196 views1 answer
Sql developer format sql
SQL
-1 vote150 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
2 votes138 views3 answers
Postgres remove foreign key constraint
SQL
1 vote140 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote141 views1 answer
How to use query in nosql
SQL