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 vote190 views1 answer
Concatenate columns in table
SQL
18 votes162 views2 answers
How to get all the tables displayed in oracle
SQL
2 votes212 views1 answer
Oracle apex who is connected
SQL
-1 vote188 views2 answers
On update cascade
SQL
0 vote210 views1 answer
Sql ignore
SQL
25 votes234 views4 answers
Metadata
SQL
12 votes228 views6 answers
Distinct in sql server
SQL
0 vote212 views1 answer
How to create a new db from dumb file mysql
SQL
14 votes1.3K views1 answer
Sql value of string
SQL
2 votes189 views1 answer
Get first 3 letters name in sql
SQL