TurnKey Linux Virtual Appliance Library

MySQL (inc LAMP, Drupal, Joomla etc)

Accessing Database remotely

Only the MySQL appliance allows remote connections to the DB by default. However any appliance with MySQL can be configured to allow remote connections. Please see here.

InnoDB

InnoDB is enabled by default.

# mysql -uroot
> show engines;
 MyISAM     | DEFAULT
 InnoDB     | YES
 ...

But some people have experienced problems using InnoDB with MySQL in both the legacy and current stable (v11.1) TKL appliances. MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them, they are recreated, allowing InnoDB to start again. To rename log files and restart MySQL:

/etc/init.d/mysql stop
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
/etc/init.d/mysql start

But if you want it to be your default storage engine you have to specify it, for example:

# cat /etc/mysql/conf.d/storage_engine.cnf
[mysqld]
default-storage-engine = InnoDB

# /etc/init.d/mysql restart

# mysql -uroot
> show engines;
 MyISAM     | ENABLED
 InnoDB     | DEFAULT
 ...