Windows上的MariaDB-尝试启动数据库引擎时此错误是什么? [英] MariaDB on Windows - what is this error when trying to start the database engine?

问题描述

我问这个问题是我的一个分支，而另一个SO则来自另一个MariaDB问题: Windows上的MariaDB-入门帮助吗?

I am asking this question as an offshoot myself and another SO had from this other MariaDB question: MariaDB on Windows - getting started help?

当我安装MariaDB(v5.2.4)时，打开命令窗口，导航到安装文件的文件夹，然后键入以下内容以启动数据库:

When I install MariaDB (v5.2.4), open the command window, navigate to the folder where the files are installed, and type in the following to start the database:

net启动mysql

net start mysql

我收到以下错误:

服务名称无效

the service name is invalid

我没有做任何复杂的事情，只是运行安装并尝试开始. 有什么想法吗?

I didn't do anything complex, just ran the installation and tried to get started. Any ideas?

推荐答案

该错误基本上表明安装程序未创建服务(当前未创建服务)，因此您需要自己进行安装.

The error basically tells that installer did not create the service (it currently does not create services), thus you'll need to do it yourself.

• 启动提升的命令行
• 切换到您的MariaDB安装目录(C:\ Program Files \ MariaDB 5.2.4，类似这样)
• bin \ mysqld --install

只有这样

• net启动mysql

假设端口3306上没有任何内容运行，则状态为

Assuming that there is nothing that runs on port 3306, this will stat.

A，您将完全不优化将以这种方式创建的服务器. 最好创建一个配置文件my.ini(例如，查看安装目录中的MySQL文档和.ini文件)，并在此处放入与性能相关的内容(innodb缓冲池大小等).使用配置文件，您将需要一个不同的命令行来注册服务(上面的步骤3):

Alas, the server you will create this way would not be optimized at all. It is better to create a configuration file my.ini (take a look at MySQL docs and .ini files in the installation directory for examples), and put with performance -related stuff here (innodb bufferpool size etc). With config file, you'll need a different command line to register service (step 3 above):

• bin \ mysqld-安装MySQL --defaults-file = path \ to \ my.ini

5.2.4的安装程序确实是基本的.不过，它正在被重新设计，新的将变得更好用.

Installer for 5.2.4 is basic indeed. It is being reworked though, new one is going to be better usable.

这篇关于Windows上的MariaDB-尝试启动数据库引擎时此错误是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！