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.

[DrByte]

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

Are you always getting the *same* error message ?

[Chuckl]

When you connect using phpMyAdmin, is that as the same user and password as used in the ZC install you are attempting?
Likewise the PHPBB install.
If not, try that on the install.

What I'm trying to get clear in my mind is what is causing this pretty fundamental error. There are thousands of Zen Cart sites all over the world connecting to MySQL 4 databases every day. Coupled with the fact that the upgrade_exceptions table DROP TABLE IF EXISTS is the first SQL statement executed by the db installer that attempts to do anthing with the database. (I'm discounting existence checks etc, this is actually altering the database).

That said, I'm left with a probable cause of insufficient priviledges/permissions, or wrong username/password. Another possibility is attempting to access a remote MySQL server without remote access being enabled. I'm not sure that the error message is necessarily accurate beyond 'something went wrong', but it certainly indicates a problem.
Another one thats caught me before is usernames and passwords that contain ones (1) and ells(l), and ohs (O) and zeroes (0). In courier fonts they can be interesting.

My response would be to use MySQL 5, but then I've used nothing else since about version 1.2.7, so I'm probably biased.

[hbtechguy]

Hi Drbyte,

Yes every time i try install ZC database section always same error message.

[hbtechguy]

Thanks Chuckl,

yes i've copy and paste the User name and passwords, so i dont think it's cap issues with numbers and letters... i just dont understand why the phpbb is easy to install than ZC, phpbb connects to the db quite with ease, but ZC hesitate to connect to the db...

thanks guys for trying to help me, i hope we will get to the bottom of this..