Answers for "mysql dump command line password"

SQL
5

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
Posted by: Guest on June-20-2020
0

mysqldump password in file

[mysqldump]
user=mysqluser
password=secret
Posted by: Guest on January-24-2021

Code answers related to "mysql dump command line password"

Code answers related to "SQL"

Browse Popular Code Answers by Language