Tag: Database

Create a mysql trigger This is a short description on how you can create an easy Trigger in mysql. My trigger will insert todays date when I insert a new database record. A trigger is a named...
Enable query caching in mysql Query caching is a way to increase the performance of mysql by caching database queries. It’s quite easy to do and only requires to edit one file, in Debian it’s called...
mysql_secure_installation — Improve MySQL Installation Security This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root accounts. You can remove root accounts that...
mysql create utf8 database This is the way to create a mysql database with UTF8 characterset CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;