No permissions when accessing the KACE sql database with MySQL Workbench
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.
-
do you orgs in your environment? What database are you selecting? - Timi 9 years ago
-
No orgs, I have the default schema set to ORG1. - Eray 9 years ago
-
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/ - Timi 9 years ago
-
It works like a charm Timi, thank you very much. - Eray 9 years ago
-
Another tool you might like is called FlySpeed. It is drag and drop and free. - nshah 9 years ago
Answers (1)
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.
Comments:
-
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. - Eray 9 years ago
