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 vote143 views1 answer
Calculate age in sql
SQL
0 vote147 views1 answer
How to print records of employees hired in particular month in oracle
SQL
9 votes159 views5 answers
Laravel to sql
SQL
0 vote144 views1 answer
Sql string contains case sensitive
SQL
0 vote138 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote137 views1 answer
Console output pl sql
SQL
0 vote145 views1 answer
Get number of tables in database sql
SQL
0 vote143 views1 answer
Sql alternative to max statement
SQL
0 vote141 views1 answer
Mysql docker image for macbook m1
SQL
6 votes147 views5 answers
Sql add months to date
SQL