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

1 vote242 views1 answer
Oracle apex version view
SQL
0 vote181 views1 answer
Sql trying to delete database in use
SQL
1 vote221 views2 answers
Difference between in and between in sql
SQL
0 vote196 views3 answers
Mysql regex replace
SQL
1 vote231 views1 answer
Add time to date sql
SQL
2 votes175 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote187 views3 answers
Postgresql connect to database
SQL
0 vote175 views1 answer
Sql create text column limited values
SQL
0 vote175 views1 answer
Sql check for null and empty string
SQL
0 vote250 views1 answer
How to find sql server name
SQL