I stupidly enabled the enforce SSL option without actually checking that i had everything ready :-( Can I undo this either via MariaDB or in a config file?
Never mind, I have sorted it. Its been one of those days!
Out of curiosity what ended up being the problem?
Other people might encounter the same issue so posting it here might assist someone who does.