osCommerce error: DELETE command denied to user 'whos_online'

If you receive this error after installing osCommerce (the version I used was osCommerce Online Merchant v2.2 RCa). Once I clicked on the Catalog button, I received this error:

1142 – DELETE command denied to user ‘[username of database]’@’localhost’ for table ‘whos_online’

delete from whos_online where time_last_click < '1285743766' [TEP STOP]

osCommerce error message: DELETE command denied to user

osCommerce error message: DELETE command denied to user

To resolve this osCommerce error

In cPanel, once you login under the heading “Databases,” click on “MySQL Database.” You should see something like the following:

MySQL Database Setup in cPanel

MySQL Database Setup in cPanel

Click the username for the database you used during the osCommerce installation set up. I selected the following settings for database privileges this username will have:

How to change MySQL database username privileges

How to change MySQL database username privileges

SELECT
INSERT
UPDATE
DELETE
INDEX
CREATE
DROP

You can select:

ALTER

but I try to minimize the risks of enabling too many database privileges so that’s what I personally recommend. You have to enable DROP privileges and CREATE according to the osCommerce documentation installation guide.

That should get rid of this error.

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Share

You must be logged in to post a comment.