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.

MJB · Accepted Answer · 2010-03-16 20:22:40Z

1

Get rid of space. Varies with shell.

mysql -uusername -ppassword dbname

It is likely interpreting "mypassword" as your dbname.

answered Mar 16, 2010 at 20:22

MJB

7,6862 gold badges34 silver badges41 bronze badges

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

2 Comments

makstaks Over a year ago

using mac osx terminal, I tried it still getting "Access denied for user..."

makstaks Over a year ago

thanks, it was the space issue, but also my password had a character that interfered with the command, so I changed my password.

Jason Aller · Accepted Answer · 2014-05-09 02:23:41Z

0

Have you tried --password=mypasswd?

edited May 9, 2014 at 2:23

Jason Aller

3,66028 gold badges43 silver badges40 bronze badges

answered Mar 16, 2010 at 20:19

pierroz

7,9309 gold badges52 silver badges60 bronze badges

1 Comment

pierroz Over a year ago

At least I answered your original question. Now you must have some trouble with your users right management. Check with your sysadmin the credentials you are using have the good right either on the local machine or on a remote one, depending on your env

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related