MySQL Server

From Sea of Fate
Jump to navigationJump to search

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. Update PHPMyAdmin has now been installed for use as an offline administrator for the database server but it is not exposed to the outside world.