mariaDB

Relational Database Management System

Description

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

Included in this Appliance

This appliance includes all standard features and on top of that:

  • MariaDB
  • 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 ) = 'adminer' LIMIT 1 ;
    

Note: MySQL can be further tweaked to optimize performance.

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. If you have a domain configured, then via Confconsole Advanced menu, you can generate free Let’s Encypt SSL/TLS certificates.

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

Note: some appliances auto direct http to https.

Username for database administration:

  1. Adminer; login as MySQL username adminer:https://12.34.56.789:12322/ – Adminer database management web app
  2. MySQL command line tool; log in as root (no password required):
    $ mysql --user root
    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

  1. Point your browser to:
  2. Login with SSH client:
    ssh [email protected]
    

* Replace 12.34.56.789 with a valid IP or hostname.

Bamboozle-mariaDB

Support Details

Supported By: Bamboozle
License: GNU AGPL v3

 

More  Links

Documentation: Technical overviews, how-tos, release notes, and support material

Tutorials: DevOps and development guidelines

AskCommunity: Connect, share and learn

More Marketplace Apps

mongoDB: The leading NoSQL Database

WordPress: Deploy fast and secure WordPress with one click.

Mattermost: The best and secure Slack Alternative

Check out our marketplace for more apps.

Create your mariaDB Appliance

Deploys instantly. 2 month free with annual plans.