[client]
password =
port =
socket = /tmp/mysql.sock [mysqld]
basedir=C:/Program Files/MySQL/MySQL Server 5.6
datadir=C:/Program Files/MySQL/MySQL Server 5.6/data
log-error=C:/Program Files/MySQL/MySQL Server 5.6/log/mysql.log
port =
socket = /tmp/mysql.sock
mysqld --install MySQL --defaults-file="C:\Program Files\MySQL\MySQL Server 5.6\my.ini"
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 | [Delete] [Edit] |
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 | [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 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 | [Delete] [Edit] |
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 | [Delete] [Edit] |
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 | [Delete] [Edit] |
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