So FreeBSD decided to deprecate OpenSSL 1.1 and amend the base version in ports to OpenSSL 3.0 Its quite a major jump and although MySQL Server 8 is supposed to support various rebuilds from ports kept throwing up unsupported SSL versions when trying to update the various ports that rely on OpenSSL to get a fully working system.
Suffice to say after rolling back to 1.11 I have managed to get everything functioning again, but when it comes to FreeBSD 14 its probably time to do a fresh install with v3.0 as the default and install everything afresh than try and upgrade in place on what is an essential component for a networked device.