command line login question

2004-02-06 Thread Chuck Barnett
Hi, I am trying to create a script that automatically logs in to mysql and chooses a db then runs a query. I can login fine when doing it this way: mysql -u user -p it then asks for a pass and it works. but if I try this: mysql -u user -ppassword dbname I get an access error. any

Re: command line login question

2004-02-06 Thread Jeremy Zawodny
On Fri, Feb 06, 2004 at 05:06:08PM -0600, Chuck Barnett wrote: Hi, I am trying to create a script that automatically logs in to mysql and chooses a db then runs a query. I can login fine when doing it this way: mysql -u user -p it then asks for a pass and it works. but if I try this: