/build/static/layout/Breadcrumb_cap_w.png

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:

http://www.itninja.com/question/connecting-to-back-end-sql-kace-1000

https://www.parallels.com/blogs/ras/configuring-the-windows-server-2008-r2-firewall-to-open-ports-for-2x-solutions/

https://stackoverflow.com/questions/24525736/cant-connect-to-mysql-server-on-127-0-0-1-10061-2003

 

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.


4 Comments   [ + ] Show comments
  • I use toad, but Mysql workbench should work fine.

    Also, if you are using version 8, check this URL:
    https://support.quest.com/kace-systems-management-appliance/kb/234524

    If you are 100% sure about the port being open then contact Tech support - Channeler 6 years ago
    • Thank you. We started using 8.0 so there was no upgrade that could have interfered with database access. I have submitted a ticket with Quest in the hopes that they can help me. - jessburd 6 years ago
      • Let us know the outcome - Channeler 6 years ago
      • They confirmed the settings in KACE and MySQL Workbench is correct. However, I still cannot connect. My progress is effectively stalled until this can be resolved. - jessburd 6 years ago
  • Try HeidiSQL. It uses it's own session manager rather than an ODBC connector - Druis 6 years ago
    • I just downloaded it to give it a try. Frustratingly, I am getting the same error with HeidiSQL. It cannot connect either. - jessburd 6 years ago
  • Did you capitalize R1 and ORG1? - chucksteel 6 years ago
    • I did not but when KACE Support remoted in, he corrected it. However, it still will not connect. - jessburd 6 years ago
  • Just curious did you ever get this resolved and if so what was the solution? I am having the exact same issue - bowenz 5 years ago
    • Unfortunately, no. I ended up useing HeidiSQL instead. - jessburd 5 years ago

Answers (3)

Answer Summary:
Posted by: jessburd 5 years ago
Purple Belt
1

Top Answer

I had to give up on MySQL. I am using HeidiSQL instead.
Posted by: jessburd 6 years ago
Purple Belt
0
I can't provide any information has to how this problem was corrected but Quest Support restored access.
Posted by: five. 6 years ago
Second Degree Green Belt
0
On mine it was the kb referenced earlier. I had to enable secure database access, generate the key and then disable secure database access. Then accessing it via username / password worked again.

Comments:
  • We have only had 8.0. So if I understand the information correctly, this would not apply to us. When I go to the Logs and check update, there are no logs since we have never applied an update. Just to over my bases, I have activated the secure database access and generated the key, but it has made no difference whether it is active or not as it has been tried both ways multiple time. - jessburd 6 years ago
    • Could it be a client firewall or antivirus issue? Have you tried from multiple machines? You could try adding a firewall rule or temporarily disabling firewall. - five. 6 years ago
      • I turned off the firewall on my computer and allowed the port on the server. I also temporarily disabled our protection software. None of these actions made a difference. - jessburd 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ