Installation problems

[Guest]

Hi, im totally new to this commerce, and im not a guy that needs to be told RTFM or STFW. I downloaded osCommerced and started to read all the documentation. The clue is that im not so familiar with SQL. So, when i tried to install osCommerce, i got this problem saying: "Unable to connect to database server!" Im currently running WinXP with Apache web server. Used PHPtriad to get php installed, which included MySQL. All works fine, php and html, but i dont know anything about MySQL or how to install osCommerce with a database solution.

 

Hope you guys can help me,

 

Greetings, Henrik.

[nick]

Try www.oscdox.com

[Guest]

Thanks.

 

Do you think its smart to use PHPtriad? It installs apache,mysql and php in one package. *Just wondering :)

[nick]

Do you think its smart to use PHPtriad? It installs apache,mysql and php in one package. *Just wondering :)

 

PHPTriad, Foxserve, fill_in_your_windows_trio_here are all ok (for windows). Best is always a good Linux build with apache, php & mysql IMHO

[Guest]

Ok. On the site you gave me url, the .pdf says something about a install.php script. Not included in the version i got? Cant find it...

[Guest]

Ok, got the install.php now. Got this error when pressing continue: Can't connect to MySQL server on 'crasy' (10061)

[dreamscape]

Best is always a good Linux build with apache' date=' php & mysql IMHO[/quote']

 

maybe for running a live site, but for development that really is not much of an option for those of us being held by a firm grip from Micro$oft...

[Guest]

Step 1: Database Import

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

Access denied for user: 'CrasY@crasy' (Using password: YES)

 

What is that? ;)

[Qbaze]

Hi

I'm also a beginner at mysql...just been running it a couple of weeks now.

 

Heres how I did to get Osc2.2 running on mysql (Linux/debian)

 

Create a database called Catalog (I did it with phpmyadmin)

add the user wich OSC2.2 will use to connect to the database.

 

Run this query on database Catalog:

GRANT ALL PRIVILEGES ON *.* TO your_user@localhost IDENTIFIED BY 'your_pass' WITH GRANT OPTION;

and this one

 

GRANT ALL PRIVILEGES ON *.* TO your_user@"%" IDENTIFIED BY 'your_pass' WITH GRANT OPTION;

 

Explenation:

your_user

A full superuser who can connect to the server from anywhere, but who must use a password 'your_pass' to do so. Note that we must issue GRANT statements for both your_user@localhost and your_user@"%". If we don't add the entry with localhost, the anonymous user entry for localhost that is created by mysql_install_db will take precedence when we connect from the local host, because it has a more specific Host field value and thus comes earlier in the user table sort order.

 

 

Now you can run the install.php and put in the user and password you set in mysql.

 

I am not 100% sure that this is the right way....but it worked for me :D

Hope this helps

Regards

/Andreas

[Guest]

Thanks alot neighbour!! *Norway here :)

 

This look great. Need to config some things first...iiha

 

 

-Best regards, Henrik

[tomslaptop]

I tried this on Windows XP Professional and it works good and is easy to install. Comes with phpmyadmin and its own control panel. Cost 20 bucks and MySQL is added on as a seperate module. Start the database server connection from the Sokkit contol panel.

 

Sokkit 3.0 Core - Web Server and PHP engine. Apache 2.0 and PHP 4.2.3, a fully functional PEAR installation.

 

Sokkit Module: Database - Add the MySQL database capability to your installation. Includes the wildly popular PHPMyAdmin for visually managing databases.

 

Getting Started Documentation.

 

 

http://www.sokkit.net