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 vote154 views1 answer
Mysql docker image for macbook m1
SQL
0 vote170 views1 answer
How to find total working hour in sql
SQL
6 votes155 views3 answers
Mysql server is not starting xampp
SQL
0 vote148 views1 answer
Replace multiple string in query sql
SQL
1 vote148 views2 answers
Grab part of a string sql
SQL
12 votes151 views2 answers
Insert multiple rows from another table sql
SQL
0 vote171 views1 answer
Postgresql list extensions
SQL
1 vote157 views1 answer
Rows to comma separated values in mssql
SQL
0 vote291 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote148 views1 answer
Oracle sql create view
SQL