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 vote235 views1 answer
Sql first day quarter
SQL
2 votes227 views1 answer
Date conversion in mysql column
SQL
1 vote228 views1 answer
How to unlock table in mysql
SQL
15 votes227 views1 answer
Mysql int range
SQL
1 vote240 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
24 votes235 views4 answers
Postgres remove database
SQL
10 votes229 views3 answers
Sql select between two dates
SQL
0 vote233 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote226 views1 answer
Storing RGBA in mysql db
SQL
1 vote180 views1 answer
Unique vs distinct sql
SQL