• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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