Cannot Connect to DB with MySQL Workbench even after reviewing similar posts
I am trying to connect MySQL Workbench to our K1000. I have read the information I have found at the following sites:
I made sure the port was open and that the services are running. I have confirmed the password is correct for r1 and we only have one organization.
I have uninstalled and reinstalled MySQL Workbench. Nothing works. I have also seen various other posts on other sites relating to problems not being able to connect various databases to MySQL. Nothing I can find is helping me get any closer to an answer.
From what I am reading, it appears that the only thing I need to do on the KACE side is to check the enable database access boxes, which I have done.
I have tried to connect with the ODBC settings and the MySQL Workbench – both failed to connect.
My end goal is to see the tables in the database so I can create rules to copy device information from the inventory to the asset tables. I can’t figure out a way to get this done without access to the tables so that I can make sure the names are correct. Are there any other programs besides MySQL that I can try?
I know this is asking a lot but I am running into dead ends. Any assistance would be gratefully accepted.