OSC installation, Access denied for user:

[Lynx]

Access denied for user: '****@localhost' to database 'oscommerce'

 

1) I know, you'll say make sure server is localhost,

2) make sure user/pass is correct

3) make sure Admin has set up the database

 

All of these are true, I have apache 1.3 on windows XP with MySql 3.23

and php 4.3.3

 

I just cannot get past catalog/install/install.php step=2!

If I refresh after it says

Access denied for user: '****@localhost' to database 'oscommerce'

it tells me "Table 'temp' already exists"

if I check in the osc DB, there's the temp table, created by the instal program, but still not able to connect to localhost properly??

 

I delete the temp table, and try it again, and it tells me user denied again :(

[Guest]

do you have cpanel?

 

If so delete the db and recreate it

 

If you do not have cpanel and cannot perform this with shell access contact your host

[Lynx]

What is cpanel? it that like PHP My Admin?

 

I am my own host, it's my own server, I've deleted and recreated the db severl times

when I try again, and it's the same as before...

 

 

"A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: '****@localhost' to database 'oscommerce'

 

Please click on the Back button below to review your database server settings."

 

I've reviewed the db settings, I've tried setting it up with different MySQL DB users, even root, and it's always this same page

[Lynx]

ok, forget it, apparently some data in the mysql user accounts was corrupt and replacing that data lets it all work now ;-)

[Guest]

On your own server, try 127.0.0.1 instead of localhost

 

The_Bear