Announcement

Collapse
No announcement yet.

INSERT command denied

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #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, 11:34am.

    Comment


    • #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


      • #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...
        X