-
Notifications
You must be signed in to change notification settings - Fork 55
MariaDB
Table of Contents
MariaDB is designed as a drop-in replacement of MySQL® with more features, new storage engines, fewer bugs, and better performance.
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 PTS 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!
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
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.
Wiki - Wiki
- Recommended Pre-Reading
- Server - Storage Planning
- Usenet or BitTorrent
- PTS Editions
- PTS Folder Structure
- PTS-Repos
- Common Issues
Data Transport
- Traefik
- Port Guard
- PTS Shield
- PTS Press
- Google Cloud - GCE
- Hetzner Cloud
- PTS Fork
- Extra PTS Commands
- PTS Vault - Data Storage
- PTSPatrol
- Plex AutoScan in Docker Container
- Plex_Dupefiner
- Traktarr
- System & Network Auditor
- PreInstaller & UnInstaller
Core Apps [Expand]
Community Apps [Expand]
- AirSonic
- Bazarr
- Bitwarden
- BookSonic
- cAdvisor
- Cloud Commander
- Deluge
- DelugeVPN
- Dozzle
- Duplicati
- Filebrowser
- FlexGet
- Gazee
- Headphones
- Heimdall
- HomeAssistant
- jd2-openvpn
- Kitana
- Logarr
- MakeMKV
- MariaDB
- McMyadmin
- MEDUSA
- Mellow
- Miniflux
- Monitorr
- Muximux
- Mylar
- NextCloud
- NowShowing
- NZBHydra2
- Organizr
- plpp
- pyLoad
- qBittorrent
- QBittorrent VPN
- radarrsyncarr
- Resilio
- rflood-openvpn
- rutorrent-openvpn
- Shoko Anime Server
- SpeedTest
- SyncLounge
- Teamspeak3
- The Lounge
- Transmission
- Trakt.or
- Ubooquity
- Varken
- vnc-xfce
- vnstat
- ZeroTier