MySQL features a function called AES_ENCRYPT(str, keystr). In this blogpost, we show you how to emulate that same function in Python.
Read MoreTo import large amounts of CSV data from a file into a MySQL database you can use the LOAD DATA [LOCAL] INFILE command. There are some caveats using this command having to do with security. In order for LOAD DATA to work you will have to enable the command on both the server and client. To do this for the server, you can edit your …
Read MoreSometimes you will need to access a service on a client's machine from an untrusted network, but you don't want to expose this client's SSH server to untrusted IP's. If this is the case you can use a trusted machine (a so called jumpbox) as an intermediate to connect to the client's box. For example, to connect the user test (user available on both jumpbox …
Read More