Zen Cart Logo
Forums / Installing on a Linux/Unix Server / install zen 1.3 database does not exist???

install zen 1.3 database does not exist???

Views: 3,380

Results 1 to 20 of 22
22 Mar 2011, 1:41 PM
#1
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

install zen 1.3 database does not exist???

Am trying to install zen 1.3.9h on my 1and1 server. After a previous positive installation where i could not add for some reason a new theme i reinstalled uploaded and created a new database. When now trying to introduce the database info i get "Database does not exist Access denied for user 'dbo....' to database 'zen...'
Any ideas? advice?
thanks

22 Mar 2011, 2:30 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: install zen 1.3 database does not exist???

When now trying to introduce the database info
Introduce when & where?

22 Mar 2011, 3:43 PM
#3
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: install zen 1.3 database does not exist???

If you're seeing that during installation, I'd guess you're entering the wrong database name. On most shared servers, you have to prepend your control panel user name to the database name, so: username_databasename

22 Mar 2011, 7:24 PM
#4
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

kobra:

Introduce when & where?

zc_install/index.php - have copy pasted database host and username so cant be the problem that am inserting wrong data

22 Mar 2011, 7:25 PM
#5
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: install zen 1.3 database does not exist???

zc_install/index.php - have copy pasted database host and username so cant be the problem that am inserting wrong data
Copied and pasted to where?

Hopefully not into the index.php file???

22 Mar 2011, 9:40 PM
#6
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

kobra:

Copied and pasted to where?

Hopefully not into the index.php file???
no to iniciate the shop i have to put in the info database host, database user and pass so i did that from the info i have from my data base...
Host name db2883.perfora.net
Port 3306
User name dbo362302534
Version MySQL5.0
just tried again and i get the same red notice
Database does not exist
Access denied for user 'dbo362302534'@'%' to database 'zencart'

22 Mar 2011, 11:13 PM
#7
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

For starters -->Can you access the database using PHPmyAdmin?
A MySQL account is identified by both a username and a hostname, which are found in the User and Host columns of the mysql.user table
this will provide you with the information stored in the database as a reference check point.

23 Mar 2011, 5:58 PM
#8
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

yes i can get into phpmyadmin and the db info (name, user name, host) coincides with the info i put into the zen installation page - have created a few databases to test but get same problem with each one
Database does not exist
Access denied for user 'dbo362302534'@'%' to database 'zencart'

23 Mar 2011, 6:04 PM
#9
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: install zen 1.3 database does not exist???

melanie bund:

Access denied for user 'dbo362302534'@'%' to database 'zencart'

What are you entering as the database name ?

23 Mar 2011, 6:48 PM
#10
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

Check your user priviledges. The FILE privilege gives you permission to read and write files on the Mysql server

23 Mar 2011, 6:55 PM
#11
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

am not entering database name as the installation asks for
Database Host which is - Host name db2883.perfora.net
Database Username which is - User name dbo362302534
Database password - which i put in and database name which i put in

23 Mar 2011, 6:57 PM
#12
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

have also just tried entering database name not database user and get same results

23 Mar 2011, 7:00 PM
#13
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: install zen 1.3 database does not exist???

melanie bund:

am not entering **database name ... ** and database name which i put in

?????

What name are you entering ? Zencart installation requires that you enter the name of the database.

The error message you're getting is saying that the database with the name you specified doesn't exist.

You might also try localhost as the Database Host.

23 Mar 2011, 7:04 PM
#14
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

check the permissions you mean? have checked and they are all green in the checklist before u install. Or do u mean something else? where can i find how to do this?

23 Mar 2011, 7:16 PM
#15
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

have also tried with local host and get
Connection to Database failed
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

23 Mar 2011, 7:36 PM
#16
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

mysql priviledges. in your Web control panel. did the host give you the username ?

23 Mar 2011, 7:53 PM
#17
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

almost sounds like a firewall is blocking port 3306 ?

23 Mar 2011, 9:47 PM
#18
melanie_bund avatar

melanie_bund

New Zenner

Join Date:
Mar 2011
Posts:
10
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

yes the host gave me the details of the database i set up see below
Database name db362302534
Host name db2883.perfora.net
Port 3306
User name dbo362302534
Description zencart
Version MySQL5.0

i have about 7 databases and they are working fine on my other sites using the same port 3306 - just cant figure out what is wrong plus in my control panel PHPMySQL config cant do much but set up databases

23 Mar 2011, 10:22 PM
#19
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

in the configure .php files under 'define our database connection' you say everything is identical in the two configure files? ( store side and admin side )
how many characters in the password?

23 Mar 2011, 11:35 PM
#20
usr50 avatar

usr50

Zen Follower

Join Date:
Mar 2009
Location:
Niagara Ontario
Posts:
136
Plugin Contributions:
0

Re: install zen 1.3 database does not exist???

quote "Access denied for user 'dbo362302534'@'%' to database 'zencart' "

read from http://dev.mysql.com/doc/refman/5.5/en/access-denied.html

MYsql -If you cannot figure out why you get Access denied, remove from the user table all entries that have Host values containing wildcards (entries that contain '%' or '_' characters). A very common error is to insert a new entry with Host='%' and User='some_user', thinking that this enables you to specify localhost to connect from the same machine. The reason that this does not work is that the default privileges include an entry with Host='localhost' and User=''. Because that entry has a Host value 'localhost' that is more specific than '%', it is used in preference to the new entry when connecting from localhost!