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

2 votes423 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
8 votes339 views4 answers
Postgresql server restart
SQL
1 vote303 views2 answers
Sql drop multiple columns if exists
SQL
5 votes350 views4 answers
SQL Order of execution
SQL
3 votes317 views3 answers
Restart mysql mac
SQL
2 votes298 views1 answer
Oracle find unusable indexes
SQL
0 vote261 views1 answer
Expose db in virtualbox
SQL
2 votes296 views1 answer
Oracle sql drop table purge
SQL
0 vote336 views1 answer
Python mysql show databases
SQL
1 vote289 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL