T1Longlive 2022-01-18 18:45 采纳率: 85.7%
浏览 1112
已结题

安装MySQL时在lnitializing database出错。

win11安装MySQL时在lnitializing database出错(如图)。注:计算机名和计算机组名一直是英文。

img


img

报错那里log的全部内容如下:

Beginning configuration step: Writing configuration file

Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL57 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
确定。

Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules

Beginning configuration step: Adjusting Windows service

Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service

Beginning configuration step: Initializing database (may take a long time)

Deleting the data directory from a previous (failed) configuration...
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 5.7.24...
Starting process with command: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
2022-01-18T10:26:19.242557Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-01-18T10:26:19.244397Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-01-18T10:26:19.470926Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-01-18T10:26:19.521031Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-01-18T10:26:19.601678Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1374cbef-7849-11ec-9a12-3c7c3f5adbb5.
2022-01-18T10:26:19.605526Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-01-18T10:26:19.607921Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2022-01-18 18:26:22 0x41f8 InnoDB: Assertion failure in thread 16888 in file dict0dict.cc line 2636
InnoDB: Failing assertion: !dict_index_is_clust(index) || UT_LIST_GET_LEN(table->indexes) == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com/.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
10:26:22 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=65536
max_used_connections=0
max_threads=151
thread_count=1
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)max_threads = 58351 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x26a777c86f0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
7ff648642112 mysqld.exe!my_errno()
7ff9eccaec9d MSVCR120.dll!raise()
7ff9eccb4874 MSVCR120.dll!abort()
7ff64875e4d4 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff64871fb93 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff64871fb44 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6487dd452 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6486890ff mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff648689e30 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff648688f03 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff648155f5c mysqld.exe!?create_innodb_tmp_table@@YA_NPEAUTABLE@@PEAUst_key@@@Z()
7ff648159475 mysqld.exe!?instantiate_tmp_table@@YA_NPEAUTABLE@@PEAUst_key@@PEAUst_columndef@@PEAPEAU3@_KDPEAVOpt_trace_context@@@Z()
7ff648158a26 mysqld.exe!?create_tmp_table@@YAPEAUTABLE@@PEAVTHD@@PEAVTemp_table_param@@AEAV?$List@VItem@@@@PEAUst_order@@_N4_K5PEBD@Z()
7ff647f5d32e mysqld.exe!?create_schema_table@@YAPEAUTABLE@@PEAVTHD@@PEAUTABLE_LIST@@@Z()
7ff647f6a4e2 mysqld.exe!?mysql_schema_table@@YAHPEAVTHD@@PEAULEX@@PEAUTABLE_LIST@@@Z()
7ff647fca118 mysqld.exe!?open_and_lock_tables@@YA_NPEAVTHD@@PEAUTABLE_LIST@@IPEAVPrelocking_strategy@@@Z()
7ff647fcbfa1 mysqld.exe!?open_tables@@YA_NPEAVTHD@@PEAPEAUTABLE_LIST@@PEAIIPEAVPrelocking_strategy@@@Z()
7ff647fcc34e mysqld.exe!?open_tables_for_query@@YA_NPEAVTHD@@PEAUTABLE_LIST@@I@Z()
7ff64811113d mysqld.exe!?mysql_create_view@@YA_NPEAVTHD@@PEAUTABLE_LIST@@W4enum_view_create_mode@@@Z()
7ff647f2ad60 mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff647f2b978 mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff647ffb4b1 mysqld.exe!?fatal_error@THD@@QEAAXXZ()
7ff647ffbbc6 mysqld.exe!handle_bootstrap()
7ff648930e62 mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff648641f7c mysqld.exe!my_thread_once()
7ff9ecc64f6b MSVCR120.dll!_beginthreadex()
7ff9ecc65098 MSVCR120.dll!_endthreadex()
7ffa1eab1350 KERNEL32.DLL!BaseThreadInitThunk()
7ffa1ffb1e78 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (26a777cb7e0): CREATE OR REPLACE ALGORITHM = TEMPTABLE DEFINER = 'mysql.sys'@'localhost' SQL SECURITY INVOKER VIEW schema_object_overview ( db, object_type, count ) AS SELECT ROUTINE_SCHEMA AS db, ROUTINE_TYPE AS object_type, COUNT() AS count FROM information_schema.routines GROUP BY ROUTINE_SCHEMA, ROUTINE_TYPE UNION SELECT TABLE_SCHEMA, TABLE_TYPE, COUNT() FROM information_schema.tables GROUP BY TABLE_SCHEMA, TABLE_TYPE UNION SELECT TABLE_SCHEMA, CONCAT('INDEX (', INDEX_TYPE, ')'), COUNT() FROM information_schema.statistics GROUP BY TABLE_SCHEMA, INDEX_TYPE UNION SELECT TRIGGER_SCHEMA, 'TRIGGER', COUNT() FROM information_schema.triggers GROUP BY TRIGGER_SCHEMA UNION SELECT EVENT_SCHEMA, 'EVENT', COUNT() FROM information_schema.events GROUP BY EVENT_SCHEMA ORDER BY DB, OBJECT_TYPE;
Connection ID (thread ID): 1
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Process for mysqld, with ID 6500, was run successfully and exited with code -2147483645.
Failed to start process for MySQL Server 5.7.24.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)


  • 写回答

4条回答 默认 最新

  • ndgj 2022-01-18 19:08
    关注

    Authentication Method页面的 第二个按钮选了吗?必选第二个,Use Legacy 开头的。如果没选者这个重新选下

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

问题事件

  • 系统已结题 1月28日
  • 已采纳回答 1月20日
  • 创建了问题 1月18日

悬赏问题

  • ¥20 机器学习能否像多层线性模型一样处理嵌套数据
  • ¥20 西门子S7-Graph,S7-300,梯形图
  • ¥50 用易语言http 访问不了网页
  • ¥50 safari浏览器fetch提交数据后数据丢失问题
  • ¥15 matlab不知道怎么改,求解答!!
  • ¥15 永磁直线电机的电流环pi调不出来
  • ¥15 用stata实现聚类的代码
  • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效