Data Base Issues - not connected - during install

[hbtechguy]

i've spoken to my host, they said that Zen Cart uses MYSQL 4 database only
so they created one for me,

i still keep getting this message.

0 Install Error: Could not connect to the Database
in:
[DROP TABLE IF EXISTS upgrade_exceptions;]

has any one seen this before! please help!

[yellow1912]

You might provide the wrong information for ZC to connect to database, this does not have anything to do with the version of mysql. Make sure you have the correct link to your database (which is "localhost" most of the time), the correct username and password. And you also have to create a database for zencart.

[hbtechguy]

thanks for you prompt reply yellow1912, i still get the same issues
still can't connect to database server.

i provide same information, i currently running phpBB forums on this domain

i'm just adding ZC to my site, but also created another database to connect to.
even i tried it with my existing database, still not connecting.

dont know what the issue is, i followed the install instruction mod 777 files to those need as per instructed.

[yellow1912]

First: Im on php5 with mysql5 and my site is working great. Your host's saying that ZC does not work with mysql5 is lame.
Second: you said they created a mysql4 database only for you, does that mean you now have 2 databases (1 using mysql4 and and one using mysql5 for phpbb)
Is ZC on the same server with your phpbb forum?
If you provide your phpbb database info instead, can ZC connects to your db?

[hbtechguy]

First: Im on php5 with mysql5 and my site is working great. Your host's saying that ZC does not work with mysql5 is lame.
Second: you said they created a mysql4 database only for you, does that mean you now have 2 databases (1 using mysql4 and and one using mysql5 for phpbb)
Is ZC on the same server with your phpbb forum?
If you provide your phpbb database info instead, can ZC connects to your db?

Yes you are correct yellow1912, my phpbb3, is using mysql5 db working great with php5, only thing i have tried to use the same database info for ZC still can't connect. I was just wondering, can both be run on the same server? but as u mentioned your's is working great?! i feel sad , host did created another database, yes i have 2 database now, one is phpbb3 mysql5, other is mysql4 nothing in it, it's new!

[yellow1912]

Ok, if you are 100% sure you entered everything correctly, here is one thing you can check:
Basically, for security reason, mysql server only accepts connection from a trusted list of servers. If you database is on the same server with your http server, you would use 'localhost' as the link to your database. In some cases, mysql is located on a different host, and you need to contact your host, tell them that you cant connect to the database server from your site, they will add your web host's ip to the trusted list.

Regards.

PS I think 1and1 uses this kind of remote mysql database.

[hbtechguy]

yes my database is hosted on a different server, if my phpbb3 is working fine, how possbile things could've of changed? i'm so confused.

my forums database is up and running so as my site, i was wondering
is it possible that cgi is enable? causing this problem?

[yellow1912]

No, cgi shouldn't cause this kind of problem. Again, contact your database host, tell them that you need to connect to your database from yoursite.com, they should know what to do.

Regards.

[hbtechguy]

ok, i will call them up now, see what they can do, thanks so much yellow1912, i will post again to let you know how it go!

thank you

[hbtechguy]

ok, called up the host, they say database is working fine,

must be ZC software. they can't give me support.

so what i'm doing is, deleting the ZC dir, and installing fresh one.