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

4 votes300 views1 answer
Id increment ms sql server
SQL
0 vote268 views1 answer
Format the money fied with comma in international system using sql
SQL
10 votes285 views3 answers
How to fetch first 5 characters in sql
SQL
-1 vote314 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
2 votes277 views1 answer
Sqlite show table indexes
SQL
0 vote289 views1 answer
Contact mysql column field
SQL
0 vote273 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
4 votes239 views1 answer
And or sql order of operations
SQL
0 vote311 views1 answer
Postgresql port 5432 not open
SQL
0 vote327 views1 answer
Consecutive numbers sql
SQL