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 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 ...