I think localhost is correct
Database server hostname or DSN:
DSN stands for Data Source Name and is relevant only for ODBC installs. On PostgreSQL, use localhost to connect to the local server via UNIX domain socket and 127.0.0.1 to connect via TCP.
when I try with 127.0.01 I get more error messages
Could not connect to the database, see error message below.
Lost connection to MySQL server at 'reading initial communication packet', system error: 111
So i've tried deleting the database, the username and database names stays the same when I recreate it, I've also tried resetting the password.
Could it just be I'm not setting the database up correctly so it's just not connecting ?
MW