The username was the issue. Read, re-read and then read again...sorry Jason!
So, my next issue with this is that I want to connect to a new MySQL database which is hosted elsewhere (in preparation for moving the website to our servers). I have provided the connection details for that below.
When I try and create the MySQLi Connection for it, I get the following error:
"A server timeout has occured . Here are the possible reasons.
1. Please make sure that the web server is up and running.
2. Please verify that the ODBC DSN exists on the testing server."
I should be able to connect to an external database, shouldn't I?