• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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

MarcoZ

Basic Pleskian
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
 
Last edited:
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.
 
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)
 
Back
Top