#!/bin/bash
ip="<MySQL HOST>"
port="<MySQL PORT>"
output_file="<Log File Path>"
while :
do
nc -zv "$ip" "$port" > /dev/null
datetime=$(date +"%Y-%m-%d %H:%M:%S")
if [ $? -eq 0 ]; then
echo "$datetime: Port $port is open on $ip" >> $output_file
else
echo "$datetime: Port $port is closed on $ip" >> $output_file
fi
sleep 10
done