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 vote341 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote357 views1 answer
Best sql collation
SQL
10 votes350 views2 answers
Mysql alter add foreign key
SQL
0 vote321 views1 answer
Use between operator in mysql
SQL
0 vote326 views1 answer
How to get initials in sql
SQL
3 votes314 views1 answer
How to remove characters from string in mysql
SQL
1 vote339 views1 answer
Sql server epoch to datetime
SQL
1 vote306 views1 answer
Sql update table remove spaces
SQL
2 votes322 views2 answers
Mysql on duplicate key ignore
SQL
0 vote318 views1 answer
T-sql conditional order by multiple columns
SQL