我无法从Windows中的命令行启动MySQL Server [英] I can not start the MySQL Server from command line in windows

问题描述

每当我编写命令"C:\ Program Files \ MySQL \ MySQL Server 5.0 \ bin \ mysqld"时，命令提示符都会回显如下内容:

Whenever I write the command "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" the command prompt hits back with something like this:

C:\>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld"

141110 3:12:58 [警告]无法创建测试文件C:\ Program Files \ MySQL \ MySQL Server 5.5 \ data \ Dutta.lower-test
141110 3:12:58 [警告]无法创建测试文件C:\ Program Files \ MySQL \ MySQL Server 5.5 \ data \ Dutta.lower-test
141110 3:12:58 [注意]插件"FEDERATED"已禁用.
141110 3:12:58 InnoDB:InnoDB内存堆已禁用
141110 3:12:58 InnoDB:互斥锁和rw_locks使用Windows互锁函数
141110 3:12:58 InnoDB:压缩表使用zlib 1.2.3
141110 3:12:58 InnoDB:正在初始化缓冲池，大小= 128.0M
141110 3:12:58 InnoDB:缓冲池的完成初始化
141110 3:12:58 InnoDB:文件操作中的操作系统错误号5.
InnoDB:错误表示mysqld没有对
的访问权限 InnoDB:目录.也可能是您已经创建了一个子目录
InnoDB:与数据文件同名.
InnoDB:文件名.\ ibdata1
InnoDB:文件操作调用:创建".
InnoDB:无法继续操作.

141110 3:12:58 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.5\data\Dutta.lower-test
141110 3:12:58 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.5\data\Dutta.lower-test
141110 3:12:58 [Note] Plugin 'FEDERATED' is disabled.
141110 3:12:58 InnoDB: The InnoDB memory heap is disabled
141110 3:12:58 InnoDB: Mutexes and rw_locks use Windows interlocked functions
141110 3:12:58 InnoDB: Compressed tables use zlib 1.2.3
141110 3:12:58 InnoDB: Initializing buffer pool, size = 128.0M
141110 3:12:58 InnoDB: Completed initialization of buffer pool
141110 3:12:58 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.

我只是一个初学者.可能是一个愚蠢的错误.预先抱歉！

I'm just a beginner. May be a silly mistake. Sorry in advance !!

推荐答案

以这种方式手动启动可执行文件时，当前用户的上下文和特权将生效.

The context and privileges of the current user will take affect when you manually start the executable in this way.

您要么需要确保:

1. 当前用户对所需的所有文件和目录具有正确的权限
2. 您提升了命令提示符的权限以管理员身份运行

如果已安装MySQL服务，则也可以使用net start MySQL.

If you have the MySQL service installed you can also use net start MySQL.

MySQL手册的本页包含在Windows上安装和运行MySQL服务器的有用信息.

This page of the MySQL manual contains useful information for installing and running the MySQL server on windows.

请记住，一旦启动" MySQL服务(或某项服务)，您实际上将看不到任何东西，那么您将需要使用MySQL客户端应用程序连接到服务器并进行交互.

Please remember that once you have 'started' the MySQL service (or service) you won't actually see anything, you will then need to use a MySQL client application to connect to the server and interact.

这篇关于我无法从Windows中的命令行启动MySQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！