MySQL Server: Difference between revisions

From Sea of Fate
Jump to navigationJump to search
Line 1: Line 1:
==Introduction==
==Introduction==


The host Mandarin is the MySQL server. It should be quite capable of serving the database need of all of the '''[[Webservers]]''' and any other '''[[Virtual Machines]]''' in the'''[[Home Lab]]'''. It will not be made available to the WWW as there is no need.
The host Mandarin is the MySQL server. It should be quite capable of serving the database need of all of the '''[[Webservers]]''' and any other '''[[Virtual Machines]]''' in the '''[[Home Lab]]'''. It will not be made available to the WWW as there is no need.


===PHPMyAdmin===
===PHPMyAdmin===


PHPMyAdmin has been installed but it will only be available to the LAN. By restricting it to LAN access only there much less security concerns and there is not really much need to do much admin on MySQL in any case. PHPMyAdmin will probably be used primarily for trouble shooting and maybe some manual backups but even then we need to do the backups on some automated scripts.
PHPMyAdmin has been installed but it will only be available to the LAN. By restricting it to LAN access only there much less security concerns and there is not really much need to do much admin on MySQL in any case. PHPMyAdmin will probably be used primarily for trouble shooting and maybe some manual backups but even then we need to do the backups on some automated scripts.

Revision as of 01:31, 7 March 2025

Introduction

The host Mandarin is the MySQL server. It should be quite capable of serving the database need of all of the Webservers and any other Virtual Machines in the Home Lab. It will not be made available to the WWW as there is no need.

PHPMyAdmin

PHPMyAdmin has been installed but it will only be available to the LAN. By restricting it to LAN access only there much less security concerns and there is not really much need to do much admin on MySQL in any case. PHPMyAdmin will probably be used primarily for trouble shooting and maybe some manual backups but even then we need to do the backups on some automated scripts.