Update MySQL Workbench to Use F5 to Run Queries

8/21/2014 2:37:17 AM

If you are like me and coming from a SQL Server background, you have been clicking F5 for years to run your queries in SQL Management Studio. So when you open up MySQL Workbench, you instinctively do the same thing...But it doesn't work. So here is a simple key mapping change to make it work (like it's supposed to).

  1. Open up the MySQL Workbench menu file.
  2. C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9\data\main_menu.xml
  3. Search for the following string:
  4. com.mysql.wb.menu.query.execute_current_statementwin
  5. Update that xml section. Replace:
  6. <value type="string" key="shortcut">Modifier+Return</value>
  7. with
  8. <value type="string" key="shortcut">F5</value>
  9. Save the file, close and re-open MySQL Workbench and you should be all set.
<value type="object" struct-name="app.MenuItem" id="com.mysql.wb.menu.query.execute_current_statementwin"> 
	...
	<value type="string" key="shortcut">F5</value>
	...
</value>