Where can I find idiot-proof instructions on connecting to the Kbox with MySQL Workbench? Any help is appreciated!
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en
Nothing is idiot-proof; I always find a way to break something :)
One thing I've found is sometimes you need to reboot your workstation after you install all of the ODBC drivers and whatnot.
Answered 12/30/2011 by: cblake
Red Belt

Please log in to comment
0
Thanks. That is the article I was looking at but even after multiple attempts and reboots, I can't seem to get the MySQL 3.51 driver to show up in the ODBC Data Source Administrator window.

I have a K1000 running 5.3.45497
Answered 01/03/2012 by: jgro
Senior Yellow Belt

Please log in to comment
0
That article may be a bit dated, especially if you're running a Win7 or x64 station.
Try the newer connectors at http://dev.mysql.com/downloads/connector/odbc/ and let us know if you have better results.

I've also heard good things about FlySpeed (after the MYSQL ODBC Connection is established.) http://www.activedbsoft.com/overview-querytool.html
I haven't used it personally, but I've seen positive things.
Answered 01/03/2012 by: cblake
Red Belt

Please log in to comment
0
Thanks. That gets me the ability to add the ODBC connection, but the test still fails everytime. Do I need to turn on database access in the settings or do anything else? I've checked the database name & report username, and ever reset the password for "R1" on the Kbox to make sure it is what i'm typing for the ODBC connection...
Answered 01/04/2012 by: jgro
Senior Yellow Belt

Please log in to comment
0
Yes, Database access option in Settings--> Control Panel--> Security is required. It's on by default and I made an assumption it wasn't off; sorry.
Answered 01/04/2012 by: cblake
Red Belt

Please log in to comment
0
Also, if you're in an organization where you don't control the network infrastructure (firewalls, routers, and the like), you might need your network administrator to open the MySQL port(s) between your client machine(s) and the server. Sande
Answered 01/08/2012 by: snissen
Fourth Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity