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 vote140 views1 answer
Mysql change root mysql_native_password
SQL
22 votes237 views4 answers
Tsql rename table
SQL
5 votes88 views1 answer
Postgres upsert
SQL
-1 vote126 views3 answers
Compute age mysql
SQL
14 votes134 views3 answers
Alter foreign key
SQL
0 vote140 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote100 views1 answer
Store query result in variable sql
SQL
1 vote124 views1 answer
Get count by weekly pivot table sql server
SQL
2 votes132 views1 answer
Sqlite show table indexes
SQL
0 vote157 views1 answer
Mysql wsrep ls
SQL