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

11 votes282 views3 answers
How to get last row of table in sql
SQL
0 vote248 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote281 views1 answer
SQL division of an integer by another integer get float CAST
SQL
5 votes227 views1 answer
Alter table default value mysql
SQL
0 vote275 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote257 views1 answer
Can we rollback data that are deleted using DELETE
SQL
3 votes274 views1 answer
Async await mysql nodejs
SQL
0 vote260 views1 answer
How to check the port of mysql installation in mac
SQL
14 votes280 views3 answers
Inner join sql oracle
SQL
0 vote254 views1 answer
Mysql delete from where like
SQL