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 vote348 views1 answer
Oracle enable chain
SQL
0 vote339 views1 answer
Ora 00001 error catch plsql
SQL
0 vote377 views1 answer
Insert into table with only identity column
SQL
0 vote399 views1 answer
What is delimiter in mysql
SQL
0 vote347 views1 answer
Postgres where
SQL
4 votes356 views3 answers
Order by value mysql
SQL
0 vote347 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote349 views1 answer
Mysql sql select one day before
SQL
0 vote361 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote353 views1 answer
Oracle user last connection date
SQL