Skip to content
TURNKEYGNU / LINUX
AppsDocumentationForumBlogScreenshotsGitHubTurnKey Hub
文English
EnglishDeutschEspañol日本語Portuguêsहिंदी中文
Home/Documentation/MySQL (inc LAMP, Drupal, Joomla etc)

Documentation

MySQL (inc LAMP, Drupal, Joomla etc)

Accessing Database remotely

Only the MySQL server allows remote connections to the DB by default. However any server 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 servers. 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
 ...

TURNKEYGNU / LINUX

Secure self-hosting without starting from scratch

Explore TurnKey
AboutDocumentationForumFAQBlogGitHub
Free and open sourceSecure by defaultReady to deploy