Execute Shell command over MySql on remote host

Is it possible to login into a remote mys开发者_运维百科ql machine and execute commands using 'system' on the remote machine. I can log into the remote machine, but commands using: 'system' are executed at my local machine. Thanks indeed!

I using mysql to connect from 'Host1' to 'Host2' using the command

mysql -uUsername -p data_base_name -h Host2

When I execute

'system hostname' 

after I'm connected i get.

'Host1'

I cannot log into my remote host using ssh. I don't know why. I need to do some log analysis and the only option I have is to connect to that machine using mysql. I can connect to that machine! –

As far as I know, this is definitely not possible. It's far beyond the scope of mySQL, and there would be immense security implications if it were.

I don't think there is an alternative to getting SSH (or some other service that might help) running again.

Consider doing a select into outfile and writing script code into a place that will be executed on the server. For example, if mysql is running as root on the server, you be able to add something to the /etc/rc2.d which will get executed on the server during boot time.

Alternatively, if there is a file which is used as a source for scheduling tasks you may be able to overwrite that again using "select into outfile."

system runs local commands on your box. If you need to do anything with logs, either contact your hoster, to provide a way to download them or access them.