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
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,
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
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
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
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
Thanks Will,
to avoid further misunderstandings -
the escapefeature of backslash is fully understood.
The problem is that the 3d party sw or the myODBC
doesn't understand that the inbound text SHOULD HAVE backslash
but does exactly whats expected - escape the next char.
What I'm asking is - is
At 9:10 AM +0100 9/12/01, Peter Gad wrote:
Hi everyone !
We've got a problem:
running mySQL on unix(sun) we connect a third party
windows software over ODBC. All is nice until a windows path
is stored in the db
Trying to store C:\Program Files\3p SW\
I find that it becomes C:Program Files3p
Hi,
You must install MyODBC in your Unix system, and the MyODBC module for
windows.
Once it is done, make a new connection trought this module whit de ODBC
default fort, the machine name, user, pass and database.
It was all I did and it worked correctly
Javier