Query Monitor DB Error Code 1142

  • Hi,

    I have a query monitor installed, and I am receiving an error from the index mysql plugin saying that the SELECT command is denied to user @ localhost. Error 1142 in SQL. Do you know how to fix this?

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thank you for the defect report. It probably means that your MySQL user — DB_USER in wp-config.php — lacks the PROCESS privilege in the database. The plugin is programmed to catch the query error and do the right thing. But Query Monitor also catches it and logs it.

    If the plugin displays its Tools page in the dashboard it’s working correctly. You can use it to rekey your tables.

    If it does display its Tools page, could you please go to the About tab (Tools > Index MySQL > About) and push the button to upload your metadata? If you tag your uploaded metadata “sim183” I’ll find it. (Different configurations of php and MySQL handle these errors differently, and I’d like to know which precise configurations you have, to add to my test suite.)

    If the plugin fails, would you be kind enough to reply to this thread and paste in the failing query? Query Monitor shows it in red

    (Detail: If the failing query involves the information_schema.INNODB_METRICS system table, that is a benign situation — it simply means the plugin has access to slightly less information about your server. When Query Monitor isn’t active, the failing query should be invisible.)

    Thanks for your patience with this.

    • This reply was modified 2 years, 9 months ago by OllieJones.
    • This reply was modified 2 years, 9 months ago by OllieJones.
    Thread Starter Simcha Hochman

    (@sim183)

    Sorry for the late reply, metadata has been uploaded.

    Thanks for looking into this for me!

    Plugin Author OllieJones

    (@olliejones)

    Thanks for the upload. You use v5.7.32 of MySQL; that particular version can’t be persuaded not to grumble about the metadata-gathering query I mentioned in my first response to your question. It looks to me like the plugin was successful except for the grumbling that shows up in Query Monitor.

    Best regards,
    Ollie Jones

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Query Monitor DB Error Code 1142’ is closed to new replies.