I needed a better way to prevent spammers from coming to my site. I was manually retrieving their IP address and blocking on my .htaccess file. However, I decided to automate it by using a python script, crontab, wordpress and MySQL. My biggest issue was to get python to connect to mysql.
I build a script that fetches every IP address marked as spam in wordpress. Crontab runs this script every week which creates and replaces the .htaccess file with updated data.