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 vote331 views1 answer
Mysql error 1452
SQL
3 votes340 views1 answer
Mysql insert on dupèlicate
SQL
36 votes336 views3 answers
Finding duplicate column values in table with sql
SQL
7 votes338 views1 answer
Mysql iif
SQL
7 votes316 views4 answers
Database dump mysql command
SQL
1 vote327 views1 answer
Mariadb case switch
SQL
0 vote314 views1 answer
Uncomment listen_address=localhost
SQL
2 votes330 views1 answer
Tsql copy table
SQL
0 vote372 views1 answer
Python mysql check if database exists
SQL
0 vote316 views1 answer
Pl sql constraint user function
SQL