how do i specify connection parameters on the command line to run mysql in batch mode?

Question

I need to be able to write a script to automatically connect mysql in batch mode so that I can run some .sql files.

I tried to enter the following at the prompt:

./mysql -u root -p mypassword

but I keep getting a "Enter password: " prompt.

What am I doing incorrectly?

Thanks.

Answer 1

Have you tried --pasword=mypasswd?

Answer 2

Get rid of space. Varies with shell.

mysql -uusername -ppassword dbname

It is likely interpreting "mypassword" as your dbname.