C 访问MySql 接口封装_MySql C++调用库Connector/c++编译 和 接口封装【一】mysql数据库安装...

net start MySQL 　　//net start MySQL 可能会提示 1067错误，就是配置错误。有时会出现，有时没有。按网上的建议，没弄没白规律

net start MySql 只需要第一次启动执行。以后开机后，会自动启动服务。可以去

ps：关闭并删除服务命令：

net stop MySQL

sc delete MySQL

附官服的启动说明：

User Comments

Posted by Paolo Lancelli on October 24 2007 2:56pm

In case you receive "The system cannot find the file specified", remember that you have to install the service with the absolute path, in my case "C:\mysql\bin\mysqld --install". I added the \bin to the windows path, and I was installing the service only with "mysqld --install".

Posted by Junaid Nazir on December 29 2007 9:14pm

As mentioned earlier by another user, I fell into the trap of adding MySQL to start as a service via a command like

C:\> mysqld --install

The service is reported as being installed successfully, however, under the Services panel it shows the executable path as 'C:\mysqld' when in fact it is located under 'C:\mysql\bin'. I was working under the assumption that the mysql\bin directory had been added to the system PATH variable, but really you need to use absolute file paths when installing services. In my case, I used;

C:\> C:\mysql\bin\mysqld --install MySQL --defaults-file=C:\mysql\my.ini

This starts the service automatically with Windows bootup, and will load the my.ini configuration file which you have to place within the mysql directory. For the first time however, you will need to start the mysql service manually, since the earlier command makes mysql start and end with windows shutdowns and restarts.

net start mysql

Posted by bob eff on June 8 2008 4:16am

If you have problems installing the service on Windows Vista, just run the normal install and add the service manually with the following command:

use the sc create command in a dos window to add the service:

sc create MySQL start= auto DisplayName= MySQL binPath= c:\program files\mysql\mysql server 5.1\bin\mysqld.exe

then if you need to alter any parameters, use the administrative tools/services utility

Posted by Baruch Atta on January 14 2010 5:49pm

Another "got-ya"... Make sure your my.ini file is in your MySQL directory, and the variables are pointing to the correct directories.

Posted by Rich Wingerter on July 5 2011 3:09am

In order to overcome the "The system cannot find the file specified" message, I had to use the short 8dot3 names because my command program would not take the long names in quotes. Since I have mysql installed under EasyPHP on the D: drive, I had to use:

D:\progra~2\easyph~1.0\mysql\bin\mysqld --install

to get to mysqld in

D:\Program Files (x86)\EasyPHP-5.3.6.0\mysql\bin

You can get the short names with the directory command:

DIR /X