Re: mysql under unix in batch mode

2003-03-26 Thread Rafal Jank
Dnia Wed, 26 Mar 2003 12:12:44 +0100 Marianadin, Didier [EMAIL PROTECTED] zezna/a co nastpuje: Hi, I want to execute a simple query in batch mode in a mysql database. my OS : Unix (solaris 2.6) when I run this command : mysql -h localhost -u root -p mysql did.query did.out I'm

Re: mysql under unix in batch mode

2003-03-26 Thread Dobromir Velev
Hi, most probably there should not be a space after -p. Try this mysql -h localhost -uroot -pmysql did.query did.out Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ - Original Message - From: Marianadin, Didier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday,

re: mysql under unix in batch mode

2003-03-26 Thread Egor Egorov
On Wednesday 26 March 2003 13:12, Marianadin Didier wrote: I want to execute a simple query in batch mode in a mysql database. my OS : Unix (solaris 2.6) when I run this command : mysql -h localhost -u root -p mysql did.query did.out I'm always asked password even if I've already

Re: mysql under unix in batch mode

2003-03-26 Thread gerald_clark
Create a .my.cnf file in your home directory with permissions set to 600. In that file put the lines [mysql] user=root password=mysql now you can enter: mysql did.query did.out Marianadin, Didier wrote: Hi, I want to execute a simple query in batch mode in a mysql database. my OS : Unix

Re: mysql under unix in batch mode

2003-03-26 Thread Ray
the other thing is make sure you don't have a space after -p and before your password mysql -h localhost -u root -p mysql did.query did.out says ask for the password and start in the database mysql mysql -h localhost -u root -pmysql did.query did.out says the password is mysql and don't

RE: mysql under unix in batch mode

2003-03-26 Thread Michael Shulman
PROTECTED] Subject: Re: mysql under unix in batch mode Hi, most probably there should not be a space after -p. Try this mysql -h localhost -uroot -pmysql did.query did.out Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ - Original Message - From: Marianadin, Didier [EMAIL