MySQL AES_ENCRYPT in Python

nov 15, 2012 - Joeri - encryption - aes - mysql - python - Development - Software

MySQL features a function called AES_ENCRYPT(str, keystr). In this blogpost, we show you how to emulate that same function in Python.

Read More

Using mysql load data infile with django

apr 27, 2009 - Remco - django - import - mysql - python - Development

To 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 More

Using a jumpbox in ssh

apr 16, 2009 - Remco - server - mysql - ssh - jumpbox - Software

Sometimes 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

Latest Tweets