KACE Product Support Question
"SELECT command denied to user R1@localhost"
Most of my patch labels and many reports have been broken since our last K1000 upgrade. I'm trying to fix them but for many when I run the sql in MySQL Workbench, I get the error:
"SELECT command denied to user R1@localhost".
I'm able to run other queries from some of my older reports, but for many I get this error.
For example, this query which use to dump a list of all computers and the missing patches now gives the Select error:
M.NAME AS ComputerName,
M.USER_LOGGED AS USER_LOGGED,
PP.TITLE AS DISPLAY_NAME,
KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
MACHINE M ON M.ID = MS.MACHINE_ID
MS.STATUS != 'PATCHED'
AND PP.IS_SUPERCEDED = '0'
AND PP.IMPACTID = 'Critical'
ORDER BY PP.TITLE
Any ideas why I can 't run this in MySqlWorkbench?