Mysql stopping install

[rbarnold]

I have been tring all night to install Zencart 1.38a but I am still locked up and can't get past the database section, even though I have entered the fields correctly.
I install phpBB3 at the same time but to a different database name and that worked fine.
The problems I am having are to do with the database host, username and/or password.
Following is an example:
database host: = mysql5.s430.sureserver.com
username: = robsuk
password: I have used the correct password
Database name: = robsuk_shop

The error comes back with:
ATTENTION: Problems Found
Connection to Database failed
Access denied for user: '[email protected]' (Using password: YES)

Zencart seems to be ignoring the "mysql5" part of the database host address, or something else.
I have never seen the "@" symbol used in accessing a database before and was under the assumption that it was only used in email addresses, I have no knowledge of php though.
I have spoken to my hosting provider and they have sugested other addresses as follows:
Please try using "localhost:/tmp/mysql5.sock" in order to connect to the database.
You can also try with mysql5.s422.sureserver.com Port: 3307
Neither work.
Mysql is part of the address because my provider has both Mysql4 and Mysql5 available during the phasing out of Mysql4

Any help would be much appreciated
Regards
Roger

[Kim]

Try using just 'localhost'.

[rbarnold]

Try using just 'localhost'.

I have tried localhost as that is what phpBB3 required however using it in Zencart fails the same as everything else I have tryed.
Thanks for the try though as having been up all night I could have missed that one.

[rbarnold]

Thanks, problem is now sorted, I got a clue from my hosting provider

[PumpkinAcer]

I have the same problem. What was the clue from your hosting provider?

[Vger]

My guess is that they were using the wrong database server address, or else they were using cPanel and had created the database, mysql user and password but had not assigned the mysql user to that db.

Vger