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 vote222 views1 answer
Returning with sqlalchemy
SQL
0 vote227 views2 answers
How covert into int in maria db
SQL
27 votes223 views5 answers
Add column in table
SQL
0 vote202 views1 answer
How to save data in database in mysql node
SQL
0 vote239 views2 answers
Amazon linux postgresql client
SQL
0 vote212 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote226 views1 answer
Sqlalchemy get ids
SQL
3 votes231 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
1 vote213 views1 answer
Operator does not exist: integer = text
SQL
0 vote224 views2 answers
How to create a table from another table in sql derby
SQL