If you ever need to administer a MySQL server remotely, this recipe is for you. It will show you how to send database commands to a remote MySQL server from a Python script. If you need to set up a web application that relies on a backend database, this recipe can be used as a part of your web application setup process.
This recipe also needs Fabric to be installed first. You can install Fabric using the Python packing tools,
easy_install, as shown in the following command. Fabric relies on the
paramiko module, which will be installed automatically.
$ pip install fabric
Here, we will connect the remote host using the SSH protocol. So, it's necessary to run the SSH server on the remote end. You ...