MORE install problems

[aaronb4146]

I want to do a new install of Zen Cart 1.3.6, here is what I am doing.

Download a new fresh copy of Zen Cart
Upload it to my site via ftp to a new folder called "shop2"
Run the Zen Cart Installer via web browser
Create a new database called "database" via cPanelx - MySQL
Create a new user "user" via cPanel x - MySQL
With password as "password" and issue full access Privileges
On PhpMyAdmin import by original backed up SQL Database in to new database (database)
Back on Zen Cart Installer I put in :

Database Type : MySQL
Store Identifier (Table Prefix) : NONE/BLANK
Database Host : localhost
Database Username : user
Database Password : password
Database Name : database
Datebase Sessions : [X]yes [ ]no
SQL Cache Method : [None]
Session/SQL Cache Directory : /home/STORE/public_html/shop2/cache

Why is this not working? It just keeps saying:

Connection to Database failed
Access denied for user 'user'@'localhost' (using password: YES)

What if anything am I doing wrong?

Cheers

Aaron

[Kim]

Have you created the database and assigned the user to it?

[aaronb4146]

Have you created the database and assigned the user to it?

I think so, this is what I have done

On cPanel x - MySQL Databases
New Database : [database] [ok]

New User
Username : [user]
password : [password]

Add Users To Database
user : [user] database : [database]
Privileges: all [x]

Are these the steps you mean?

[Ajeh]

Just for giggles and grins ...

1 recheck database name

2 recheck username

3 reset password incase you are confused

4 edit both files:
/your_directory/includes/configure.php
/your_directory/admin/includes/configure.php

Change path, database, username and password

5 make sure when you are done uploading the files that you View the files on the server ... do they read what you think you just changed them to?

NOTE: if set to 444, you need to set to 644 before attempting to overwrite and need to set to 777 for UPGRADE ...

[aaronb4146]

Ive tried creating different databases and users, ive done the configure.php files over and over again, yep files are being edited on the server and changes are appearing, and ive got 777 set do I need to change to 644?

cheers

Aaron

[aaronb4146]

I have deleted all the databases and users (exept root) and the new store folder and am going to try again from the start, this will be my 4th time totaly starting again, I do not understand why I am having this trouble.

I have got in touch with my host and they refered me back here! No help at all there. If anyone can think of ANYTHING that might get me through this it would be greatly appreachated, no matter how stupid or small I NEED ANYTHING!!

Cheers for your help so far

aaron

[Ajeh]

644 is for after you are done ...

777 is for when installing or upgrading ...

Are you able to access the database via your phpMyAdmin?

Did you add anything like special characters, spaces, hyphens, capital letters, too long of a database name or username or password to your database?

[Website Rob]

One thing that might be throwing you off is the way Cpanel sets up db Username & Passwords.

xxxxxxxx << this is the Username for your Hosting account.

xxxxxxxx_dbUsername
xxxxxxxx_dbName

Example
If your Hosting account Username is 'mydomain' and you created a db Name of 'zencart', then in your config files you would enter:
define('DB_DATABASE', 'mydomain_zencart');

Special note: when creating a Username for your database and the db Name, do not make either one more than 7 characters long.

[aaronb4146]

oh rite, yes I am able to access my database through phpMyAdmin and cPanel, my database, username and password are all in lowercase "normal" characters, ive checked for unwanted spaces at the begining and end of all three.

[Ajeh]

When in MySQL for cPanel ... look specifically at the database you just made and you should see the full database name and username ...

Read them both carefully incase something got truncated ...

And, as pointed out, be sure that you have used the "exact" name that you "see" and not the name you "think" you added as MySQL does "help" you in the naming of the database tables and usernames ...