gpt4 book ai didi

database - 无法启动 mySQL 服务器 Windows 8

转载 作者:行者123 更新时间:2023-11-29 23:56:15 26 4
gpt4 key购买 nike

我大约1年前安装了MySQL服务器,但我忘记了密码。我也不确定它是否是root。现在我需要MySQL服务器但无法做到。当我打开工作台并启动服务器时,它会说。 “假设服务器已打开”但没有任何反应。我尝试使用 init 文件来尝试密码,此后它也给了我同样的问题。我还尝试使用 mysqld cmd 命令启动服务器,但无法启动。我不明白问题是什么。请帮助我,我不太习惯 MySQL,所以请告诉我是否还有任何基本问题。

这是错误文件:

    2014-08-10 13:14:36 10216 [Note] Plugin 'FEDERATED' is disabled.
2014-08-10 13:14:36 10216 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-10 13:14:36 10216 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-08-10 13:14:36 10216 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-10 13:14:36 10216 [Note] InnoDB: Not using CPU crc32 instructions
2014-08-10 13:14:36 10216 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-08-10 13:14:36 10216 [Note] InnoDB: Completed initialization of buffer pool
2014-08-10 13:14:36 10216 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-10 13:14:40 10216 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-10 13:14:41 10216 [Note] InnoDB: Waiting for purge to start
2014-08-10 13:14:41 10216 [Note] InnoDB: 5.6.11 started; log sequence number 1625977
2014-08-10 13:14:41 10216 [ERROR] C:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: unknown variable 'explicit_defaults-file=C:\ProgramData\MySQL\MySQL Server 5.6\my.ini'
2014-08-10 13:14:41 10216 [ERROR] Aborting

2014-08-10 13:14:41 10216 [Note] Binlog end
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'partition'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_METRICS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_CMP'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'INNODB_TRX'
2014-08-10 13:14:41 10216 [Note] Shutting down plugin 'InnoDB'
2014-08-10 13:14:41 10216 [Note] InnoDB: FTS optimize thread exiting.
2014-08-10 13:14:41 10216 [Note] InnoDB: Starting shutdown...
2014-08-10 13:14:43 10216 [Note] InnoDB: Shutdown completed; log sequence number 1625987
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'BLACKHOLE'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'ARCHIVE'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'MRG_MYISAM'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'MyISAM'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'MEMORY'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'CSV'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'sha256_password'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'mysql_old_password'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'mysql_native_password'
2014-08-10 13:14:43 10216 [Note] Shutting down plugin 'binlog'
2014-08-10 13:14:43 10216 [Note] C:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Shutdown complete

my-default.ini 文件:

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

如果您需要更多信息,请告诉我

提前致谢。

最佳答案

关于database - 无法启动 mySQL 服务器 Windows 8,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/25325765/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com