MySQL service started last night under Windows

To compile the source files of the connector/c++ library, you need to prepare the following tools: MySQL database (compile-time dependent), CMake (Generate SLN project file), connector/c++ source Files, visual Stdio 2003 versions above. Examples use VS2010. One, MySQL database installation: 1. Install Windows First, it is recommended to go to inside robes ' download install version. The zip version is actually the same as the install. But the zip version is mostly. Download Link: http://dev.mysql.com/downloads/windows/installer/There is a select Platform: option, but FQ to choose.　　2. Add the environment variable to the bin directory under the MySQL installation directory. 1.mysql directory My-default.ini for reference, modify the My.ini file. The following is a reference:

[Client]password     123456 Port         3306 Socket         =/tmp/mysql.sock[mysqld]basedir5.6datadir5.6/datalog  5.6/log/mysql.logport        3306socket    =/tmp/mysql.sock

2. Console (cmd) input:

Mysqld--install MySQL--defaults-file="C:\Program files\mysql\mysql Server 5.6\my.ini"

3. Start the service:

net start MySQL//net start MySQL may prompt for a 1067 error, which is a configuration error. Sometimes it appears, sometimes not. According to the online advice, no white rule

net start MYSQL only needs to start execution for the first time. After power-on, the service will start automatically. can go to

PS: Close and Delete Service commands:

net stop MYSQLSC Delete MySQL

Instructions for starting the attached inside robes ':

User Comments

Posted by Paolo Lancelli on October 2:56pm

[Delete] [Edit]

In the box you receive "The system cannot find the file specified", remember so you have to install the service with the AB Solute path, in my case "C:\mysql\bin\mysqld--install". I added the \ bin to the Windows path, and I were installing the service only with "Mysqld--install".

Posted by Junaid Nazir on December 9:14pm

[Delete] [Edit]

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's located under ' C:\mysql\bin '. I was working under the assumption, 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 would load the My.ini configuration file which you had to P Lace within the MySQL directory. For the first time however, you'll 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 4:16am

[Delete] [Edit]

If you have problems installing the service on Windows Vista, just run the normal install and add the service manually wit H 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 5:49pm

[Delete] [Edit]

Another "Got-ya" ... Make sure your My.ini file was in your MySQL directory, and the variables was pointing to the correct directories.

Posted by Rich Wingerter on July 5 3:09am

[Delete] [Edit]

In order to overcome the "the system cannot find the file specified" message, I had to use the short 8dot3 names because M Y command program would the long names in quotes. Since i has 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

MySQL service started last night under Windows