Reset MySQL Root Password
Quick tutorial to reset the root password of an MySQL server:Kleine Anleitung um das Root-Password eines MySQL-Servers zurückzusetzen: (I know there are a lot of howtos out there, i make…
MySQL Workbench on Ubuntu
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…
MySQL command line import of file with UTF-8 encoding
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 <…
Greylisting with sqlgrey, postfix and mysql on Debian Lenny
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…
Authenticate ejabberd with an mysql database
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…
Log Apache2 access log into a MySQL database on Debian Lenny
This article describes how you can log your apache access log entries into a MySQL database. You need a installed and configurated Apache2 webserver and MySQL server. Installation: On the…