Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    17
    Plugin Contributions
    0

    Default 1142 DROP command denied to user

    Attempting to create a shop for the 4th time I've gotten past the install 3 times in the past with no problems but then not completed building the site.

    This time I seem to be having an error with the installation in progress screen and I'm not sure what I should do.

    I get the message

    Installation In Progress...

    1142 DROP command denied to user 'cjgalaxy'@'216.177.143.4' for table 'upgrade_exceptions'
    in:
    [DROP TABLE IF EXISTS upgrade_exceptions;]



    There's nothing to show me if it's still doing something and I'm not sure if I need to be going and doing something and trying again. Can someone help?

    Determined to make this work this time, don't let me get stumped at the first hurdle

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Installation in Progress... Error?

    Your MySQL database user "cjgalaxy" doesn't have adequate MySQL permissions assigned to it. Go grant it ALL permissions and then start zc_install again.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Feb 2008
    Posts
    17
    Plugin Contributions
    0

    Default Re: 1142 DROP command denied to user

    Thanks, it seems to be working now :) Took me a few attempts, every time I granted all permissions it deleted the user :| Created one with dba permissions which is all but two checked boxes and it seems to be working.

 

 

Similar Threads

  1. 1142 DROP command denied to user
    By stefanl in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 27 Jul 2010, 09:05 PM
  2. DROP command denied to user @localhost
    By lkzone in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 4 Apr 2008, 08:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR