Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Some keys not working properly on MySQL Workbench for Mac

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?

like image 841
maiona Avatar asked Mar 24 '17 21:03

maiona


People also ask

Does MySQL Workbench work with Mac?

It is available for all major operating systems like Windows, Linux & Mac OS. We have to install MySQL Workbench along with the MySQL Application.

How do I disable SSL requirement in MySQL Workbench?

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.

How do I enable autocomplete in MySQL Workbench?

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.


1 Answers

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:

  • Go to System Preferences > Keyboard > Input Sources
  • Enable booth keyboard layouts (yours and the US)
  • Check "Show Input Menu Bar" and "Automatically switch to a document's input source"
  • Then with the MySQLWorkbench app active, change your keyboar to US using the icon in Mac's menu bar

It's not the preetiest solution. But it works.

like image 81
Bivis Avatar answered Nov 09 '22 23:11

Bivis