ier; [EMAIL 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: &q
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 s
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 (sol
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
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: Wednesd
Dnia Wed, 26 Mar 2003 12:12:44 +0100
"Marianadin, Didier" <[EMAIL PROTECTED]> zeznał/a co następuje:
> 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