During installation I see an error: "1142 DROP command denied to user: 'jason@localhost' ... DROP TABLE IF EXISTS

To use Zen Cart, you need to grant the "user" of your MySQL database the right privileges for security access.

For normal Zen Cart operation, you should grant at least: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER permissions.
  • 219 Users Found This Useful
Was this answer helpful?

Related Articles

How can I find out what version of Zen Cart or PHP or MySQL I'm using?

To find out what version of Zen Cart or PHP or MySQL you are currently using, you can simply go...

Getting a BLANK PAGE? Here's the answer ...

If you're getting a blank page when trying to browse to a certain page on your store, or after...

What's New in the Upcoming v2.0 release?

Database Abstraction Layer and Sql CacheThe abstraction layer has been re-factored to include a...

Image Preparation - How-to

I've seen several posts where people obviously aren't quite sure about the best way to set up...

Some tips to modify stylesheet

1. Download Web Developer extension for FireFox here2. Install & restart FireFox. You should...