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

0 vote213 views1 answer
Order child below the parent in mysqli
SQL
0 vote220 views1 answer
Calculate age in sql
SQL
28 votes214 views6 answers
Foreign key
SQL
2 votes230 views2 answers
Python escape string for sql
SQL
0 vote198 views1 answer
How to use lower case in mysql
SQL
0 vote216 views1 answer
Bidirectional outer join sql
SQL
0 vote213 views2 answers
Search stored procedures by name
SQL
3 votes202 views3 answers
List columns in table postgres
SQL
1 vote212 views1 answer
Mysql is odd
SQL
23 votes217 views2 answers
Query to delete a database in mysql
SQL