Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Location
    Georgia
    Posts
    68
    Plugin Contributions
    0

    Default DROP command denied to user @localhost

    I'm receiving the following error when attempting to import my data into my new database. (I'm in the process of upgrading from 1.3.7 to 1.3.8a) What I just noticed as I pasted the error is the database: 'mktrack_hp_zencart' -- This is the old database (1.3.7 site) -- Any ideas?

    Thanks.


    Error
    SQL query:

    --
    -- Database: `mktrack_hp_zencart`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `address_book`
    --
    DROP TABLE IF EXISTS `address_book` ;



    MySQL said:

    #1142 - DROP command denied to user 'mktrack_zen138'@'localhost' for table 'address_book'

  2. #2
    Join Date
    Jan 2008
    Location
    Georgia
    Posts
    68
    Plugin Contributions
    0

    Default Importing Data during Upgrade to 1.3.8

    I'm receiving the following error when attempting to import my data into my new database. (I'm in the process of upgrading from 1.3.7 to 1.3.8a) What I just noticed as I pasted the error is the database: 'mktrack_hp_zencart' -- This is the old database (1.3.7 site) -- Any ideas?

    Thanks.


    Error
    SQL query:

    --
    -- Database: `mktrack_hp_zencart`
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table `address_book`
    --
    DROP TABLE IF EXISTS `address_book` ;



    MySQL said:

    #1142 - DROP command denied to user 'mktrack_zen138'@'localhost' for table 'address_book'

  3. #3
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: DROP command denied to user @localhost

    Quote Originally Posted by lkzone View Post
    #1142 - DROP command denied to user 'mktrack_zen138'@'localhost' for ...
    That means that your 'mktrack_zen138' user which you created in MySQL doesn't have the required permissions to your database.
    Go back and add all permissions to that MySQL user, using your hosting control panel.
    .

    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.

 

 

Similar Threads

  1. v155 zcInstallDEBUG log: Access denied for user ''@'localhost'
    By Feznizzle in forum Installing on a Linux/Unix Server
    Replies: 8
    Last Post: 26 Jun 2016, 12:36 AM
  2. 1142 DROP command denied to user
    By Catisfaction in forum Installing on a Windows Server
    Replies: 2
    Last Post: 20 Nov 2011, 01:57 AM
  3. 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

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