从字面上看，当我启动；mysql"；服务器，它没有分配端口(我知道，因为在端口列的xampp中的mysql行中什么都没有(，当我试图在phpMyAdmin中或通过我的网站甚至我的数据库vscode扩展(如mysql工作台(访问它时，它只是说它拒绝连接。。。检查mysql日志，只有一些警告：
2022-01-05T21:49:30.875196Z 0 [Warning] [MY-010915] [Server] '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-05T21:49:30.875199Z 0 [System] [MY-010116] [Server] C:xamppmysqlbinmysqld.exe (mysqld 8.0.27) starting as process 6076
2022-01-05T21:49:30.950201Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-01-05T21:49:34.263390Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-01-05T21:49:36.583523Z 0 [Warning] [MY-011311] [Server] Plugin mysqlx reported: 'All I/O interfaces are disabled, X Protocol won't be accessible'
2022-01-05T21:49:37.927602Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-01-05T21:49:37.928600Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-01-05T21:49:37.933600Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-05T21:49:37.933601Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-01-05T21:49:38.112611Z 0 [System] [MY-010931] [Server] C:xamppmysqlbinmysqld.exe: ready for connections. Version: '8.0.27' socket: '' port: 0 MySQL Community Server - GPL.
2022-01-05T21:49:48.764220Z 0 [System] [MY-013105] [Server] C:xamppmysqlbinmysqld.exe: Normal shutdown.
2022-01-05T21:49:50.652328Z 0 [System] [MY-010910] [Server] C:xamppmysqlbinmysqld.exe: Shutdown complete (mysqld 8.0.27) MySQL Community Server - GPL.
我正在使用Windows7，如果这很重要的话，我不在我的主电脑上(度假时(。我已经尝试修复xampp问题1.5天了，所以非常感谢您的帮助。另外我已经安装了mysql扩展插件或其他什么，因为默认的mysql实际上是MariaDB，我认为这就是我的查询不起作用的原因，所以我遵循堆栈溢出awnser来安装正确的mysql(我使用的是mysqld-init(EDIT：忘了提phpMyAdmin说设置无效，尽管我确信它们是正确的(我也试过了我能找到的一切(。
我想通了！这是我安装的mysql扩展/插件。我重新安装了xamplep，并决定要处理mariaDB。