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 vote134 views1 answer
Mysql row generator
SQL
0 vote132 views3 answers
How to run sql query
SQL
4 votes123 views1 answer
Restart for pg_hba.conf file
SQL
0 vote115 views1 answer
How to stop all connections to a psql 12 database?
SQL
3 votes118 views1 answer
Select without null values sql
SQL
5 votes146 views2 answers
Get columns number sql
SQL
0 vote129 views1 answer
Sql mod even odd
SQL
1 vote143 views2 answers
Remove space in mysql
SQL
1 vote130 views1 answer
Postgres convert exisiting column to text
SQL
0 vote125 views1 answer
Postgres enumerated type
SQL