To change users password, delete or add new users I have to sent queries to er table manually, and then do 'flush privileges'. Look for the MySQL Session section and increase the DBMS connection read time out value. Connection id: 319 Current database: mysql ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> I connect by local sockets, so that is not the network issue.I have tried all manner of things Tried to restore dump. In the application menu, select Edit > Preferences > SQL Editor. Title might be a bit misleading but thats where I was at trying to fix it last.You can edit the SQL Editor preferences in MySQL Workbench: You can increase your MySQL client’s timeout values if you don’t have administrator access to the MySQL server. The MySQL documentation suggests increasing the net_read_timeout or connect_timeout values on the server. If you’re an administrator for your MySQL server, try changing some values. Re-writing the queries isn’t always option so you can try the following server-side and client-side workarounds. For my purposes, I’ve found that denormalizing content into working tables can improve the read performance. If the panel is not visible, click View, Panels, and then Show Sidebar. To access the Navigator area, open an existing connection (or create a new connection) from the home screen. It also lists the schemas on the server for that connection. This should have the added benefit of making your query easier to read. The Navigator area of the sidebar contains options to manage the active MySQL connection. For more information, see Supported MySQL server versions.

To determine the version of your MySQL server instance, use the SELECT VERSION() command at the MySQL prompt. Where possible, try reducing the number of joins in a single query. After the connection is established, the MySQL client displays the version of MySQL set in the gateway, not the actual version running on your MySQL server instance. For example, instead of joining all the contents of two very large tables, try filtering out the records you don’t need. Hi can avoid the problem entirely by refining your SQL queries.

Mysql create view lost connection