MySQL Server: Difference between revisions
Created page with "==Introduction== The host Mandarin is the MySQL server. 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..." |
Wikisailor (talk | contribs) |
||
| (4 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Introduction== | ==Introduction== | ||
The host Mandarin is the MySQL server. 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. '''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. | ||
Latest revision as of 16:51, 8 February 2026
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.
