Run mysql command in unix bash without mysql installed?

Question

at the moment we have 1 server for everything: cronjobs, webserver, dofferent databases systems...

Within this week we have brand new hardware and we try to split up everything: MySQL on its own server, cron jobs on its own servers etc.etc.

Now I try to migrate a bash-script which uses the mysql-command to execute a SQL query and send the result to a usergroup in a cronjob. But of course our cronjob server hasn't and shouldn't have mysql installed.

So I get mysql: command not found

Any ideas?

Yeah but the mysql-command isnt there... – PassionateDeveloper May 18 '15 at 11:27 — PassionateDeveloper, May 18 '15 at 11:27
Dan Bizdadea gets it! – PassionateDeveloper May 18 '15 at 11:31 — PassionateDeveloper, May 18 '15 at 11:31

score 2 · Accepted Answer · answered May 18 '15 at 11:21

2

MySQL has two components : The MySQL Server and the MySQL client.

You NEED to install MySQL Client on each server that is using it in order to connect to the MySQL Server.

answered May 18 '15 at 11:21

Dan Bizdadea

1,292
8
15

Thats nice! Can you give me a link to a howto please – PassionateDeveloper May 18 '15 at 11:27
Check this question : http://stackoverflow.com/questions/5287220/is-there-a-way-to-only-install-the-mysql-client-linux – Dan Bizdadea May 18 '15 at 11:35

Run mysql command in unix bash without mysql installed?

1 Answers1