Sorry to add to this, I have built a new server on 18.04 so that the Ubuntu versions are the same just to rule that out. Unfortunetly this still hasn’t helped and I’m still getting access denied for user ‘pi’ @ localhost.
If anyone could shed some light on this i would be incredibly greatful as otherwise i’m going to have to manually configure the server and recreate a lot of user tokens.
Thanks