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 vote461 views1 answer
How to rename a database in tsql
SQL
0 vote363 views1 answer
How to update date value in sql
SQL
0 vote332 views1 answer
Sql select column names starting with
SQL
0 vote365 views2 answers
Enter into postgresql database,create user and grant Access
SQL
2 votes356 views1 answer
Guid to string sql
SQL
0 vote355 views1 answer
Insensitive case match sqlalchemy
SQL
3 votes361 views2 answers
Install mysql powershell
SQL
18 votes318 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote358 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
1 vote354 views1 answer
Mysql view command
SQL