Unspecified Error when creating connection
I've got round the problem by connecting as root which is not ideal as I then have to change the connection for the live site by editing the connection code manually. It is definitely not a user password error as I said in my first posting.
I have an observation. As a developer you should have to option to make passwords visible when setting up the connection to avoid re-typeing the password several times to be sure you haven't done something stupid like leave the caps lock on.
Have you any suggestions?