I have been trying to access the sql database for our K1000 using MySQL Workbench using the default credentials of R1 and box747, but when I input any sql statement it errors and says I do not have permission to use those statements, such as select.  I've tried using other commands like grant to give myself permissions but they all seem blocked.  I am positive the username and password are correct, I can even get in and see all the tables.  Has anyone experienced anything similar or have any suggestions.  Thank you all.

Answer Summary:
5 Comments   [ + ] Show Comments


  • do you orgs in your environment? What database are you selecting?
  • No orgs, I have the default schema set to ORG1.
  • Try using the mysql query browser. I seem to remember after the post that I had some issues with the workbench. http://downloads.mysql.com/archives/query/
  • It works like a charm Timi, thank you very much.
  • Another tool you might like is called FlySpeed. It is drag and drop and free.
Please log in to comment



I see you got some help in the comments but I wanted to add something:

R1 does NOT have write access to the database.  I use the mysql workbench just fine but try to remember that you only have READ writes into the kace Database.  Only KACE (the device and support) have write access. For example, ticket rules can write to the database.


Mysql Workbench is a great tool for testing select queries, reporting against, or info lookup, though.

Answered 05/09/2014 by: Wildwolfay
Red Belt

  • I agree it is fantastic for tweaking my reports. I've been using the mysql query browser without issue now. I'm still new to actually using sql outside a classroom but it's been nice to have that api style interface to correct my syntax errors.
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja