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 vote255 views2 answers
Soql last year
SQL
0 vote201 views1 answer
Mysql Selected All Duplicate Rows
SQL
3 votes209 views1 answer
Oracle get trigger ddl
SQL
0 vote191 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote230 views1 answer
Unique element in sql
SQL
0 vote199 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote210 views1 answer
How to print longest name in sql
SQL
11 votes215 views1 answer
Sql insert multiple rows from select
SQL
0 vote242 views1 answer
Select top 3 sql
SQL
10 votes265 views2 answers
Reset mysql root password mac
SQL