entityMap|0|type|LINK|mutability|MUTABLE|data|url|http://bytes.com/topic/mysql/answers/884724-facing-error-starting-stopping-mysql-service-command-line-mode|blocks|key|2vgfi|text|net+stop+MySQL*|code-block|depth|inlineStyleRanges|entityRanges|syntax|js|2ncit|或者|unstyled|e7lg7|mysqld+stop|dp4f5|bm67n|mysql+stop|19qpa|在窗口的命令行提示符中。|blfle|<*>如果您使用的是windows+XP，则需要您的服务的名称，您可以通过执行以下操作获得该名称：(credits@Atli)|offset|length|12atg|右键单击“开始”菜单中的“我的电脑”快捷方式，选择“管理”，在“服务和应用程序”组中单击“服务”。然后搜索服务列表，直到找到MySQL服务。|ddkea|然后你就可以开始或停止使用该名称创建服务。它有时可以被称为"mysql5“或"mysql51"，或者类似的东西。取决于是谁安装的。^0|0|0|0|0|0|0|1L|5|0|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|12|G|@]|H|@]|6|$I|J]]|$A|K|C|L|2|M|F|13|G|@]|H|@]|6|$]]|$A|N|C|O|2|E|F|14|G|@]|H|@]|6|$I|J]]|$A|P|C|L|2|M|F|15|G|@]|H|@]|6|$]]|$A|Q|C|R|2|E|F|16|G|@]|H|@]|6|$I|J]]|$A|S|C|T|2|M|F|17|G|@]|H|@]|6|$]]|$A|U|C|V|2|M|F|18|G|@]|H|@$W|19|X|1A|A|1B]]|6|$]]|$A|Y|C|Z|2|M|F|1C|G|@]|H|@]|6|$]]|$A|10|C|11|2|M|F|1D|G|@]|H|@]|6|$]]]]

<pre><code>net stop MySQL*
</code></pre>

or 

<pre><code>mysqld stop
</code></pre>

or 

<pre><code>mysql stop
</code></pre>

in the window's command line prompt.

&lt;*> if you're using windows XP, you need the name of your service, which can be obtained doing this: (credits <a href="http://bytes.com/topic/mysql/answers/884724-facing-error-starting-stopping-mysql-service-command-line-mode" rel="nofollow">@Atli</a>)

<blockquote>
 right click the "My Computer" shortcut in the Start menu, select
 "Manage", click "Services" in the "Services and applications" group.
 And then search the list of services until you find the MySQL service.
 
 Then you can start [or stop] the service by using that name. It is can sometimes
 be called "mysql5" or "mysql51", or something like that. Depends on
 who installed it.
</blockquote>

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/1b5a35f379c41465216367652724d01f.png|imageAlt|blocks|key|2ej6s|text|您可以在services.msc中将其启动类型设置为手动。这样，除非需要，否则它不会自动启动。只需从services.msc获取服务的名称，如下所示：|unstyled|depth|inlineStyleRanges|entityRanges|ag1g2|​|a37pm|?|atomic|offset|length|790pj|dbk9h|您也可以创建批处理文件来轻松地启动和停止服务。现在在批处理文件中使用此名称。|57q9q|您的start.bat：|6phuh|net+start+"mysql"|code-block|syntax|js|ec4qi|在你的stop.bat中：|127og|net+stop+"mysql"^0|0|0|0|1|0|0|0|0|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|14|H|@]|I|@]|6|$]]|$B|J|D|K|2|F|G|15|H|@]|I|@]|6|$]]|$B|L|D|M|2|N|G|16|H|@]|I|@$O|17|P|18|B|19]]|6|$]]|$B|Q|D|K|2|F|G|1A|H|@]|I|@]|6|$]]|$B|R|D|S|2|F|G|1B|H|@]|I|@]|6|$]]|$B|T|D|U|2|F|G|1C|H|@]|I|@]|6|$]]|$B|V|D|W|2|X|G|1D|H|@]|I|@]|6|$Y|Z]]|$B|10|D|11|2|F|G|1E|H|@]|I|@]|6|$]]|$B|12|D|13|2|X|G|1F|H|@]|I|@]|6|$Y|Z]]]]

You can set its startup type to manual in services.msc. This way it will not start automatically unless required. Simply get the name of the service from services.msc as shown here:

<img src="https://i.stack.imgur.com/F4VoG.png" alt="enter image description here">

You can create batch files to start and stop the service fairly easily as well. Now use this name in batch files.

Your start.bat:

<pre><code>net start "mysql"
</code></pre>

And in your stop.bat:

<pre><code>net stop "mysql"
</code></pre>

entityMap|blocks|key|3kjg1|text|对于Windows，有几个技巧需要注意……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|f1dj8|(假设您已经从Oracle的站点安装了MySQL，但可能选择了在启动时不运行该服务)……|dla3d|要在WinVista/Win7的命令行中使用"mysqld+stop“，您必须右键单击Start+->+All+Programs+->+Accessories+->+->+Prompt+->+Run+As+Administrator|ordered-list-item|6djv9|现在您已经拥有了本地操作系统管理员访问权限，您可以使用"mysqld+stop“(它将简单地返回)|dasf7|如果您看到以下信息，则表示您正在使用没有正确权限的用户/命令提示符尝试IT：|d47bb|121228+11:54:50+[Warning]+Can't+create+test+file+c:\Program+Files\MySQL\MySQL+Server+5.5\data\hpdv7.lower-test
121228+11:54:50+[Warning]+Can't+create+test+file+c:\Program+Files\MySQL\MySQL+Server+5.5\data\hpdv7.lower-test
121228+11:54:50+[Note]+Plugin+'FEDERATED'+is+disabled.
121228+11:54:50+InnoDB:+The+InnoDB+memory+heap+is+disabled
121228+11:54:50+InnoDB:+Mutexes+and+rw_locks+use+Windows+interlocked+functions
121228+11:54:50+InnoDB:+Compressed+tables+use+zlib+1.2.3
121228+11:54:50+InnoDB:+Initializing+buffer+pool,+size+=+128.0M
121228+11:54:50+InnoDB:+Completed+initialization+of+buffer+pool
121228+11:54:50++InnoDB:+Operating+system+error+number+5+in+a+file+operation.
InnoDB:+The+error+means+mysqld+does+not+have+the+access+rights+to
InnoDB:+the+directory.+It+may+also+be+you+have+created+a+subdirectory
InnoDB:+of+the+same+name+as+a+data+file.
InnoDB:+File+name+.\ibdata1
InnoDB:+File+operation+call:+'create'.
InnoDB:+Cannot+continue+operation.|code-block|syntax|javascript|4389n|如果mysqld不是已知的系统命令，请尝试将其添加到类路径中|bqh4|右键单击我的电脑|1gc9r|高级系统设置|a577r|环境变量|dbqi2|系统变量|7k1r0|查找并单击鼠标左键选择名为path的变量|2n1no|单击“编辑”并将字符串复制到记事本，并在末尾附加到您的MySQL+bin目录的完整路径，例如|8iuq9|%25SystemRoot%25\system32;%25SystemRoot%25;%25SystemRoot%25\System32\Wbem;c:\Program文件\MySQL\MySQL+Server5.5\bin^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|16|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|17|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|18|9|@]|A|@]|B|$]]|$2|H|4|I|6|G|8|19|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|1A|9|@]|A|@]|B|$]]|$2|L|4|M|6|N|8|1B|9|@]|A|@]|B|$O|P]]|$2|Q|4|R|6|7|8|1C|9|@]|A|@]|B|$]]|$2|S|4|T|6|G|8|1D|9|@]|A|@]|B|$]]|$2|U|4|V|6|G|8|1E|9|@]|A|@]|B|$]]|$2|W|4|X|6|G|8|1F|9|@]|A|@]|B|$]]|$2|Y|4|Z|6|G|8|1G|9|@]|A|@]|B|$]]|$2|10|4|11|6|G|8|1H|9|@]|A|@]|B|$]]|$2|12|4|13|6|G|8|1I|9|@]|A|@]|B|$]]|$2|14|4|15|6|7|8|1J|9|@]|A|@]|B|$]]]]

For Windows there's a couple of tricks to take care of...

(Assuming you've installed MySQL from Oracle's site but maybe have chosen not to run the service at startup)...

<ol>
<li>To use "mysqld stop" from the command line for WinVista/Win7 you must right click on Start -> All Programs -> Accessories -> Command Prompt -> Run As Administrator</li>
<li>Now that you have local OS admin access you can use "mysqld stop" (which will simply return)</li>
</ol>

IF YOU SEE THE FOLLOWING YOU ARE TRYING IT WITH A USER/COMMAND PROMPT THAT DOES NOT HAVE THE CORRECT PRIVILEGES:

<pre><code>121228 11:54:50 [Warning] Can't create test file c:\Program Files\MySQL\MySQL Server 5.5\data\hpdv7.lower-test
121228 11:54:50 [Warning] Can't create test file c:\Program Files\MySQL\MySQL Server 5.5\data\hpdv7.lower-test
121228 11:54:50 [Note] Plugin 'FEDERATED' is disabled.
121228 11:54:50 InnoDB: The InnoDB memory heap is disabled
121228 11:54:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121228 11:54:50 InnoDB: Compressed tables use zlib 1.2.3
121228 11:54:50 InnoDB: Initializing buffer pool, size = 128.0M
121228 11:54:50 InnoDB: Completed initialization of buffer pool
121228 11:54:50 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
</code></pre>

If mysqld does not appear as a known system command, try adding it to your class path

<ol>
<li>Right click on My Computer</li>
<li>Advanced System Settings</li>
<li>Environment Variables</li>
<li>System variables</li>
<li>look for and left click select the variable named path</li>
<li>click on "Edit" and copy out the string to notepad and append at the end the full path to your MySQL bin directory , e.g.

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;c:\Program Files\MySQL\MySQL Server 5.5\bin</li>
</ol>

entityMap|blocks|key|bf27v|text|在Windows上|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c8hb1|如果使用的是windows，请打开命令提示符，然后键入|2uimp|停止MySQL服务|6p93f|net+stop+MySQL|code-block|syntax|js|5cmbq|启动MySQL服务|6plg3|net+start+MySQL.|enmgi|在Linux上|cnjr9|展开%7C选择%7C换行%7C行号|4cvs1|#+/etc/init.d/mysqld+start
#+/etc/init.d/mysqld+stop
#+/etc/init.d/mysqld+restart|javascript|9tkkm|Fedora+/+Red+Hat也支持这一点：|2hhm|Expand%7CSelect%7CWrap%7CLine+Numbers
+#+service+mysqld+start
+#+service+mysqld+stop
+#+service+mysqld+restart|92h0t|我知道这个答案来得太晚了，但我希望它能对某些人有所帮助。^0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|12|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|13|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|14|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|15|9|@]|A|@]|B|$J|K]]|$2|L|4|M|6|7|8|16|9|@]|A|@]|B|$]]|$2|N|4|O|6|I|8|17|9|@]|A|@]|B|$J|K]]|$2|P|4|Q|6|7|8|18|9|@]|A|@]|B|$]]|$2|R|4|S|6|7|8|19|9|@]|A|@]|B|$]]|$2|T|4|U|6|I|8|1A|9|@]|A|@]|B|$J|V]]|$2|W|4|X|6|7|8|1B|9|@]|A|@]|B|$]]|$2|Y|4|Z|6|I|8|1C|9|@]|A|@]|B|$J|V]]|$2|10|4|11|6|7|8|1D|9|@]|A|@]|B|$]]]]

On Windows
If you are using Windows Open the Command Prompt and type
To Stop MySQL Service:
<pre><code>net stop MySQL80 
</code></pre>
To Start MySQL Service:
<pre><code>net start MySQL80
</code></pre>
On Linux
<pre><code># /etc/init.d/mysqld start
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld restart
</code></pre>
Fedora / Red Hat also support this:
<pre><code># service mysqld start
# service mysqld stop
# service mysqld restart
</code></pre>
Also Systemd based distrubutions (like Ubuntu or Arch Linux) support this:
<pre><code># systemctl start mysql
# systemctl stop mysql
# systemctl restart mysql
</code></pre>
I know this answer is late but i hope it helps for some one.

entityMap|blocks|key|bspjr|text|我用的是XP。我手动安装了MySQL-5.6.10，地址是.zip，没有MySQL站点提供的Windows自动安装程序。The+The+The/bin我的MySQL的目录在我的路径中。所以我用以下命令启动服务器mysqld+--console命令，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|beuhi|C:\Documents+and+Settings\User>mysqld+--console
2013-04-12+14:39:19+0+[Warning]+TIMESTAMP+with+implicit+DEFAULT+value+is+deprecated.+Please+use+--explicit_defaults_for_times
tamp+server+option+(see+documentation+for+more+details).|code-block|syntax|javascript|c9f1v|从现在开始运行。并且该cmd窗口被占用。我打开并使用另一个。|19j9a|我已经尝试使用上面的答案，但它们都不能停止服务器。只抛出错误。因此，我使用以下命令停止服务器mysqladmin+-u+root+shutdown在另一个cmd窗口上或使用|24cnj|Ctrl+%2B+C在它正在运行的cmd窗口上。后者的效果不如前者，有时我不得不点击Ctrl+%2B+C两次或更多。|68jhs|关机过程的日志如下：|sgvq|2013-04-12+17:55:29+3968+[Note]+Giving+0+client+threads+a+chance+to+die+gracefully
2013-04-12+17:55:29+3968+[Note]+Event+Scheduler:+Purging+the+queue.+0+events
2013-04-12+17:55:29+3968+[Note]+Shutting+down+slave+threads
2013-04-12+17:55:29+3968+[Note]+Forcefully+disconnecting+0+remaining+clients
2013-04-12+17:55:29+3968+[Note]+Binlog+end
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'partition'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'PERFORMANCE_SCHEMA'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_DATAFILES'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_TABLESPACES'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_FOREIGN_COLS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_FOREIGN'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_FIELDS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_COLUMNS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_INDEXES'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_TABLESTATS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_SYS_TABLES'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_INDEX_TABLE'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_INDEX_CACHE'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_CONFIG'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_BEING_DELETED'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_DELETED'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_INSERTED'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_FT_DEFAULT_STOPWORD'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_METRICS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_BUFFER_POOL_STATS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_BUFFER_PAGE_LRU'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_BUFFER_PAGE'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_CMP_PER_INDEX_RESET'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_CMP_PER_INDEX'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_CMPMEM_RESET'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_CMPMEM'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_CMP_RESET'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_CMP'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_LOCK_WAITS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_LOCKS'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'INNODB_TRX'
2013-04-12+17:55:29+3968+[Note]+Shutting+down+plugin+'InnoDB'
2013-04-12+17:55:29+3968+[Note]+InnoDB:+FTS+optimize+thread+exiting.
2013-04-12+17:55:29+3968+[Note]+InnoDB:+Starting+shutdown...
2013-04-12+17:55:30+3968+[Note]+InnoDB:+Shutdown+completed;+log+sequence+number+1719777
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'BLACKHOLE'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'ARCHIVE'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'MRG_MYISAM'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'MyISAM'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'MEMORY'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'CSV'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'sha256_password'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'mysql_old_password'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'mysql_native_password'
2013-04-12+17:55:30+3968+[Note]+Shutting+down+plugin+'binlog'
2013-04-12+17:55:30+3968+[Note]+mysqld:+Shutdown+complete|fcpuh|我仍然不知道这是否是100%25关闭服务器的正确方法，但它是有效的:)^0|T|4|1Z|4|2X|G|0|0|0|1A|R|0|0|8|14|8|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|X|9|@$A|Y|B|Z|C|D]|$A|10|B|11|C|D]|$A|12|B|13|C|D]]|E|@]|F|$]]|$2|G|4|H|6|I|8|14|9|@]|E|@]|F|$J|K]]|$2|L|4|M|6|7|8|15|9|@]|E|@]|F|$]]|$2|N|4|O|6|7|8|16|9|@$A|17|B|18|C|D]]|E|@]|F|$]]|$2|P|4|Q|6|7|8|19|9|@$A|1A|B|1B|C|D]|$A|1C|B|1D|C|D]]|E|@]|F|$]]|$2|R|4|S|6|7|8|1E|9|@]|E|@]|F|$]]|$2|T|4|U|6|I|8|1F|9|@]|E|@]|F|$J|K]]|$2|V|4|W|6|7|8|1G|9|@]|E|@]|F|$]]]]

I'm on XP. I've installed MySQL-5.6.10 manually from <code>.zip</code>, no Windows auto-installer provided by MySQL site. The <code>/bin</code> directory of my MySQL is in my PATH. So I start the server with <code>mysqld --console</code> command, like this:

<pre><code>C:\Documents and Settings\User&gt;mysqld --console
2013-04-12 14:39:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_times
tamp server option (see documentation for more details).
</code></pre>

From now on it is running. And that cmd window is occupied. I open and use another one.

I've tried to use the answers from above but none of them can stop the server. Only errors are throw. So I stop the server with <code>mysqladmin -u root shutdown</code> on the other cmd window or with <code>Ctrl + C</code> on the cmd window it is running in. The latter works not so good as the former, sometimes I have to click <code>Ctrl + C</code> twice or more.

The log of the shutdown process is like this:

<pre><code>2013-04-12 17:55:29 3968 [Note] Giving 0 client threads a chance to die gracefully
2013-04-12 17:55:29 3968 [Note] Event Scheduler: Purging the queue. 0 events
2013-04-12 17:55:29 3968 [Note] Shutting down slave threads
2013-04-12 17:55:29 3968 [Note] Forcefully disconnecting 0 remaining clients
2013-04-12 17:55:29 3968 [Note] Binlog end
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'partition'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_INSERTED'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_METRICS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_CMP'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'INNODB_TRX'
2013-04-12 17:55:29 3968 [Note] Shutting down plugin 'InnoDB'
2013-04-12 17:55:29 3968 [Note] InnoDB: FTS optimize thread exiting.
2013-04-12 17:55:29 3968 [Note] InnoDB: Starting shutdown...
2013-04-12 17:55:30 3968 [Note] InnoDB: Shutdown completed; log sequence number 1719777
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'BLACKHOLE'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'ARCHIVE'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'MRG_MYISAM'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'MyISAM'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'MEMORY'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'CSV'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'sha256_password'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'mysql_old_password'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'mysql_native_password'
2013-04-12 17:55:30 3968 [Note] Shutting down plugin 'binlog'
2013-04-12 17:55:30 3968 [Note] mysqld: Shutdown complete
</code></pre>

And I still don't know if it is 100% right way to shutdown the server, but it works :)

entityMap|blocks|key|aou27|text|为Windows7关闭mySQL服务器的简单方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9qvu8|我的电脑>管理>服务和应用程序>服务>选择"MySQL+56“|2n74m|(名称取决于安装的MySQL版本。)在左上角有三个选项。停止服务暂停服务重新启动服务|a6rbh|选择Stop+the+service+>停止服务器|4grui|再次开始，您可以转到相同的位置，或者我们可以选择mySQL图形用户界面上的工具选项|adeug|服务器>启动/关闭>选择启动或关闭|as3tu|PS:有时，即使提供了相应的选项，也无法从GUI停止服务器。这就是提供上述替代方法的原因。|6q478|共享ans。去改进。谢谢^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|Q|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|R|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|S|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|T|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|U|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|V|9|@]|A|@]|B|$]]|$2|M|4|N|6|7|8|W|9|@]|A|@]|B|$]]|$2|O|4|P|6|7|8|X|9|@]|A|@]|B|$]]]]

Easy way to shutdown mySQL server for Windows7 :

My Computer > Manage > Services and Application > Services > select "MySQL 56"(the name depends upon the version of MySQL installed.)
three options are present at left top corner. 
Stop the Service
pause the Service 
Restart the Service

choose Stop the service > to stop the server

Again to start you can come to the same location or we can chose tools options on mySQL GUI
Server > Startup/Shutdown > Choose to Startup or Shutdown

PS: some times it is not possible to stop the server from the GUI even though the options are provided. so is the reason the above alternative method is provided. 

share the ans. to improve. 
thanks

entityMap|blocks|key|9dige|text|要停止服务，请执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|586ak|sc+stop+mysql56|offset|length|style|CODE|fursk|要启动它，请执行以下操作：|43hf8|sc+start+mysql56|dqh5e|您可能需要更改mysql56无论你的版本是什么。^0|0|0|F|0|0|0|G|0|7|7^^$0|$]|1|@$2|3|4|5|6|7|8|O|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|P|9|@$E|Q|F|R|G|H]]|A|@]|B|$]]|$2|I|4|J|6|7|8|S|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|T|9|@$E|U|F|V|G|H]]|A|@]|B|$]]|$2|M|4|N|6|7|8|W|9|@$E|X|F|Y|G|H]]|A|@]|B|$]]]]

to stop the service:

<code>sc stop mysql56</code>

and to start it:

<code>sc start mysql56</code>

you might need to change the <code>mysql56</code> to whatever your version is.

entityMap|blocks|key|dvkie|text|投票最多的答案已过期。我刚刚安装了MySQL+5.7，服务名称现在是MySQL57所以新命令是net+stop+MySQL57|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data^0|Y|7|1B|G^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@$A|H|B|I|C|D]|$A|J|B|K|C|D]]|E|@]|F|$]]]]

The Top Voted Answer is out of date. I just installed MySQL 5.7 and the service name is now <code>MySQL57</code> so the new command is 

<code>net stop MySQL57</code>

entityMap|blocks|key|9park|text|只需键入exit|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2ceam|和u不在windows的cmd中的mysql中。^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|E|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|F|9|@]|A|@]|B|$]]]]

just type exit

and u are out of mysql in cmd in windows

entityMap|blocks|key|4r3cl|text|如果您运行的是windows，请尝试执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8lkrm|单击键盘上的开始按钮|ordered-list-item|2r0uh|类型任务管理器|4h0b5|打开任务管理器时，右键单击，然后单击以管理员身份运行|db7ft|单击服务，然后查找MySQL，然后单击|6n989|右键单击它，然后单击停止，然后关闭任务管理器，您就完成了。|kj3d|要在您想要使用它时启动它，请按照相同的步骤操作，并单击这次的启动^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|P|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|Q|9|@]|A|@]|B|$]]|$2|F|4|G|6|E|8|R|9|@]|A|@]|B|$]]|$2|H|4|I|6|E|8|S|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|T|9|@]|A|@]|B|$]]|$2|L|4|M|6|E|8|U|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|V|9|@]|A|@]|B|$]]]]

If you are running windows try this:

<ol>
<li>click start button on a keyboard </li>
<li>type task manager</li>
<li>right click and click run as administrator 
when the task manager opens </li>
<li>click on services then look for MySQL then</li>
<li>right click on it then click stop
then close task manager and you are done.</li>
</ol>

to start it when you wand to use it, follow the same steps and click start this time

entityMap|blocks|key|br9r3|text|如果是MySQL+57。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|a2hgn|net+start+MySQL57|code-block|syntax|js|c48hp|或者|e760b|net+stop+MySQL57^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|O|9|@]|A|@]|B|$F|G]]]]

If MySQL 57.

<pre><code>net start MySQL57
</code></pre>

OR 

<pre><code>net stop MySQL57
</code></pre>

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/fc9ccaa89bfa504f1e88b0f856c9c54a.png|imageAlt|blocks|key|9klfe|text|以管理员身份启动Powershell并运行：|unstyled|depth|inlineStyleRanges|entityRanges|dl8t|net+start+[MySQL-service-name]|code-block|syntax|js|10ed4|查找服务名称：|dc030|运行'services.msc'，查找MySQL并单击属性|c91n1|?|atomic|offset|length|7vev3|​^0|0|0|0|0|0|1|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|Z|H|@]|I|@]|6|$]]|$B|J|D|K|2|L|G|10|H|@]|I|@]|6|$M|N]]|$B|O|D|P|2|F|G|11|H|@]|I|@]|6|$]]|$B|Q|D|R|2|F|G|12|H|@]|I|@]|6|$]]|$B|S|D|T|2|U|G|13|H|@]|I|@$V|14|W|15|B|16]]|6|$]]|$B|X|D|Y|2|F|G|17|H|@]|I|@]|6|$]]]]

Start Powershell as administrator and run:

<pre><code>net start [MySQL-service-name]
</code></pre>

Find the service name: 

run 'services.msc', look for MySQL and click on properties

<a href="https://i.stack.imgur.com/mriCz.png" rel="noreferrer"><img src="https://i.stack.imgur.com/mriCz.png" alt="enter image description here"></a>

entityMap|blocks|key|5k3uu|text|我也遇到了同样的问题，下面是我的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6jh33|转到service.msc，找到mysql服务。将其设置为手动启动。|ordered-list-item|6sc6d|转到任务管理器-进程选项卡，找到mysqld。停下来|abbme|转到任务管理器-服务选项卡找到mysql服务并停止它。^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|K|9|@]|A|@]|B|$]]|$2|F|4|G|6|E|8|L|9|@]|A|@]|B|$]]|$2|H|4|I|6|E|8|M|9|@]|A|@]|B|$]]]]

I got the same problem and here my solution:

<ol>
<li>go to service.msc and find mysql service. set it as start manually.</li>
<li>go to task manager - processes tab and find mysqld. stop it </li>
<li>go to task manager - services tab find mysql service and stop it </li>
</ol>

entityMap|blocks|key|8ojc7|text|在windows+10上|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8kfd7|如果你想关闭它，打开命令提示符与管理工作。写NET+STOP+MySQL80..。完成了。如果你想再开一次，你必须写NET+START+MySQL80|offset|length|style|CODE|fabks|如果您不希望它在不使用时自动打开，它会在计算机打开时自动运行，并消耗一些内存。|6r955|打开services.msc查找Mysql80，查看属性并根据需要再次启动类型manuel或otomaticly。^0|0|M|G|1M|H|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|N|9|@$E|O|F|P|G|H]|$E|Q|F|R|G|H]]|A|@]|B|$]]|$2|I|4|J|6|7|8|S|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|T|9|@]|A|@]|B|$]]]]

On windows 10 

If you wanna close it open command prompt with work with admin. Write <code>NET STOP MySQL80</code>. Its done. If you wanna open again so you must write <code>NET START MySQL80</code> 

If you do not want it to be turned on automatically when not in use, it automatically runs when the computer is turned on and consumes some ram.

Open services.msc find Mysql80 , look at properties and turn start type manuel or otomaticly again as you wish.

entityMap|blocks|key|od0a|text|在Windows上成功停止MySQL服务|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2kdk3|检查服务MySQL的服务名称|4drj0|以管理员身份运行：net+stop+[MySQL+Service+name]|offset|length|style|CODE^0|0|0|9|T^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|L|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|M|9|@$G|N|H|O|I|J]]|A|@]|B|$]]]]

To successfully stop MySQL Service on Windows 

<ol>
<li>Check on services the name of the service for MySQL</li>
<li>Run as administrator : <code>net stop [MySQL Service name]</code></li>
</ol>

entityMap|blocks|key|1gj5c|text|这是一个更新、更简单的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c0pig|以管理员身份运行cmd|ordered-list-item|197i3|输入"net+start+mysql“然后输入版本号，在我的例子中，MySQL+8.0的版本号是"net+start+MySQL”。|3qbin|如果它说它已经运行得很好，否则现在mysql正在运行。|7dlp9|退出cmd，输入sql，向下滚动，直到找到正确版本的my+WIN%2BR。|f3rq2|右键单击属性，在启动类型下选择‘手动’，然后在服务状态下选择‘停止’|4dat7|现在您停止了mysql服务，它将不会再次自动运行。|c4rnc|要重新打开它，请在cmd+admin中输入'net+start+mysql‘和版本号，在我的例子中是'net+start+mysql80’。^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|S|9|@]|A|@]|B|$]]|$2|F|4|G|6|E|8|T|9|@]|A|@]|B|$]]|$2|H|4|I|6|E|8|U|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|V|9|@]|A|@]|B|$]]|$2|L|4|M|6|E|8|W|9|@]|A|@]|B|$]]|$2|N|4|O|6|E|8|X|9|@]|A|@]|B|$]]|$2|P|4|Q|6|E|8|Y|9|@]|A|@]|B|$]]]]

This is a newer and easier answer.
<ol>
<li>Run cmd as admin</li>
<li>Type &quot;net start mysql&quot; then the version number, in my case &quot;net start mysql80&quot; for MySQL 8.0.</li>
<li>If it says it's already running great, otherwise now mysql is running.</li>
<li>Exit cmd, WIN+R and type services.msc, scroll down until you find my sql with the right version.</li>
<li>Right-Click for properties, under startup type select 'Manual', then under service status select 'Stop'</li>
<li>Now you stopped mysql service and it will not run automatically again.</li>
<li>To turn it back on, in cmd admin 'net start mysql' and the version number, in my case 'net start mysql80'</li>
</ol>

I am developing a website and need to refresh data. Therefore MySQL must be stopped. 
How can I stop the service?

When I look at control panel services it is started without stop or restart option.

Stop MySQL service windows

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

 我正在开发一个网站，需要刷新数据。因此，必须停止MySQL。 如何停止服务？ 当我查看控制面板服务时，它是在没有停止或重新启动选项的情况下启动的。

问停止MySQL服务窗口
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问停止MySQL服务窗口EN