I'm using MySQL Workbench 6.3.9 for Mac and I'm having an unexpected issue. When writing SQL on the editor (any editor), it won't take my quotes (single or double) and some other special characters... For me to type a single quote, I'm having to hold Control key and then type the single quote...
Is this a know issue? Is there a solution for this out there?
It is available for all major operating systems like Windows, Linux & Mac OS. We have to install MySQL Workbench along with the MySQL Application.
In workbench 8.0. 27 if under the SSL tab you don't see the option No, edit file $HOME/. mysql/workbench/connections. xml , look for the connection that you want to disable ssl, and find <value type="int" key="useSSL">2</value> set it to 0, that will disable ssl for that connection.
Preferences: SQL Editor: Query Editor Enabled by default. This option automatically executes the code autocomplete feature while editing SQL in the SQL editor. If disabled, you can instead use the keyboard shortcut Modifier + Space to execute the autocomplete routine.
It's a bug on 6.3.9 version for Mac. Quotes will only work if you're using "standard US keyboard layout".
But you can configure just the Workbench to use US keyboard layout, keeping others application with your native layout:
It's not the preetiest solution. But it works.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With