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 vote217 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
1 vote167 views1 answer
Into sql
SQL
0 vote205 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote192 views1 answer
Mysql to get column name in database
SQL
0 vote197 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote245 views1 answer
Snowflake drop column
SQL
1 vote222 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
11 votes210 views5 answers
Update table from another table mysql
SQL
0 vote198 views1 answer
Sql server inner join convert collation
SQL