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 vote322 views2 answers
How to drop mili second in sql
SQL
0 vote304 views1 answer
Ansi sql count duplicate rows
SQL
0 vote315 views1 answer
Insert using condition postgres
SQL
0 vote298 views1 answer
Geopoint from json mysql function
SQL
0 vote287 views2 answers
Close external port 3306 with iptables
SQL
0 vote303 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote307 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote293 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote311 views1 answer
Postgres can integer fields be negative
SQL
0 vote307 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL