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

Posted by hmak on Stack Overflow See other posts from Stack Overflow or by hmak
Published on 2010-03-16T20:11:56Z Indexed on 2010/03/16 20:21 UTC
Read the original article Hit count: 176

Filed under:

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.

© Stack Overflow or respective owner

Related posts about mysql