Problem with Installation Step 2 database settings

[rockstar]

Hi, I'm trying to do a local install OSC on my Win XP machine and seem to be missing some step. Here's what I've done so far:

 

1) Installed and (presumably) configured correctly Apache server, php-4.3.6-Win32, and mySQL for Windows XP (although I'm wondering from my error message if I have skipped some step in mySQL.)

 

2) Downloaded and unzipped oscommerce-2.2ms2, copied the folder Admin and pasted it into my root htdocs folder, then copied the catalog folder and also pasted it into my root htdocs folder.

 

3) From my root htdocs folder, opened catalog/install/index.php and followed the directions from the new installation document found at http://wiki.oscommerce.com/docsInstallNew

 

At Step 2 of installation, I entered the following:

Database Server: localhost

Username: astonest

Database name: astonest

Persistent Connections box checked and Sessions Storage: database checked

 

When I pressed the Continue button, I got the following error message:

Access denied for user: 'astonest@localhost' (Using password: YES)

 

Now I never created a username or database with the name "astonest" with mySQL, I simply followed the instructions from their website for a default installation. (astonest will be the name of my future website). Their instructions also suggest setting a password for the grant tables (whatever those are) which I did not do, I figured that since I would be the only one working on my machine, I didn't need one.

 

Can someone tell me where I went wrong or how to solve this problem so that I can install os commerce? Thanks in advance.

 

Charles

[bluepony]

You need to create a database, user, and password in MYSQL. The best tool that I have found for MYSQL is PhpMyAdmin.

 

http://wiki.oscommerce.com/docsInstallNew

[Guest]

Can someone tell me where I went wrong or how to solve this problem so that I can install os commerce? Thanks in advance.

You didn't go wrong really, but the text that you need to have created a database before you start an oscommerce installation is actually omitted.

 

I don't know how mysql can create databases in windows. But as bluepony suggested you might want to try PHPMyAdmin

 

Here is the documentation for it:

 

http://www.phpmyadmin.net/documentation/#require

 

Richard

 

B)

[sbeckstead]

MySql creates databases in windows the exact same way it does in Linux or any other OS that it works on. I do recomend phpMyAdmin as a minimum otherwise you will be trying to get this thing created for ever. However When installing MySql create the user without a password then change it immediately with PhpMyAdmin. Don't ask me to explain, it wouldn't make sense anyway.

 

Scott

:D