INSERT command denied to user 'user_xxx'@'localhost' for table 'table'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zeroeth
    Junior Member
    • May 2004
    • 9

    #1

    INSERT command denied to user 'user_xxx'@'localhost' for table 'table'

    has anyone come across this problem before?

    It seems when i run a SELECT statement it works.
    INSERT doesnt.

    I have granted "ALL" priviliges to user_xxx in cpanel-mysql.

    any help is appreciated.
  • AndrewT
    Administrator
    • Mar 2004
    • 3655

    #2
    If you submit a ticket with the details I can take a quick look.

    Comment

    • AndrewT
      Administrator
      • Mar 2004
      • 3655

      #3
      If anyone else runs into this error, it was due to the incorrect database being referenced in the INSERT statement in this case. The error wasn't particularly descriptive in describing the actual problem.

      Comment

      Working...