Documentation
MySQL
MySQL is a SQL database, owned and sponsored by a single for-profit firm, the Swedish company MySQL AB. The company provides a freely available community edition.
MySQL is included in almost every recent Linux distribution.
Nectil supports MySQL 3.23 and above (4,5,5.1).
Nectil doesn't package MySQL, it should be installed separately.
Configuration advices
By default MySQL comes with the root access configured with an empty password. Don't forget to put a password and create a second access for the Nectil framework.
User : nectil
Password : averysecretpassword
Here is a SQL command to create a MySQL access :
GRANT ALL ON *.* TO "nectil"@"localhost" IDENTIFIED BY "averysecretpassword";
FLUSH PRIVILEGES;
If you plan to have large amounts of datas (mails, internal products database) managed with Nectil, be careful to choose a large enough disk partition. The default directory for mysql datas (e.g. /var/lib/mysql/data) might be located on the boot disk which is often the smallest partition (e.g. 2Gb is far too small to keep a database). Think of changing it to /home/mysql.