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 vote161 views1 answer
Postgresql get current user name
SQL
0 vote170 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
4 votes165 views2 answers
Sql table
SQL
0 vote168 views1 answer
How to count null values in sql
SQL
6 votes214 views1 answer
Postgresql get year
SQL
0 vote199 views1 answer
Postgres list users and roles
SQL
5 votes157 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote319 views1 answer
Mysql delete entire row on condition
SQL
0 vote163 views1 answer
Sql query to delete row by id
SQL
-2 votes164 views3 answers
Oracle tablespace usage
SQL