Skip to content

MariaDB

Cody edited this page Mar 7, 2019 · 3 revisions

📂 Click Here - Sign up for Google's Suite for Business - Unlimited Space

📂 Click Here - NZB's with from NewsHost - PG Members Receive a 58% Discount

Table of Contents

  1. Intro
  2. Access Information
  3. Login Information
  4. Summary

1. Intro

MariaDB is designed as a drop-in replacement of MySQL® with more features, new storage engines, fewer bugs, and better performance.

2. Access Information

Protocol Address Notes
traefik** mariadb:6603 Only for Internal App-to-App Communication
https† mariadb.domain.com Traefik must be Deployed; Remote Servers
http domain.com:6603 Poor Security Practice - Stop with PG Port Guard
http ipv4:6603 Ideal Only for Local Servers
Internal External
3306 6603

†Requires oauth to be disabled. Exposing the database directly to the internet is rarely required. It's better to use an SSH tunnel to the host and connect locally.

** Ideal for Apps to communicate between with one another. Click Here for more info!

3. Login Information

The initial login information is set as follows:

Username Password
root plexguide

This should be changed for security reasons. This can be done via the terminal command docker exec -it [container] mysql [database] -uroot -p

For example:

docker exec -it mariadb mysql mysql -uroot -pplexguide

FLUSH PRIVILEGES;

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

quit

4. Summary

The MariaDB container is solely a database on its own but can be used by other containers or applications which require a MySQL/MariaDB instance.

Installing PlexGuide

  1. PlexGuide Install Information

Preplanning & Information

  1. PG Folder Structure

Domain and Port Control

  1. CloudFlare Tunnel

Primary Applications

  1. Plex

Useful Links

  1. PG YouTube Channel
Clone this wiki locally