Appliance category: 
Database

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.

BUILDS:

, , , (?)
Manifest & Sigs

Run from browser:

Deploy Mysql on Amazon EC2

@ GitHub:

Issues
Stable version: 14.2 (changelog)

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

  • Web Control Panel
  • Adminer administration frontend for MySQL (listening on port 12322 - uses SSL).
  • MySQL webmin module.
  • MySQL is configured to listen on port 3306 TCP on all interfaces 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 ) = 'root' LIMIT 1 ;

Note: MySQL can be further tweaked to optimize performance, for examples refer to: /usr/share/doc/mysql-server-5.1/examples/{small, medium, large, huge}

Share

Usage details & Logging in for Administration

No default passwords: For security reasons there are no default passwords. All passwords are set at system initialization time.

Ignore SSL browser warning: browsers don't like self-signed SSL certificates, but this is the only kind that can be generated automatically without paying a commercial Certificate Authority.

Web - point your browser at either:

  1. http://12.34.56.789/ - not encrypted so no browser warning
  2. https://12.34.56.789/ - encrypted with self-signed SSL certificate

Username for database administration:

Login as MySQL username root at

  1. https://12.34.56.789:12322/ - Adminer database management web app
  2. MySQL command line tool: 
    $ mysql --user root --password
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Username for OS system administration:

Login as root except on AWS marketplace which uses username admin.

  1. Point your browser to:
  2. Login with SSH client: 
    ssh root@12.34.56.789

    Special case for AWS marketplace:

    ssh admin@12.34.56.789

* Replace 12.34.56.789 with a valid IP or hostname.