Tag: MySQL

mysql on a nondefault socket It is sometimes necessary to run two instances of mysql, like in my case. I need a mysql database in addition to the one Zimbra uses. One solution to this problem is to run...
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...