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

3 votes107 views1 answer
Sql replace character in string in all records
SQL
0 vote110 views1 answer
To change the database owner in SQL server
SQL
0 vote66 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote112 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote107 views1 answer
Xampp increame mysql speed
SQL
0 vote105 views3 answers
Group_concat sql server
SQL
1 vote132 views1 answer
Sql and
SQL
12 votes127 views1 answer
Run mysql instance in docker
SQL
18 votes117 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
1 vote102 views1 answer
Oracle truncate partition
SQL