Problem with MySQL on default install.

[richto]

On an new install of mySQL and oscommerce on Windows 2003, oscommerce cant access the database unless you do the following from the mysql command window:

 

 

In mysql console, type

 

use mysql;

 

to choose mysql database.

 

Then type :

UPDATE user SET password = old_password('yourpassword') WHERE user = 'theuser';

 

'theuser' is the user you're using to connect to the database with your application.

 

 

Would be nice if the instructions or the knowledge base actually mentioned this....

[Guest]

A very good point, as you need to have read and write access in mySQL to install osCommerce.

 

We should have a Common Trouble Shooting section to compliment this forum. :thumbsup:

[♥Vger]

The problem lays in Windows servers being designed to run MS SQL and not MySQL. But MS SQL databases are so expensive (as they are not Open Source) that many choose the free OpenSource MySQL option - which runs perfectly well in the environment it was designed for.

 

Vger

[richto]

You often get what you pay for...

 

In what way is this related to server OS design?

 

Looks like either an mySQL or an oscommerce config compatibility issue to me...

[richto]

Given the choice I would much rather use MS SQL as I am already licensed and it has many advantages. But sure, 6 Billion a year of R&D has a cost that that you pay for somewhere.

 

However, I expect that the desktop version of MS SQL server which is freely installable would provide equivalent performace to mySQL for most users.