Results 1 to 7 of 7

Thread: MySQL Error

  1. #1

    MySQL Error

    I am attempting to install an oscommerce installation, and am recieving a MySQL error #1142 - create command denied to user. So I tried to setup a table via phpmyadmin, and got the same error.

    I have been going back and forth with the webhosting company, who btw doesn't seem too knowledgeable on the subject. They say that the privileges are set correctly, and I have double checked my configure.php files. Anyone have any suggestions that I can try, or pass along to them?

    Any help is greatly appreciated. Thanks!


  2. #2
    Join Date
    Aug 2003
    Left Coast
    I don't know about osCommerce specifically, but the config script probably is edited to specify a mysql user. The mysql user must be granted full access to the database that has been created.

    Note that the mysql user is independent of the linux or windows userids. If you have a control panel for your account you can probably create a mysql user for the database. I know you can do this in cpanel.

  3. #3
    Join Date
    Oct 2003
    Certainly sounds like a mysql permissions error.

    Have you tried to inport via the command line?
    Brad Baker
    Rochen - True Premium Shared & Reseller Hosting since 2000
    Better Support: Expert support 24/7 from Red Hat and Cisco Certified Engineers
    Joomla! Core Team Member Joomla Tutorials

  4. #4
    looks like to me that it is a server setup issue what are the spacifics on your mysql what permitions are you granted. ETC.

  5. #5
    Join Date
    Feb 2002
    I am not famiier with that error on OSC but you might look HERE That sort of addresses the same thing??

    This is a different program but kind of explains it better HERE

    Maybe that will get you and maybe your host pointed in the right direction.

    BTW are you on CPanel or Plesk or??

    Light travels faster than sound, which is why some people appear bright until you hear them speak.

  6. #6
    Thanks for all the helpful info, I am still waiting for the hosting company to get back to me... I have no cpanel, plesk, or SSH access, so I am totally dependent on the host. BTW, the choice of hosting service was not mine.

    When the error pops up, it says such and such denied to [email protected]

    Is venus supposed to be the name of the host? B/C The host name provided to me by the hosting company is which is what I have in my configure.php file, and allows me at least to communicate with the db, and see the db they created for me, but not to manipulate anything.

    What is venus in this case? Typically I see this as localhost on other mysql implementations. where is this value set on the hosting side?

  7. #7


    did you give mySQL its own user?
    --missed last post sry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts