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 vote296 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote300 views1 answer
Can we rollback data that are deleted using DELETE
SQL
5 votes292 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote298 views1 answer
How to get initials in sql
SQL
2 votes317 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote317 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote313 views2 answers
Nosqlbooster query other collection
SQL
0 vote321 views1 answer
Mysqli last row
SQL
2 votes285 views1 answer
Username sql
SQL
0 vote376 views1 answer
Intellij mysql set timezone
SQL