@immelnikoff
Изучаю БД

Почему не запускается сервер MySQL 8.0?

5c40687090146876010722.png
Антивирус отключен.
Содержимое my.ini (C:\ProgramData\MySQL\MySQL Server 8.0\my.ini):

[client]
default-character-set=cp1251
# pipe=
connect_timeout=600
mysqlx_connect_timeout=600
mysqlx_read_timeout=600
net_read_timeout = 600
# socket=MYSQL

port=3306

[mysql]
no-beep

default-character-set=cp1251

[mysqld]
connect_timeout=600
mysqlx_connect_timeout=600
mysqlx_read_timeout=600
net_read_timeout = 600
log_bin_trust_function_creators = 1

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use
# socket=mysql=MYSQL

# The TCP/IP Port the MySQL Server will listen on
port=3306

# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files/MySQL/MySQL Server 8.0/"

# Path to the database root
datadir=X:\Data

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=cp1251

#skip-character-set-client-handshake

# The default authentication plugin to be used when connecting to the server
default_authentication_plugin=caching_sha2_password

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"

# General and Slow logging.
log-output=FILE
general-log=0
general_log_file="CHD-DIR440.log"
slow-query-log=1
slow_query_log_file="CHD-DIR440-slow.log"
long_query_time=10

# Binary Logging.
# log-bin

# Error Logging.
log-error="CHD-DIR440.err"

# Server Id.
server-id=1

# Secure File Priv.
#secure-file-priv=""
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
#secure-file-priv="X:/"

max_connections=151
table_open_cache=2000
# tmp_table_size
thread_cache_size=10
myisam_max_sort_file_size=100G
# myisam_sort_buffer_size
# key_buffer_size
# read_buffer_size
# read_rnd_buffer_size
# innodb_data_home_dir=
# skip-innodb
innodb_flush_log_at_trx_commit=1
# innodb_log_buffer_size
# innodb_buffer_pool_size
innodb_log_file_size=48M
innodb_thread_concurrency=8
innodb_autoextend_increment=64
# innodb_buffer_pool_instances
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
# innodb_open_files
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=16M
max_connect_errors=100
open_files_limit=4161
sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
# plugin_load
# loose_mysqlx_port=33060
  • Вопрос задан
  • 549 просмотров
Пригласить эксперта
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Войти через центр авторизации
Похожие вопросы