Applicable to:
- Plesk for Windows
Symptoms
- Plesk is not accessible:
PLESK_INFO: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.
Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key & #039 ;translate& #039 ; (Abstract.php:144) - "bind-address" parameter value in
%plesk_dir%MySQL\my.inidiffers from the 127.0.0.1:CONFIG_TEXT: bind-address=203.0.113.2
Cause
Incorrect IP address binding in Plesk SQL Server configuration. Therefore, Plesk fails to connect to SQL Server service on address 127.0.0.1.
Resolution
Note: if you don't have administrative access to Plesk server via RDP, contact your hosting provider regarding the issue
Login to the server over RDP and remove "bind-address" directive from %plesk_dir%MySQL\my.ini.
Comments
2 comments
Hello
I have the same error but there is no in mysql file
[client]
port=8306
[PleskSQLServer]
port=8306
basedir=E:\\Program Files (x86)\\Plesk\\MySQL
datadir=E:\\Program Files (x86)\\Plesk\\MySQL\\Data
character-set-server=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_open_cache=32
tmp_table_size=7M
thread_cache_size=32
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
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=300
max_allowed_packet=1M
net_buffer_length=4K
old_passwords=0
tmpdir=E:\\Program Files (x86)\\Plesk\\MySQL\\Data
connect_timeout=20
@quachdinhhop
I suggest contacting regular Plesk support to look closer at this issue - https://support.plesk.com/hc/en-us/requests/new
Please sign in to leave a comment.