INSERT command denied

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kurt@triffetdesi
    Senior Member
    • Mar 2008
    • 120

    INSERT command denied

    My forum's been down for a couple months now. After a variety of php errors and fixes, now getting this one. No clue how to troubleshoot this.

    PHP Warning
    : mysqli_query(): (42000/1142): INSERT command denied to user 's1523786'@'10.30.72.4' for table 'datastore' in ..../includes/class_core.php on line 1394
  • Set3sh
    Senior Member
    • Jan 2013
    • 243
    • 5.2.x

    #2
    Hello,

    Please notify your host to enable the user that is specific to your database the following privileges: CREATE, DROP, DELETE, INSERT, SELECT, UPDATE.

    This can be done with:
    PHP Code:
    GRANT ALL PRIVILEGES ON 'database_name' TO 'username'@'host'
    Kind regards,
    George.
    Last edited by Set3sh; Thu 9 Mar '17, 10:34am.

    Comment

    • kurt@triffetdesi
      Senior Member
      • Mar 2008
      • 120

      #3
      Hi George,

      Is this something I can do myself through MyPHPAdmin? Web.com has become one of the worse in terms of support. Trying to see if I can fix before moving site and starting from scratch. Thanks!

      Comment

      • Set3sh
        Senior Member
        • Jan 2013
        • 243
        • 5.2.x

        #4
        Hello,

        I already provided the query you need to run in order to fix the problem.
        The only thing you have to do is to replace "database_name", "username" and "host" to reflect your environment.

        Kind regards,
        George.

        Comment

        Related Topics

        Collapse

        Working...