How to provide password in shellscript on linux server?

Question

i have some query and scp command in a shellscript on linux server and need to automate this shellscript how can i provide the database query password and scp password in the script only? so that bash will not prompt for passwords

mysql -u user_id -p -h db_hostname db_name -e 'query' ; scp filename destination using this in my shellscript — rohinee, Sep 19 '18 at 13:24

score 0 · Accepted Answer · answered Sep 19 '18 at 14:40

0

You can connect to mySql without the password prompt by using --password for example,

mysql -u user_id --password='mypassword' -h db_hostname db_name -e 'query'

For scp see the answer posted here How to pass password to scp?

answered Sep 19 '18 at 14:40

Dave Carruthers

542
1
8
29

How to provide password in shellscript on linux server?

1 Answers1