Skip to content

Latest commit

 

History

History
54 lines (44 loc) · 2.35 KB

README.rst

File metadata and controls

54 lines (44 loc) · 2.35 KB
Raw

MySQL - Relational Database Management System

MySQL is a relational database management system (RDBMS) which has more than 11 million installations, and is owned by Oracle. MySQL is a fast, stable, robust, easy to use, and true multi-user, multi-threaded SQL database server.

Strictly speaking, this appliance actually provides MariaDB. MariaDB is generally considered a drop-in replacement for MySQL. However, it does have some features that don't directly map to MySQL. As a general rule, it is possible to migrate from MySQL to MariaDB, but oftem not possible to go back again.

This appliance includes all the standard features in TurnKey Core, and on top of that:

  • MariaDB (MySQL replacement).

  • Web Control Panel, including "quick start" docs, noting info about SSL MySQL connections.

  • Adminer administration frontend for MySQL (listening on port 12322 - uses SSL).

  • MySQL webmin module (compatible with MariaDB).

  • MySQLTuner - Perl script to review and tweak a MySQL/MariaDB installation.

  • Dedicated remote MySQL/MariaDB user; 'remote'.

  • Local 'root' user authenticates via socket, so no password required.

  • MariaDB configured to listen on port 3306 TCP on all interfaces by default - now with SSL enabled (and required) by default.

  • For convenience MySQL is configured to accept connections from all hosts by default. In a production environment it is recommended to limit incoming connections to specific hosts:

    UPDATE `mysql`.`user` SET `Host` = 'hostname'
WHERE CONVERT( `user`.`Host` USING utf8 ) = '%' AND
CONVERT( `user`.`User` USING utf8 ) = 'remote' LIMIT 1 ;

Note: MariaDB can be further tweaked to optimize performance.

Credentials (passwords set at first boot)

  • Webmin, SSH, MySQL (local): username root
  • Adminer: username adminer
  • MySQL (remote): username remote