MySQL Forums
Forum List  »  Install & Repo

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
January 07, 2005 10:16AM


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.