Installation problem

MeginMurphy

I'm trying to install on a sub domain on Network Solutions. I keep getting this error message.

"Could not connect to the MySQL server. Check the user, password, and database host in your zp-config.php file and try again."

I have been working through my site hand coding and try to code a photo gallery and struggled.

I thought this was going to be easy.

acrylian

After installing you need to run zp-core/setup.php where you should be asked for your mysql username, password and database. If you don't know those you will have to ask your ISP.

virtualburn

have you manually setup a Database..?

You need your host name or 'localhost'
Database name and the user and pass associated with this host

MeginMurphy

Yes, I manually set up the database and my host name is 'localhost'.

1. Should the username and password be the info we use to log into Network solutions or the username and password associated with that particular database?

2. Also, because I have all of the Zenphoto docs in the subdomain, is that possibly the problem? Do I need to move some of the set up docs into the main domain directory?

Thanks,
Megin

MeginMurphy

I have run the set up; that's where I'm receiving the error message.

virtualburn

It will be the User/Pass relating to the Databse you created - try using the hostname of your database - mysql.name.com 'localhost' does not always work with some servers.

sbillard

The user/password you supply should be the one you created when you setup your database. `localhost` may not be correct for the database server. You would have to check with your provider.

Installing in a subdomain might be a reason for `localhost` not being correct. Other than that there should be no problems installing in a subdomain.

MeginMurphy

I have removed and installed numerous times in the main domain and I'm still getting:

Could not connect to the MySQL server. Check the user, password, and database host in your zp-config.php file and try again.

The username and password are correct. The config.php file self populates but not the config source file. I type in and save the correct information there and go through the install again and receive the same error message.

Any ideas? I'm about the call Network Solutions regarding the issue. It might be the host name, but I've tried localhost and my host name and both return this same error message.

MeginMurphy

Okay, Network Solutions confirmed my host name was wrong. So, I fixed that. Now I received a bazillion error messages.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /data/16/1/10/39/1499039/user/1612490/htdocs/zenphoto/zp-core/setup.php on line 536

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /data/16/1/10/39/1499039/user/1612490/htdocs/zenphoto/zp-core/setup.php on line 538

MySQL access rights [unknown]

Your MySQL user must have Alter, Create, Delete, Drop, Index, Insert, Select and Update rights.

The SHOW GRANTS query failed.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /data/16/1/10/39/1499039/user/1612490/htdocs/zenphoto/zp-core/setup.php on line 584

MySQL show tables [Failed]

MySQL did not return a list of the database tables for PBE.
Setup will attempt to create all tables. This will not over write any existing tables.

Ugggggg If this is easy......any suggestions?

krainbolt

Are you sure the username and password is correct? Did you create the MySQL username and password for zenphoto yourself? Did you remember to create the MySQL zenphoto database?

MeginMurphy

The MySQL zenophoto database? The database is created in MySql, but I don't have one specific to zenphoto?

sbillard

can you post a link to your site so we can look at the exact output from the setup program?

MeginMurphy

wooohooooo I figured it out! I had to change the database name to zp_database name and it worked. YeehaWw!