Can't connect to MySQL server on 'localhost' (10055)"

[MarcoZ]

Hi,

Yesterday the 3.51 ODBC had some 100055 problems starting, only i can't figure out where this problem comes from.

Exception information:
Exception type: OdbcException
Exception message: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10055)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10055)



The MySQL settings are:
-------------------------------------------------------------
[MySQLD]
port=3306
basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\
datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
character-set-server=latin1
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=400
old_passwords=0
max_user_connections=30
thread_cache_size=4
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=30
net_retry_count=10
net_write_timeout=30
thread_concurrency=10
open_files_limit=0
[client]
port=3306

 

[IgorG]

Make sure that MySQL InnoDB pool buffer size limit is not exceeded. The following warning may be in MySQL error log C:\Parallels\Plesk\Databases\MySQL\Data\sxxxxxxx.err :

InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
120725 21:47:13InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (18363 search iterations)! Consider
InnoDB: increasing the buffer pool size.

In this case try to increase the value of innodb_buffer_pool_size parameter in MySQL configuration file %plesk_dir%\Databases\MySQL\Data\my.ini:

Default:
innodb_buffer_pool_size=512K

Increase it to:
innodb_buffer_pool_size=16M

And restart the MySQL service.

 

[MarcoZ]

Hi Igor,

Thanks for your reply only this did not fix the problem the problem was fixed with increase the maximum number of ephemeral ports.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Value Name: MaxUserPort
Value Type: DWORD
Value data: 65534
Valid Range: 5000-65534 (decimal)
Default: 0x1388 (5000 decimal)