MySQL AES_ENCRYPT in Python

15 november 2012 - Joeri - aes - encryption - 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

27 april 2009 - Remco - django - mysql - python - import - 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

16 april 2009 - Remco - mysql - ssh - server - 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