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 vote309 views1 answer
Database traccar
SQL
28 votes282 views4 answers
Mysql delete database
SQL
0 vote308 views1 answer
Mysql select inside sum
SQL
0 vote291 views1 answer
Implizite joins sql
SQL
7 votes289 views1 answer
Forge server hosting
SQL
12 votes307 views4 answers
Import mysql database command line linux
SQL
11 votes309 views2 answers
Insert current date sql
SQL
0 vote319 views1 answer
Calculate age in sql
SQL
6 votes349 views2 answers
Oracle trigger
SQL
3 votes291 views2 answers
Pl sql escape '
SQL