ospanel drupal 11 mysql SQLSTATE[HY000] [2002]

Главные вкладки

Аватар пользователя riaron986 riaron986 4 августа в 6:02

в опенсервере mysql выдает следующую ошибку
Сообщение об ошибке
Устраните все ошибки ниже чтобы продолжить установку. Для получения справки по настройке сервера базы данных см. руководство по установке, или свяжитесь с вашим хостинг-провайдером.
Не удалось подключиться к серверу базы данных. Сервер сообщает следующее сообщение: SQLSTATE[HY000] [2002] Подключение не установлено, т.к. конечный компьютер отверг запрос на подключение [Tip: This message normally means that there is no MySQL server running on the system or that you are using an incorrect host name or port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.] .
Сервер базы данных работает?
Существует ли база данных или у пользователя базы данных достаточно прав для ее создания?
Вы ввели правильное имя базы данных?
Вы ввели правильное имя пользователя и пароль?
Вы ввели правильное имя хоста базы данных и номер порта?
как исправить?
вот логи mysql
-----------------------------------------------------------------------------
[2025-08-04 13:39:41] Running MySQL-8.4 (default)
-----------------------------------------------------------------------------
2025-08-04T11:39:41.792586+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-08-04T11:39:41.543948+01:00 0 [Note] [MY-013847] [Server] Using jemalloc.dll for my_malloc and ut::malloc etc.
2025-08-04T11:39:41.546622+01:00 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-08-04T11:39:41.732604+01:00 0 [Note] [MY-010949] [Server] Basedir set to C:\OSPanel\modules\MySQL-8.4\.
2025-08-04T11:39:41.733049+01:00 0 [System] [MY-010116] [Server] C:\OSPanel\modules\MySQL-8.4\bin\mysqld.exe (mysqld 8.4.4) starting as process 2632
2025-08-04T11:39:41.810713+01:00 0 [Note] [MY-012366] [InnoDB] Using Windows native AIO
2025-08-04T11:39:41.817317+01:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2025-08-04T11:39:41.818675+01:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2025-08-04T11:39:41.818731+01:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2025-08-04T11:39:41.818755+01:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2025-08-04T11:39:41.844506+01:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-08-04T11:39:41.844884+01:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2025-08-04T11:39:41.847379+01:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2025-08-04T11:39:41.847788+01:00 1 [Note] [MY-012945] [InnoDB] _mm_lfence() and _mm_sfence() are used for memory barrier
2025-08-04T11:39:41.847813+01:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1
2025-08-04T11:39:41.859903+01:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2025-08-04T11:39:41.863711+01:00 1 [Note] [MY-012203] [InnoDB] Directories to scan '.\'
2025-08-04T11:39:41.865823+01:00 1 [Note] [MY-012204] [InnoDB] Scanning '.\'
2025-08-04T11:39:41.913265+01:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 4 files.
2025-08-04T11:39:41.915676+01:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 256.000000M, instances = 1, chunk size =128.000000M
2025-08-04T11:39:41.930841+01:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2025-08-04T11:39:41.941830+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_0.dblwr' for doublewrite
2025-08-04T11:39:41.978053+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_1.dblwr' for doublewrite
2025-08-04T11:39:42.006724+01:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2025-08-04T11:39:42.006789+01:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128
2025-08-04T11:39:42.007626+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_0.dblwr' for doublewrite
2025-08-04T11:39:42.007919+01:00 1 [Note] [MY-013532] [InnoDB] Using '.\#ib_16384_1.dblwr' for doublewrite
2025-08-04T11:39:42.121335+01:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 25199437 in redo log file .\#innodb_redo\#ib_redo7.
2025-08-04T11:39:42.124876+01:00 1 [Note] [MY-012560] [InnoDB] The log sequence number 25057447 in the system tablespace does not match the log sequence number 25199437 in the redo log files!
2025-08-04T11:39:42.124973+01:00 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2025-08-04T11:39:42.124998+01:00 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2025-08-04T11:39:42.371959+01:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 25199135, whereas checkpoint_lsn = 25199437 and start_lsn = 25199104
2025-08-04T11:39:42.372028+01:00 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 25199437
2025-08-04T11:39:42.382923+01:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2025-08-04T11:39:42.393155+01:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2025-08-04T11:39:42.393297+01:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2025-08-04T11:39:42.501027+01:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace '.\undo_001'.
2025-08-04T11:39:42.506491+01:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace '.\undo_002'.
2025-08-04T11:39:42.521757+01:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2025-08-04T11:39:42.522572+01:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5647
2025-08-04T11:39:42.730060+01:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2025-08-04T11:39:42.731687+01:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 209 ms.
2025-08-04T11:39:42.734297+01:00 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2025-08-04T11:39:42.734388+01:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2025-08-04T11:39:42.735368+01:00 1 [Note] [MY-012265] [InnoDB] Setting file 'C:\OSPanel\data\MySQL-8.4\default\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-08-04T11:39:42.753143+01:00 1 [Note] [MY-012266] [InnoDB] File 'C:\OSPanel\data\MySQL-8.4\default\ibtmp1' size is now 12 MB.
2025-08-04T11:39:42.781694+01:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'.\#innodb_temp\'
2025-08-04T11:39:42.909796+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-08-04T11:39:42.949215+01:00 1 [Note] [MY-012976] [InnoDB] 8.4.4 started; log sequence number 25199447
2025-08-04T11:39:42.952152+01:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-08-04T11:39:43.035228+01:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80300'.
2025-08-04T11:39:43.303408+01:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2025-08-04T11:39:43.308522+01:00 1 [Note] [MY-012356] [InnoDB] Scanned 6 tablespaces. Validated 6.
2025-08-04T11:39:43.344151+01:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80300'.
2025-08-04T11:39:43.385259+01:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '127.127.126.32' port: 33060'
2025-08-04T11:39:43.453373+01:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2025-08-04T11:39:43.459543+01:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2025-08-04T11:39:43.459982+01:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2025-08-04T11:39:43.460557+01:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from C:\OSPanel\data\MySQL-8.4\default\ib_buffer_pool
2025-08-04T11:39:43.462446+01:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 250804 13:39:43
2025-08-04T11:39:43.473046+01:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
2025-08-04T11:39:43.588183+01:00 0 [Note] [MY-010303] [Server] Skipping generation of SSL certificates as options related to SSL are specified.
2025-08-04T11:39:44.734079+01:00 0 [Warning] [MY-010068] [Server] CA certificate C:/OSPanel/data/ssl/cacert.pem is self signed.
2025-08-04T11:39:44.734206+01:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-08-04T11:39:44.735243+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-08-04T11:39:44.735890+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-08-04T11:39:44.757100+01:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '127.127.126.32'; port: 3306
2025-08-04T11:39:44.757186+01:00 0 [Note] [MY-010264] [Server] - '127.127.126.32' resolves to '127.127.126.32';
2025-08-04T11:39:44.757281+01:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '127.127.126.32'.
2025-08-04T11:39:44.832939+01:00 0 [Note] [MY-011025] [Repl] Failed to start replica threads for channel ''.
2025-08-04T11:39:44.838882+01:00 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5
2025-08-04T11:39:44.839258+01:00 0 [Note] [MY-011241] [Server] Plugin mysqlx reported: 'Using SSL configuration from Mysqlx Plugin'
2025-08-04T11:39:45.267840+01:00 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2025-08-04T11:39:45.268338+01:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.127.126.32' port: 33060
2025-08-04T11:39:45.268745+01:00 0 [System] [MY-010931] [Server] C:\OSPanel\modules\MySQL-8.4\bin\mysqld.exe: ready for connections. Version: '8.4.4' socket: '' port: 3306 MySQL Community Server - GPL.

Комментарии

Аватар пользователя pselfin pselfin 7 августа в 23:19

Сервер базы данных работает?
Существует ли база данных или у пользователя базы данных достаточно прав для ее создания?
Вы ввели правильное имя базы данных?
Вы ввели правильное имя пользователя и пароль?
Вы ввели правильное имя хоста базы данных и номер порта?