1)
Hide the “Results” pane is there . 'edit' menu or Ctrl+2
2)
User configurable keyboard shortcuts is a very old request. It has always been 'next to second' in priority and still is.
3)
It is the server that inserts the values for “DEFINER” if not explicitly defined by user. Simply try (from any client):
Code:
CREATE PROCEDURE `test`.`pr1`() SELECT 1;
SHOW CREATE PROCEDURE `test`.`pr1`;
.. what returns (note: DEFINER added and formatting changed):
Code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `pr1`()
SELECT 1
When you are working from the editor SQLyog only sends to MySQL what you have typed. The server requires a DEFINER and will add current user as DEFINER in the CREATE statement if none was specified.
If I did not understand one or more points please detail.