MySQL неожиданно завершил свою работу #155

Antwar · 2025-09-03T03:58:48Z

Antwar
Sep 3, 2025

Столкнулся с такой проблемой, что при запуске модуля MySQL-8.4, либо версий ниже, либо другого модуля (MariaDB-11.2) для захода в phpmyadmin, в логах выбивает ошибку

Настройки config.inc.php:

Попытка входа в phpmyadmin с пользователем root:

Есть идеи, где нужно что-то проверить?

OSPanel · 2025-09-06T18:35:36Z

OSPanel
Sep 6, 2025
Maintainer

Смотрите лог модуля, здесь вы его не показали. В 90% случаев это связано с неподготовленной системой (см. команду консоли osp sysprep).

3 replies

Antwar Sep 9, 2025
Author

Вот лог MySQL-8.4 после запуска:

-----------------------------------------------------------------------------
[2025-09-09 18:57:00] Running MySQL-8.4 (default)
-----------------------------------------------------------------------------
2025-09-09T14:57:00.897566+01:00 0 [Note] [MY-013667] [Server] Error-log destination "stderr" is not a file. Can not restore error log messages from previous run.
2025-09-09T14:57:00.772093+01:00 0 [Note] [MY-013847] [Server] Using jemalloc.dll for my_malloc and ut::malloc etc.
2025-09-09T14:57:00.772310+01:00 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-09-09T14:57:00.894624+01:00 0 [Note] [MY-010949] [Server] Basedir set to D:\OSPanel635\modules\MySQL-8.4\.
2025-09-09T14:57:00.894632+01:00 0 [System] [MY-010116] [Server] D:\OSPanel635\modules\MySQL-8.4\bin\mysqld.exe (mysqld 8.4.4) starting as process 7076
2025-09-09T14:57:00.899347+01:00 0 [Note] [MY-012366] [InnoDB] Using Windows native AIO
2025-09-09T14:57:00.899485+01:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2025-09-09T14:57:00.899549+01:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2025-09-09T14:57:00.899565+01:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2025-09-09T14:57:00.899573+01:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2025-09-09T14:57:00.901104+01:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-09-09T14:57:00.901126+01:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2025-09-09T14:57:00.901554+01:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2025-09-09T14:57:00.901572+01:00 1 [Note] [MY-012945] [InnoDB] _mm_lfence() and _mm_sfence() are used for memory barrier
2025-09-09T14:57:00.901581+01:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1
2025-09-09T14:57:00.902670+01:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2025-09-09T14:57:00.903095+01:00 1 [Note] [MY-012203] [InnoDB] Directories to scan '.\'
2025-09-09T14:57:00.903223+01:00 1 [Note] [MY-012204] [InnoDB] Scanning '.\'
2025-09-09T14:57:00.930345+01:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files.
2025-09-09T14:57:00.930980+01:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 256.000000M, instances = 1, chunk size =128.000000M 
2025-09-09T14:57:00.937464+01:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2025-09-09T14:57:00.940961+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_0.dblwr' for doublewrite
2025-09-09T14:57:01.033460+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_1.dblwr' for doublewrite
2025-09-09T14:57:01.156545+01:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2025-09-09T14:57:01.156583+01:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128
2025-09-09T14:57:01.156719+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_0.dblwr' for doublewrite
2025-09-09T14:57:01.156849+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_1.dblwr' for doublewrite
2025-09-09T14:57:01.197051+01:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 25148663 in redo log file .\#innodb_redo\#ib_redo7.
2025-09-09T14:57:01.205176+01:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 25148519, whereas checkpoint_lsn = 25148663 and start_lsn = 25148416
2025-09-09T14:57:01.243650+01:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2025-09-09T14:57:01.244298+01:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2025-09-09T14:57:01.244328+01:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2025-09-09T14:57:01.244843+01:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace '.\undo_001'.
2025-09-09T14:57:01.247542+01:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace '.\undo_002'.
2025-09-09T14:57:01.252877+01:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2025-09-09T14:57:01.252936+01:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5132
2025-09-09T14:57:03.292215+01:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2025-09-09T14:57:03.292253+01:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 2039 ms.
2025-09-09T14:57:03.292360+01:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2025-09-09T14:57:03.292492+01:00 1 [Note] [MY-012265] [InnoDB] Setting file 'D:\OSPanel635\data\MySQL-8.4\default\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-09-09T14:57:03.585096+01:00 1 [Note] [MY-012266] [InnoDB] File 'D:\OSPanel635\data\MySQL-8.4\default\ibtmp1' size is now 12 MB.
2025-09-09T14:57:03.816247+01:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'.\#innodb_temp\'
2025-09-09T14:57:04.903748+01:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2025-09-09T14:57:04.912491+01:00 1 [Note] [MY-012976] [InnoDB] 8.4.4 started; log sequence number 25148673
2025-09-09T14:57:04.922313+01:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-09-09T14:57:04.963538+01:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80300'.
2025-09-09T14:57:05.101013+01:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2025-09-09T14:57:05.102659+01:00 1 [Note] [MY-012356] [InnoDB] Scanned 6 tablespaces. Validated 6.
2025-09-09T14:57:05.180329+01:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80300'.
2025-09-09T14:57:05.186974+01:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '127.127.126.32' port: 33060'
2025-09-09T14:57:05.251624+01:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2025-09-09T14:57:05.254179+01:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2025-09-09T14:57:05.254493+01:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2025-09-09T14:57:05.254858+01:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from D:\OSPanel635\data\MySQL-8.4\default\ib_buffer_pool
2025-09-09T14:57:05.255729+01:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 250909 18:57:05
2025-09-09T14:57:05.265067+01:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2025-09-09T14:57:05.399620+01:00 0 [Note] [MY-010303] [Server] Skipping generation of SSL certificates as options related to SSL are specified.
2025-09-09T14:57:05.749807+01:00 0 [Warning] [MY-010068] [Server] CA certificate D:/OSPanel635/data/ssl/cacert.pem is self signed.
2025-09-09T14:57:05.749853+01:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-09-09T14:57:05.750190+01:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2025-09-09T14:57:05.750448+01:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2025-09-09T14:57:05.753113+01:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '127.127.126.32'; port: 3306
2025-09-09T14:57:05.753136+01:00 0 [Note] [MY-010264] [Server]   - '127.127.126.32' resolves to '127.127.126.32';
2025-09-09T14:57:05.753171+01:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '127.127.126.32'.
2025-09-09T14:57:05.753367+01:00 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Сделана попытка доступа к сокету методом, запрещенным правами доступа.
 
2025-09-09T14:57:05.753382+01:00 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2025-09-09T14:57:05.753397+01:00 0 [ERROR] [MY-010119] [Server] Aborting
2025-09-09T14:57:05.764959+01:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2025-09-09T14:57:06.390435+01:00 0 [Note] [MY-010120] [Server] Binlog end
2025-09-09T14:57:06.390744+01:00 0 [Note] [MY-015019] [Server] MySQL Server: Plugins Shutdown - start.
2025-09-09T14:57:06.390767+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2025-09-09T14:57:06.390781+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2025-09-09T14:57:06.391260+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2025-09-09T14:57:06.391281+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2025-09-09T14:57:06.391291+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2025-09-09T14:57:06.391308+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2025-09-09T14:57:06.391319+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2025-09-09T14:57:06.391330+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-09-09T14:57:06.391371+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2025-09-09T14:57:06.391385+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2025-09-09T14:57:06.391402+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2025-09-09T14:57:06.391412+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2025-09-09T14:57:06.391420+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2025-09-09T14:57:06.391430+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2025-09-09T14:57:06.391438+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2025-09-09T14:57:06.391446+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2025-09-09T14:57:06.391458+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2025-09-09T14:57:06.391466+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2025-09-09T14:57:06.391475+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2025-09-09T14:57:06.391483+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2025-09-09T14:57:06.391491+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2025-09-09T14:57:06.391500+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2025-09-09T14:57:06.391508+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2025-09-09T14:57:06.391518+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2025-09-09T14:57:06.391526+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2025-09-09T14:57:06.391535+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2025-09-09T14:57:06.391544+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2025-09-09T14:57:06.391552+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2025-09-09T14:57:06.391561+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2025-09-09T14:57:06.391569+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2025-09-09T14:57:06.391577+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-09-09T14:57:06.391585+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2025-09-09T14:57:06.391594+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2025-09-09T14:57:06.391602+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2025-09-09T14:57:06.391611+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2025-09-09T14:57:06.391619+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2025-09-09T14:57:06.391627+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2025-09-09T14:57:06.391664+01:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2025-09-09T14:57:06.391817+01:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to D:\OSPanel635\data\MySQL-8.4\default\ib_buffer_pool
2025-09-09T14:57:06.392457+01:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 250909 18:57:06
2025-09-09T14:57:06.546013+01:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2025-09-09T14:57:06.809798+01:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 835584
2025-09-09T14:57:06.809949+01:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 25194322
2025-09-09T14:57:06.810315+01:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2025-09-09T14:57:06.810364+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2025-09-09T14:57:06.810389+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2025-09-09T14:57:06.810409+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2025-09-09T14:57:06.810432+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2025-09-09T14:57:06.810445+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2025-09-09T14:57:06.810464+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2025-09-09T14:57:06.810654+01:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2025-09-09T14:57:06.810671+01:00 0 [Note] [MY-015020] [Server] MySQL Server: Plugins Shutdown - end.
2025-09-09T14:57:06.812186+01:00 0 [Note] [MY-015021] [Server] MySQL Server: Components Shutdown - start.
2025-09-09T14:57:06.812473+01:00 0 [Note] [MY-015022] [Server] MySQL Server: Components Shutdown - end (with return value = 0).
2025-09-09T14:57:06.812648+01:00 0 [System] [MY-010910] [Server] D:\OSPanel635\modules\MySQL-8.4\bin\mysqld.exe: Shutdown complete (mysqld 8.4.4)  MySQL Community Server - GPL.
2025-09-09T14:57:06.812661+01:00 0 [System] [MY-015016] [Server] MySQL Server - end.

При попытке добавить в папку pma.local (каталог для phpmyadmin) в консоли пишет, что этот модуль выключен, и всё также иконка osp горит красным

OSPanel Sep 9, 2025
Maintainer

В логе всё написано. У вас либо на этой паре ip:порт уже что-то запущено, либо, что скорее всего, доступ к 127.127.126.32:3306 закрыт файрволом, либо антивирусом с такой функцией.

2025-09-09T14:57:05.753367+01:00 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Сделана попытка доступа к сокету методом, запрещенным правами доступа.
 
2025-09-09T14:57:05.753382+01:00 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?

Antwar Sep 9, 2025
Author

Благодарю за помощь, был процесс, занявший этот порт 🙏

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

MySQL неожиданно завершил свою работу #155

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 3 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Uh oh!

MySQL неожиданно завершил свою работу #155

Uh oh!

Antwar Sep 3, 2025

Replies: 1 comment · 3 replies

Uh oh!

OSPanel Sep 6, 2025 Maintainer

Uh oh!

Antwar Sep 9, 2025 Author

Uh oh!

Uh oh!

OSPanel Sep 9, 2025 Maintainer

Uh oh!

Antwar Sep 9, 2025 Author

Antwar
Sep 3, 2025

Replies: 1 comment 3 replies

OSPanel
Sep 6, 2025
Maintainer

Antwar Sep 9, 2025
Author

OSPanel Sep 9, 2025
Maintainer

Antwar Sep 9, 2025
Author