Re: Connect shell and mysql

From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
Date: Tue, 19 Jun 2007 13:37:33 +0200

rahismailbox wrote ...
} hi,
} how to write and connect to mysql using shell script?

$ mysql -u username -ppassword < <(printf "show databases;")
Database
information_schema
mysql
test

If your shell doesn't support process substitution (<()) use printf ... |
mysql ...

Dimitre

.

References:
- Connect shell and mysql
  - From: rahismailbox@xxxxxxxxx

Prev by Date: Re: compair files
Next by Date: Re: AWK problem need help
Previous by thread: Connect shell and mysql
Next by thread: AWK problem need help
Index(es):
- Date
- Thread

Relevant Pages

Re: mysql - kern.maxfiles limit exceeded by uid 500 please see tuning(7)
... shell script as a cron job every 15 minutes. ... The MySQL process? ... wedge between "is it a MySQL problem" or is it the shell script? ...
(comp.unix.bsd.freebsd.misc)
Re: [PHP] hiding passwd in cmdlines that appear in the process list
... > Or, perhaps, write a shell script that reads the password and provides ... > it to MySQL somehow without invoking another exec of some kind. ... but there is a security issue - one that I thought I ...
(php.general)
RE: [PHP] hiding passwd in cmdlines that appear in the process list
... Would it be possible, Jochem, to just make a shell script that does the call to mysql and have PHP exec() the shell script? ... // run the mysql command via the cmdline ...
(php.general)
Re: [PHP] hiding passwd in cmdlines that appear in the process list
... Or, perhaps, write a shell script that reads the password and provides ... You also could look into other MySQL authentication mechanisms such as ... // run the mysql command via the cmdline ... but there is a security issue - one that I thought I ...
(php.general)
mysql - kern.maxfiles limit exceeded by uid 500 please see tuning(7)
... shell script as a cron job every 15 minutes. ... scripts enter some data in the mysql database. ... The server works fine for a few days, ... echo "CREATE TABLE Average (Time DATETIME, AverageBar TINYTEXT, ...
(comp.unix.bsd.freebsd.misc)