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 vote260 views1 answer
Mysql 8 error on identified by
SQL
1 vote224 views1 answer
Stored procedure return value
SQL
0 vote236 views1 answer
Check if a word appears at the end sql query
SQL
0 vote243 views1 answer
Call function sql oracle with output put line
SQL
0 vote254 views2 answers
How to login to mysql as normal user in ubuntu
SQL
3 votes398 views9 answers
Linq to sql converter online
SQL
0 vote266 views2 answers
Script all indexes in a database
SQL
1 vote264 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote257 views1 answer
Order by in codeigniter query builder
SQL
13 votes253 views6 answers
Current date sql
SQL