I've used all of the info provided by site site host and when I run the setup I get:

zenphoto setup
MySQL Error: Could not connect to the database server.

database not connected
Check the zp-config.php file to make sure you've got the right username, password, host, and database. If you haven't created the database yet, now would be a good time.

Any suggestions on what else to check for would be appreciated.

Thanks,

Bear.

Make sure you have the correct host... it's not always 'localhost' especially if you're using Dreamhost.

Really check the credentials, it should be able to connect if they are correct. Check another MySQL/PHP application that's on your server for how it connects.

The last remote possibility is if your host is running MySQL 4 or later with new password hashes. If that's true, create a new user, and set their password with an MD5('password') manually. ONLY DO THAT if you're really sure you have everything correct, and you might want to contact your host too just to make sure. They might know the problem.

From your site it looks like you got it working :-) Yeah?

Hello.
I am trying to connect from my local computer to a Dreamhost database.
I manage to connect to database using mysql command in terminal but Zenphoto refuses to connect.
I am using exactly the same credentials on both cases.
Please help!
Thanks
Itay

You mean you have a local server and want to use the database on an external server? I have to admit I never tried that or even thought about trying that....

You need to be sure that both the credentials and the host are set correctly. Specially since this would not be a local host.

(But then, why would you wan to do this? Use a local MySQL database, it will be much faster. Not sure if performance of a remote database would even be adequate.)