Ошибка запуска MySQL в OSPanel
Переустановил Windows 10, ставлю OSPanel, возникает ошибка:
2020-05-08 14:00:07 --------------------------------------------
2020-05-08 14:00:07 Начало процедуры запуска сервера
2020-05-08 14:00:07 Обновление Hosts файла
2020-05-08 14:00:07 Обновление конфигурации MariaDB-10.3-x64
2020-05-08 14:00:07 Обновление конфигурации Sendmail
2020-05-08 14:00:07 Обновление конфигурации PHP_7.1-x64
2020-05-08 14:00:07 Обновление конфигурации PHPMyAdmin
2020-05-08 14:00:07 Обновление конфигурации Apache_2.4-PHP_7.0-7.1-x64
2020-05-08 14:00:07 Запуск MariaDB-10.3-x64
2020-05-08 14:00:07 Запуск Apache_2.4-PHP_7.0-7.1-x64
2020-05-08 14:00:07 Проверка состояния сервера
2020-05-08 14:00:45 Не удалось запустить MariaDB-10.3-x64
2020-05-08 14:00:45 Сбой запуска!
2020-05-08 14:00:45 --------------------------------------------
2020-05-08 14:00:45 Начало процедуры остановки сервера
2020-05-08 14:00:45 Остановка системных модулей
2020-05-08 14:00:45 Отключение виртуального диска
2020-05-08 14:00:45 Сервер успешно остановлен за 0,422 секунд!
И код лога MySQL:
1)В режиме отладки:
c:\users\sanya\downloads\ospanel\modules\database\MariaDB-10.3-x64>"c:\users\sanya\downloads\ospanel\modules\database\MariaDB-10.3-x64\bin\mysqld.exe" --defaults-file="c:\users\sanya\downloads\ospanel\modules\database\MariaDB-10.3-x64\my.ini" --user=root --standalone --console
error: Found option without preceding group in config file: c:\users\sanya\downloads\ospanel\modules\database\MariaDB-10.3-x64\my.ini at line: 1
Fatal error in defaults handling. Program aborted
2)Лог:
error: Found option without preceding group in config file: c:\users\sanya\downloads\ospanel\modules\database\MariaDB-10.3-x64\my.ini at line: 1
Fatal error in defaults handling. Program aborted
Сам файл:
#
# ВНИМАНИЕ! Это временный файл, его редактирование бессмысленно!
#
[client]
port = 3306
character_sets_dir = "c:\\users\\sanya\\downloads\\ospanel\\modules\\database\\MariaDB-10.3-x64\\share\\charsets"
[mysql]
no-auto-rehash
no-beep
character_sets_dir = "c:\\users\\sanya\\downloads\\ospanel\\modules\\database\\MariaDB-10.3-x64\\share\\charsets"
[mysqld]
# Required Settings
basedir = "c:\\users\\sanya\\downloads\\ospanel\\modules\\database\\MariaDB-10.3-x64"
bind-address = 127.0.0.1
character_sets_dir = "c:\\users\\sanya\\downloads\\ospanel\\modules\\database\\MariaDB-10.3-x64\\share\\charsets"
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
datadir = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\MariaDB-10.3-x64"
default_storage_engine = InnoDB
explicit_defaults_for_timestamp = 1
ft_min_word_len = 3
local_infile = 0
lower_case_table_names = 1
max_allowed_packet = 256M
pid_file = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\temp\\mysql.pid"
port = 3306
secure-file-priv = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\php_upload"
#skip_name_resolve = 1
ssl = 0
tmpdir = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\temp"
# Buffer Settings
bulk_insert_buffer_size = 8M
join_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
sort_buffer_size = 2M
# Cache Settings
query_cache_limit = 256K
query_cache_size = 32M
query_cache_type = 1
# Connection Settings
max_connections = 64
max_connect_errors = 32
back_log = 512
thread_cache_size = 8
interactive_timeout = 180
wait_timeout = 180
# InnoDB Settings
innodb_adaptive_hash_index = 0
innodb_buffer_pool_instances = 1
innodb_buffer_pool_size = 128M
innodb_data_file_path = ibdata1:10M:autoextend
innodb_data_home_dir = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\MariaDB-10.3-x64"
innodb_file_per_table = 1
#innodb_force_recovery = 1
innodb_log_file_size = 64M
innodb_read_io_threads = 8
#innodb_thread_concurrency = 4
innodb_write_io_threads = 8
# Logging
#general_log = 1
#general_log_file = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\logs\\MariaDB-10.3-x64_queries.log"
log_error = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\logs\\MariaDB-10.3-x64_error.log"
log_bin = 0
#log_queries_not_using_indexes = 1
#long_query_time = 5
#slow_query_log = 1
#slow_query_log_file = "c:\\users\\sanya\\downloads\\ospanel\\userdata\\logs\\MariaDB-10.3-x64_slow.log"
# MyISAM Settings
key_buffer_size = 32M
myisam_max_sort_file_size = 256M
myisam_recover_options = backup,force
# Table Settings
table_definition_cache = 10000
table_open_cache = 10000
open_files_limit = 60000
max_heap_table_size = 128M
tmp_table_size = 128M
[mysqldump]
quick
quote_names
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
open_files_limit = 60000