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

1 vote126 views1 answer
Sql not equal multiple columns
SQL
1 vote326 views2 answers
Coderbyte sql solutions
SQL
13 votes176 views6 answers
Mysql remove duplicates
SQL
10 votes163 views2 answers
Reset mysql root password mac
SQL
0 vote219 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote170 views1 answer
How to connect to xampp sql server on windows cmd
SQL
6 votes147 views4 answers
Mysql get random row
SQL
0 vote138 views1 answer
R write csv without index
SQL
0 vote131 views1 answer
Addition of 2 column value in mysql
SQL
1 vote139 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL