MySQL启动不作为服务 [英] MySQL start not as service

问题描述

在配置MySQL方面有点新。我的问题是，我们需要在已将MySQL作为Service安装的计算机上运行MySQL。我们没有root权限。由于MySQL服务对于在计算机上运行的应用程序很重要，因此我们不能仅仅删除/重新安装它。也许该应用程序将再次使用。因此，我尝试安装xampp并尝试不作为服务启动MySQL，但这似乎是不可能的。

im a little bit new with configuring MySQL. My problem is that we need to run MySQL on a computer where MySQL is already installed as Service. We dont have the access to root. Since the MySQL Service is important for an application which is running on the computer we cant just remove/reinstall it. Maybe the application will be used again. So i tried to install xampp and try to start the MySQL not as service but it seems to be impossible.

是否可以不以Service启动MySQL？每当我启动XAMPP控制面板时，就会出现以下内容：

Is it possible to start the MySQL not as Service? The following appears whenever i start the XAMPP Control Panel:

[mysql]     MySQL Service detected with wrong path
[mysql]     Change XAMPP MySQL and Control Panel settings or
[mysql]     Uninstall/disable the other service manually first
[mysql]     Found Path: "C:\private\private\bin\mysqld-nt" --defaults-file="C:\private\private\my.ini" MySQL
[mysql]     Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql

所以我一直试图禁用该服务，然后手动启动

So i have been trying to disable the Service and then manually start

mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini

此过程随后运行，并且我在控制台中得到以下内容：

Afterwards the process is running, and i get the following in the console:

C:\xampp\mysql\bin>mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini
2015-02-11 10:52:53 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-02-11 10:52:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

然后我无法连接到mysql：
C：\xampp\mysql\ bin>

Then i cant connect to mysql: C:\xampp\mysql\bin>

mysql -u root
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

Btw im如果使用Windows 8 64bit的话。

Btw im using Windows 8 64bit if that matters.

另一个问题：root密码与服务中的密码相同吗？我的意思是MySQL和MySQL Service安装在不同的目录中。

Another Question: Does the root password stay the same as in the service? I mean MySQL and MySQL Service is installed in a different directory.

推荐答案

老实说，我现在真的很蠢。

to be honest i feel really stupid now.

将ini值从key_buffer修改为key_buffer_size是可行的。它不应该说警告...

Editing the ini value from key_buffer to key_buffer_size worked. It shouldnt say Warning ...

这篇关于MySQL启动不作为服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！