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 vote364 views1 answer
TSQL Find csv file in folder
SQL
0 vote287 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
20 votes340 views4 answers
Sql count if
SQL
4 votes365 views3 answers
Mysql get column names from table
SQL
0 vote313 views1 answer
Oracle to_number
SQL
0 vote318 views1 answer
Dataframe lambda elif
SQL
0 vote321 views1 answer
Mysql backup query
SQL
0 vote279 views1 answer
Psql check if value in array
SQL
0 vote279 views1 answer
What is logical database schema
SQL
0 vote277 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL