zp + dreamhost + subdomain install = could not connect to the MySQL server

George G.

Hello,

I'm trying to install zenphoto on a subdomain on my website and even if I have all the mysql details correctly I receive this error message: "could not connect to the MySQL server". If it matters, I'm using dreamhost.

This is what I've done so far:
- setup a new subdomain called images
- copied all the files and folders from the zenphoto folder to the subdomain
- followed the path to the setup.php file
- filled in the MySQL admin user and pass, MySQL host and MySQL database
- hit the save button
- got the "connect to MySQL. Could not connect to the MySQL server. Check the user, password, and database host in your zp-config.php file and try again." error.

The zp-config.php file has the correct mysql datas. Any ideas, why isn't working?

sbillard

If you are getting this message, something in the parameters for the MySQL connection is not correct. Perhaps some other Dreamhost users can suggest what you might have done wrong.

albeezie

I am also using dreamhost but have no issues. Make sure you are accessing the actual dreamhost mysql url you have, not localhost. make sure also that you have previously created the main database for the account.

George G.

Thanks for the support. I changed the 'localhost' with mysql.mysite.com and it worked.