Skip navigation links

MySQL Forums :: Install & Repo :: Error no. 2013 Lost connection to MySQL server during query


Advanced Search

Error no. 2013 Lost connection to MySQL server during query
Posted by: Dave Rabkin ()
Date: January 07, 2005 10:16AM

Have installed MySQL 5.0.2 on server other machines without problems but am having problems on Windows 2000 Server SP 4 (with all patches to-date).

Installation occurred without error. Using Windows Service to start MySQL. Here's the contents of My.ini:

[client]
port=3306
[mysqld]
port=3306
basedir=C:/Program Files/MySQL/MySQL Server 5.0/
datadir=C:/Program Files/MySQL/MySQL Server 5.0/Data/
default-character-set=latin1
default-storage-engine=INNODB
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=52M
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=103M
key_buffer_size=85M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=3469K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=165M
innodb_log_file_size=83M
innodb_thread_concurrency=8
skip-innodb

When I try to display the details for a table in the MySQL schema using SQLyog, I get:

Error no. 2013 Lost connection to MySQL server during query

My MySQL service is stopped after this error. I can restart the service but when I try to expand the details of the same table again, I get the same error again and the service is stopped again.

I'm I have a problem with Windows security because of Windows 2000 Service Pack 4 or is my.ini file wrong?

Options: ReplyQuote


Subject Written By Posted
Error no. 2013 Lost connection to MySQL server during query Dave Rabkin 01/07/2005 10:16AM
Re: Error no. 2013 Lost connection to MySQL server during query Mike Hillyer 01/07/2005 10:18AM
Re: Error no. 2013 Lost connection to MySQL server during query Dave Rabkin 01/07/2005 10:32AM
Re: Error no. 2013 Lost connection to MySQL server during query Allan Rofer 01/12/2005 12:39PM
Re: Error no. 2013 Lost connection to MySQL server during query Sam Nanda 02/09/2005 06:42PM
Re: Error no. 2013 Lost connection to MySQL server during query Sam Nanda 02/09/2005 06:47PM
Lost connection to MySQL server during query(2013) Madjid Ghazi 02/09/2005 07:43PM
Re: Error no. 2013 Lost connection to MySQL server during query sangeeta hindocha 03/01/2005 12:33PM
Re: Error no. 2013 Lost connection to MySQL server during query mohit saxena 02/18/2005 04:17PM
Re: Error no. 2013 Lost connection to MySQL server during query Daniel Hesse 02/22/2005 11:58AM
Re: Error no. 2013 Lost connection to MySQL server during query Chris Notdisclosed 03/17/2005 10:56PM
Re: Error no. 2013 Lost connection to MySQL server during query Chris Notdisclosed 03/20/2005 06:09PM
Re: Error no. 2013 Lost connection to MySQL server during query pontus synning 02/14/2005 02:23AM
Re: Error no. 2013 Lost connection to MySQL server during query Mike Hillyer 03/01/2005 01:35PM
Re: Error no. 2013 Lost connection to MySQL server during query with 4.0.21 too ! Benjamin Gonay 03/03/2005 02:48AM
Re: Error no. 2013 Lost connection to MySQL server during query Ricardo Creasy 03/12/2005 07:50PM
Re: Error no. 2013 Lost connection to MySQL server during query Chris Notdisclosed 03/17/2005 10:59PM
Re: Error no. 2013 Lost connection to MySQL server during query asdfasf sadfsaf 03/19/2005 01:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.