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 vote127 views1 answer
Hoq to import database source
SQL
0 vote129 views1 answer
Mysql loop through databases and execute query
SQL
0 vote127 views1 answer
Template MySQL Zabbix agent
SQL
0 vote122 views1 answer
Add super privilege mysql
SQL
0 vote111 views1 answer
Sql insert tuple
SQL
1 vote115 views1 answer
Oracle sql listagg
SQL
0 vote114 views1 answer
Oracle list dblink
SQL
0 vote112 views1 answer
Json_remove mysql
SQL
0 vote141 views1 answer
Pgadmin save data greyed out
SQL
0 vote138 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL