• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:

    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Resolved Plesk SQL Server service won't start

Bosa

New Pleskian
Please help me. My Plesk SQL Server refuses to start. Initially I messed up with the "my.ini" file but now I have changed it back to:

[client]
port=8306
[PleskSQLServer]
port=8306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
character-set-server=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=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_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=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
connect_timeout=20

But yet the Plesk SQL Server keeps terminating whenever I try to start it. Please help.
 
What exactly error you see?

Please check log file located in:
C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
 
Sorry! My bad. I copied the default Plesk SQL config file from the web and "C:\\Program Files (x86)\\Parallels\\Plesk" was not my Plesk location. When I corrected it. The service started.

Thanks a lot
 
Back
Top