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

20 votes138 views5 answers
Reset auto increment mysql
SQL
0 vote130 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote148 views1 answer
How convert into in in sql query
SQL
-1 vote128 views5 answers
Not in sql
SQL
5 votes128 views2 answers
Create table mysql example auto_increment
SQL
0 vote130 views1 answer
Mysql multiple primary keys
SQL
0 vote124 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
1 vote144 views1 answer
How to see all table partition in oracle
SQL
1 vote146 views1 answer
Varchar plsql
SQL
0 vote168 views1 answer
Opensuse start MySQL
SQL