Error Code: 2013. Lost connection to MySQL server during query

New versions of MySQL WorkBench have an option to change specific timeouts.

For me it was under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600

Changed the value to 6000.

Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Case statement in MySQL
  4. how to drop partition without dropping data in MySQL?
  5. MySQL equivalent of DECODE function in Oracle
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  8. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  9. ORA-00904: invalid identifier
  10. Unknown column in ‘field list’ error on MySQL Update query
  11. Unknown column in ‘field list’ error on MySQL Update query
  12. Self Join to get employee manager name
  13. MySQL – Operand should contain 1 column(s)
  14. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  15. MySQL create table if not exists and insert record only if table was created
  16. How do I use properly CASE..WHEN in MySQL
  17. Why do we need “Relationships” between tables at all?
  18. How can I do a FULL OUTER JOIN in MySQL?
  19. MySQL query String contains
  20. What’s the difference between VARCHAR and CHAR?
  21. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  22. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  23. How to declare a variable in MySQL?
  24. MySQL Cannot Add Foreign Key Constraint
  25. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  26. How do I restore a dump file from mysqldump?
  27. How to split the name string in mysql?
  28. How do I import an SQL file using the command line in MySQL?
  29. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  30. mysql Foreign key constraint is incorrectly formed error
  31. MySQL: Invalid use of group function
  32. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  33. How can I return pivot table output in MySQL?
  34. Compare dates in MySQL
  35. MySQL “WITH” clause
  36. What is the difference between JOIN and UNION?
  37. Create a new database with MySQL Workbench
  38. MySQL Multiple Joins in one query?
  39. MySQL syntax for Join Update
  40. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  41. 1052: Column ‘id’ in field list is ambiguous
  42. 1052: Column ‘id’ in field list is ambiguous
  43. difference between primary key and unique key
  44. MySQL combine two columns into one column
  45. Simple way to calculate median with MySQL
  46. Creating a search form in PHP to search a database?
  47. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  48. Error 1046 No database Selected, how to resolve?
  49. What is it exactly a BLOB in a DBMS context
  50. MySQL Error 1264: out of range value for column
  51. Remove duplicate rows in MySQL
  52. How to SUM and SUBTRACT using SQL?
  53. The backend version is not supported to design database diagrams or tables
  54. Create mysql table directly from CSV file using the CSV Storage engine?
  55. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  56. Cast from VARCHAR to INT – MySQL
  57. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  58. How do you force mysql LIKE to be case sensitive?
  59. MySQL – UPDATE multiple rows with different values in one query
  60. Postgres Error: More than one row returned by a subquery used as an expression
  61. How to create a MySQL hierarchical recursive query?
  62. ERROR 1148: The used command is not allowed with this MySQL version
  63. Insert into a MySQL table or update if exists
  64. How to round down to nearest integer in MySQL?
  65. How do I reset a sequence in Oracle?
  66. MySQL starts with searching issue
  67. Query to convert from datetime to date mysql
  68. Is it possible to GROUP BY multiple columns using MySQL?
  69. MySQL error: key specification without a key length
  70. Best way to test if a row exists in a MySQL table
  71. Check if MySQL table exists without using “select from” syntax?
  72. mysql update column with value from another table
  73. The used SELECT statements have a different number of columns
  74. what is the difference between triggers, assertions and checks (in database)
  75. How to delete from multiple tables in MySQL?
  76. MySQL: Can’t create table (errno: 150)
  77. How to copy a row and insert in same table with a autoincrement field in MySQL?
  78. Join vs. sub-query
  79. Alternative to except in MySQL
  80. Equivalent of explode() to work with strings in MySQL
  81. How to do a batch insert in MySQL
  82. ROW_NUMBER() in MySQ
  83. Solutions for INSERT OR UPDATE on SQL Server
  84. MySQL OPTIMIZE all tables?
  85. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  86. MySQL – Get row number on select
  87. MySQL error: Unknown column in ‘where clause’
  88. How to truncate the text returned for a column in a MySQL query
  89. “select * into table” Will it work for inserting data into existing table
  90. Using union and order by clause in mysql
  91. MySQL LIKE IN()?
  92. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  93. Getting wrong relationship value in $args in wp_Query?
  94. Inserting Post Meta From SQL
  95. How to Join two tables from separate databases within WordPress
  96. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  97. How to execute mulitple statement SQL queries using $wpdb->query?
  98. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  99. Query WordPress database by registered date and role
  100. Size article thumbnails and retrieve them directly from database

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)