运行mysqld时发出

Question

我下载了mysql-5.7.9-winx64.zip，当我尝试运行mysqld时，我得到了以下错误：

E:\Softwares\mysql-5.7.9-winx64\bin>mysqld
mysqld: Could not create or access the registry key needed for the MySQL application
to log to the Windows EventLog. Run the application with sufficient
privileges once to create the key, add the key manually, or turn off
logging for that application.
mysqld: Can't change dir to 'E:\Softwares\mysql-5.7.9-winx64\data\' (Errcode: 2 - No such file or directory)
2015-11-13T10:45:09.715411Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_ti
mestamp server option (see documentation for more details).
2015-11-13T10:45:09.731411Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of
 generated files. Consider setting it to a valid, non-empty path.
2015-11-13T10:45:09.732411Z 0 [ERROR] Cannot open Windows EventLog; check privileges, or start server with --log_syslog=0
2015-11-13T10:45:09.732411Z 0 [Note] mysqld (mysqld 5.7.9) starting as process 3532 ...
2015-11-13T10:45:09.864419Z 0 [Warning] Can't create test file E:\Softwares\mysql-5.7.9-winx64\data\yous-PC.lower-test
2015-11-13T10:45:09.864419Z 0 [Warning] Can't create test file E:\Softwares\mysql-5.7.9-winx64\data\yous-PC.lower-test
2015-11-13T10:45:09.864419Z 0 [ERROR] failed to set datadir to E:\Softwares\mysql-5.7.9-winx64\data\
2015-11-13T10:45:09.865419Z 0 [ERROR] Aborting

2015-11-13T10:45:09.865419Z 0 [Note] Binlog end
2015-11-13T10:45:09.945424Z 0 [Note] mysqld: Shutdown complete

Answer 1

尝试MySQL安装程序5.7.9自动安装它- mysql- Installer -web-community-5.7.9.0.msi，它可以工作。

Answer 2

必须以管理员身份运行命令提示符。那就运行mysqld。

为此，右键单击命令提示符启动图标，然后选择。然后运行mysqld，您就不会再看到该错误。

mysqld需要第一次访问您的注册表。你不必在第一次之后再这样做。

Answer 3

出于开发/调试的目的，我需要一个没有安装的MySQL-Server，并且不希望它更改我的windows安装，例如通过设置注册表项。MySQL的提示"start server with -log_syslog=0“运行良好：

mysqld -u root --log_syslog=0