Mysqldump password in file

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 vote172 views1 answer
To change the database owner in SQL server
SQL
-1 vote171 views1 answer
Capitole toulouse
SQL
1 vote172 views1 answer
Oracle extract minute from date
SQL
1 vote183 views1 answer
Mysql print variable
SQL
15 votes180 views5 answers
Show tables in oracle
SQL
5 votes162 views1 answer
Sql first day of current year
SQL
2 votes162 views1 answer
Mysql auto increment jumping
SQL
0 vote161 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote166 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes178 views1 answer
Mysql last 7 days including today
SQL