BASH script not reading input mysql password [duplicate]

Question

Possible Duplicate:
How to execute Mysql command from a shell script?

I'm trying to execute a .sql file using a bash script. But I am having a problem connecting to MySQL. Here's what I have so far:

#! /bin/sh
PWD="thepassword"
mysql -p -u theuser < Randomsqlfile.sql
echo $PWD

When the password is prompted, nothing fills out.

ruakh · Accepted Answer · 2012-11-30 16:48:27Z

4

Make this:

mysql -utheuser -pthepassword <Randomsqlfile.sql

ruakh

185k29 gold badges292 silver badges324 bronze badges

answered Nov 30, 2012 at 16:44

jkamizato

1965 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1