Executing unix commands from mysql

Question

When I am running mysql in the terminal

I can do something like \! python ~/run.py to run the the file.

However when I copy this to php and do mysql_query it doesnt work.

I'd say you should do everything you can possibly do to make MySQL not execute shell commands :) — chmod222
– chmod222, Commented Sep 5, 2010 at 21:11
That's right You shouldn't be trying to do that. If you want to run a shell command from php use system(), exec() or the back-ticks. — ocodo
– ocodo, Commented Sep 5, 2010 at 21:57

ocodo · Accepted Answer · 2010-09-05 20:41:33Z

4

You cannot run any of the \ prefix mysql commands in PHP's mysql_query.

Only valid SQL commands can be used.

answered Sep 5, 2010 at 20:41

ocodo

30.5k19 gold badges111 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Piskvor left the building · Accepted Answer · 2010-09-05 20:44:56Z

2

You can't do that.

The \! commands in the MySQL Console are provided by the Console itself, not by the MySQL server proper. In other words, these commands are not sent to the MySQL server, but they are passed to the shell from which the console was launched (e.g. bash). This is a convenience shortcut, but won't work with normal SQL commands.

answered Sep 5, 2010 at 20:44

Piskvor left the building

93.1k46 gold badges182 silver badges226 bronze badges

Collectives™ on Stack Overflow

Executing unix commands from mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related