Windows 上的 MariaDB - 尝试启动数据库引擎时出现此错误是什么? [英] MariaDB on Windows - what is this error when trying to start the database engine?
问题描述
我问这个问题是我自己和另一个 SO 从另一个 MariaDB 问题中得到的一个分支:MariaDB on Windows - 入门帮助?
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:
启动mysql
我收到以下错误:
服务名称无效
我没有做任何复杂的事情，只是运行安装并尝试开始.有什么想法吗?
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 FilesMariaDB 5.2.4，类似的)
- binmysqld --install
只有这样
- 网络启动mysql
假设在 3306 端口上没有运行任何东西，这将统计.
Assuming that there is nothing that runs on port 3306, this will stat.
唉，您将以这种方式创建的服务器根本不会被优化.最好创建一个配置文件 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):
- binmysqld --install MySQL --defaults-file=path omy.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屋！
