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

9 votes319 views4 answers
Last mysql
SQL
14 votes368 views4 answers
Sql compiler
SQL
-3 votes416 views8 answers
Sql to c# linq converter online
SQL
-1 vote317 views1 answer
Mysql #1064 error
SQL
1 vote302 views1 answer
Mysql find tables with column name
SQL
3 votes326 views2 answers
Sql select data from last week
SQL
0 vote318 views1 answer
View to table
SQL
1 vote356 views2 answers
Mysql extract number from string
SQL
25 votes374 views1 answer
How to update an attribute in MySQL
SQL
0 vote323 views1 answer
Oracle sql drop table
SQL