Cannot install oscommerce

[Guest]

I tried installing oscommerce automatically but it didn't work. For some reason the auto config could not access my dbase server. So I logged into my server and followed the install.txt that came with oscommerce and manually (using phpAdmin) created and imported the sample tables.

 

That worked.

 

Then I went back to try to install oscommerce but I still get the same ACCESS DENIED error when the install.php attempts to create/check the existence of my dbase.

 

How do I overcome this and install oscommere?

 

Please advise.

 

Cheers.

[detsouvalas]

As we do not see what you see on your screen, start by posting the exact error message you get!

[Mark Evans]

There are only 3 things which cause the access denied.

 

1. Incorrect username

2. Incorrect password

3. Incorrect permissions

[Guest]

I tried installing oscommerce automatically but it didn't work. For some reason the auto config could not access my dbase server. So I logged into my server and followed the install.txt that came with oscommerce and manually (using phpAdmin) created and imported the sample tables.

 

That worked.

 

Then I went back to try to install oscommerce but I still get the same ACCESS DENIED error when the install.php attempts to create/check the existence of my dbase.

 

How do I overcome this and install oscommere?

 

Please advise.

 

Cheers.

Are you using your password when trying to open your database, If you are try it without it, I know I had that problem when I was trying to install it.

[Guest]

I've changed the details slightly but this is the basic error msg appearing. This error comes after trying Starview's suggestion of omitting the password but still no results. The same error occurs when I use the dbase password only the 'using password:NO' is replaced with a 'using password: YES'. But still an error.

 

Any way around this?

I've even tried unchecking the auto import of dbase but the app still prompts me to create the dbase regardless.

 

Thanks for the overwhelming responses thus far. Its been encouraging. I hope I get this up soon!

[Guest]

The mySQL permissions for your user are incorrect - a password will also be needed :)

 

This info will be written to the osCommerce configuration files - your store will not run without it, even if you do install the database manually :P

 

Matti

[starcad]

You really need to check your database name and your password. You only get this error when one of them is wrong. Another thing you might check is if your premissions are set correctly as this can cause a ton of things to go wrong.

[Guest]

Have you created a database in MySql togehter with the permissions for the user that will be using the database.

 

For example:

 

mysql --password="mysql-root-password"

 

CREATE DATABASE oscommercedatabase;

GRANT select,insert,update,delete,create,drop TO oneoscommerceuser@localhost IDENTIFIED BY 'onecommerceuserpassword';

 

quit

 

That is how it is working for me. I actually lack those info when you want to install oscommerce but i figured that out by myself. If this is wrong than please do tell so I can learn also.

 

Richard

 

:unsure: