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 vote245 views1 answer
Como leer datos de mysql esp32
SQL
0 vote268 views1 answer
Oracle sql procedure return value
SQL
0 vote281 views1 answer
Mysql subdate
SQL
0 vote272 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote289 views1 answer
Normalization in database
SQL
0 vote319 views2 answers
Suse Linux restart MySQL
SQL
0 vote368 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote261 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
1 vote254 views1 answer
Sql group by error
SQL
0 vote291 views1 answer
Procedure excute monthly oracle
SQL