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

4 votes228 views2 answers
Postgres update single column
SQL
4 votes220 views1 answer
Select first and last row sql
SQL
0 vote216 views1 answer
Sql server cannot create database diagram
SQL
3 votes211 views1 answer
Oracle limit user tablespace
SQL
1 vote240 views1 answer
Mysql drop key
SQL
24 votes240 views4 answers
Delete db postgres
SQL
0 vote236 views1 answer
Primary key multiple colums
SQL
4 votes234 views1 answer
Refresh postgres config
SQL
0 vote316 views2 answers
Sqlalchemy default value for column
SQL
0 vote249 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL