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 vote210 views1 answer
Rabbitmq service not starting
SQL
11 votes169 views2 answers
MySQL DISTINCT
SQL
3 votes231 views2 answers
Oracle privileges users
SQL
1 vote167 views1 answer
Oracle list constraints
SQL
3 votes177 views1 answer
Mysql insert on dupèlicate
SQL
0 vote215 views1 answer
Mysql default uuid
SQL
0 vote196 views1 answer
Sql basic commands
SQL
0 vote157 views1 answer
Get number of rows in every table mysql
SQL
0 vote166 views1 answer
Sql developer search all packages for text
SQL
3 votes206 views4 answers
Mysql create table from select statement
SQL