2

I have installed mySQL and MySQL workbench. changed the root password when I opened the mySQL workbench for the first time. I have created a simple table and when I try to query that, I am not able to execute the command. Infact not able to execute any query, including show tables; I am able to query them from terminal. I tried inserting some rows into the table from a simple java code, which I am able to do without issues.

Attached is the screenshot of the issue.

Screenshot showing the query executing for ever

Kindly let me know if anyone faced this issue and if there is any solution for this. Appreciate your help in this regard. Able to execute queries from Terminal.

Queries from Terminal

Improve this question
5
  • I am not able to execute the command ... what happens when you run that SELECT statement from Workbench? Commented Dec 4, 2016 at 3:01
  • Nothing is happening. No error and no processing. Just next to the query window the editor is showing as if the query is being executed for ever. I tried installing by completely uninstalling the SQL and SQL workbench from my machine couple of times. Still the same issue. I am wondering there could be some setting that I am missing. Commented Dec 4, 2016 at 3:03
  • Your Workbench probably has a connection problem, possibly SSL. Commented Dec 4, 2016 at 3:13
  • Might be. But I am completely not sure if it is a SSL problem. If it is so, it has to give me the same problem if I execute the queries from Terminal. Suspecting something related to SQL workbench Commented Dec 4, 2016 at 3:20
  • I am saying that Workbench has a connection problem. Obviously both Java and the command line can reach the server. Commented Dec 4, 2016 at 3:26

2 Answers 2

Reset to default
3

This is old but I've ran into this problem lots of times and just now tried to see what's going on.

It's a bug that's well known and seems to pop up over and over again with new releases (both MySQL Workbench and macOS). Bug #83658 is the primary one (and where all the dozens of duplicates are being linked to).

There's a link at the end to bug #87714 where the issue itself seems to be unrelated but the reporter (Bob Davenport) fixed it by modifying the source and recompiling. You can find the link inside and I'll post it here for completeness sake. It fixed it the same problem you're having for me:

https://drive.google.com/drive/folders/0B2fTesDcrHzVRGVFWEdILWpuaEE?usp=sharing

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

  • My MySQL server started on boot.. in the bug report one of the solutions is to restart your server and workbench.

  • Restarting server and workbench worked for me

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.