Install MySQL Workbench on Ubuntu: 1. Download the Community Edition Download the latest release from the MySQL Website. I used the 64-Bit Debian Paket for Ubuntu 9.04 it works on Jaunty (9.04) and on Karmic (9.10). 2. Installation sudo dpkg -i mysql-workbench-oss-5.1.18-1ubu904-amd64.deb 3. Use it Now you can start MySQL Workbench via your menu (Development [...]

A Post-It note for me … Importing an UTF-8 encoded MySQL Database export file with MySQL command line interface: mysql -D databasename -h hostname -p -u db_username –default_character_set utf8 < sqlfile.sql If you don’t add the “–default_character_set utf8″ flag you will get very funny characters in your database

This article describes howto setup sqlgrey with postfix and mysql on Debian Lenny. The normal graylisting with postgrey store the whitelist in a berkeley database which needs to be replicated on a mailserver cluster. With sqlgrey you can do that replication with a mysql database. First create a Database “sqlgrey” with an user “sqlgrey” on [...]

This is a small script to authenticate Jabber users with an external MySQL database. You can free define table and columns for username and password in the settings part of the script. The password should be stored with the ENCRYPT() function in the database. First edit the Jabber configuration file (\etc\ejabberd\ejabberd.conf) and change the authentication [...]