What are your suggestions for discovering a MariaDB server on a local network? I know that port 3306 will be open, but I'm not sure about the best way to find out the server's local IP address. (Yes, I wish the server was assigned a static IP address, but it's not.)
I've been reading that the ICMP portocol doesn't actually check to see if a particular port is open, but they state that one should use either the UDP or TCP protocols. Am I on the right track? Just scan each of the 255 IP address on the local network to see which one connects successfully?