Tag: MySQL

MySQL, the new Cinderella

Oracle tried to buy MySQL. Sun bought MySQL. Oracle buys Sun. MySQL will become Cinderella with the ugly stepmother Oracle mistreating her.

The power of greylisting is aided by whitelisting

I’ve been running gld for more than two months now and it is truly efficient. The current statistics say: # of entries in the database         : 16077 # of one hit entries in the database : 15100 Oldest entry in database             : 65 days ago This means that almost 94% of the attempts to send… Continue reading The power of greylisting is aided by whitelisting

WordPress crack attempt this morning!

When I got to work and viewed this blog I noticed that Sidebar Widgets was disabled. I thought "That’s weird!" When I tried to login to the administration interface I was told that my WordPress database needed upgrading. I thought "That’s weird!" Some further investigation revealed that someone managed to upload a PHP script called… Continue reading WordPress crack attempt this morning!

MySQL support for UTF-8 in Ruby on Rails

As a follow-up to my post about MySQL support for UTF-8 in PHP, here is the very same information for Ruby on Rails. In Rails it is a simple configuration entry in config/database.yml. I use the development configuration as an example: development: adapter: mysql database: dev username: dev password: secret socket: /var/run/mysqld/mysqld.sock encoding: UTF8 UTF-8… Continue reading MySQL support for UTF-8 in Ruby on Rails

MySQL support for UTF-8 in PHP

Originally published in Swedish in my Folkmun.se Blog, a handy tip to make sure that you are reading and writing UTF-8 when connecting to a MySQL database: mysql_query(“SET NAMES utf8”); mysql_query(“SET CHARACTER SET utf8”)