CMD run the following command:
NET stop < service name >
NET start < service name >
Note:< service name > usually defaults to: MySQL
That
net stop MySQL
net start MySQL
Note:
How to view service names:
On the desktop-> right-click "Computer"-> choose "Management"-> choose "Service and Application"-> "service": in the service to find the name and MySQL corresponding, under normal circumstances should be the MySQL Server service name. such as Mysql56 and so on.
To turn the service off and on, normally require CMD to be "Open as Administrator"
Under Windows system, when configuring directory locations for MySQL My.ini Log-bin, assume that you want to configure Log-bin log to mysqllog files in D disk as Binlog. You can configure the following:
[Mysqld]
log-bin= "D:mysqllog/binlog" Note: The last path here takes the "/" instead of the Windows file system ""