External_Access - ISISSoftwareServices/AutoreductionMonitor GitHub Wiki

This page details external access to containerised system monitoring database on a remote host.

MySQL Workbench

To connect to the containerised databased from MySQL Workbench, please follow the below instructions:

• Create new connection
• Change connection method to Standard TCP/IP over SSH
• Enter ssh hostname IP on port 22
• Enter SSH username
• Enter MySQL HostName (you can find this by using the command sudo docker inspect <container name> when from host machine the container is running on)
• Enter the MySQL port (This can be found by looking at the docker process running on the container host machine using sudo docker ps)
• Enter MySQL username
• Test connection and if positive, you have successfully connected over SSH into a containerised instance of a MySQL database!