Stop MySQL service windows

Question

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

User · Answer

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:

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:

net start "mysql"

And in your stop.bat:

net stop "mysql"

User · Answer

I m on XP  I ve installed MySQL-5 6 10 manually from  zip  no Windows auto-installer provided by MySQL site  The  bin directory of my MySQL is in my PATH  So I start the server with mysqld --console command  like this   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     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 mysqladmin -u root shutdown on the other cmd window or with Ctrl   C on the cmd window it is running in  The latter works not so good as the former  sometimes I have to click Ctrl   C twice or more   The log of the shutdown process is like this   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   And I still don t know if it is 100  right way to shutdown the server  but it works

User · Answer

net stop MySQL    or   mysqld stop   or   mysql stop   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  Atli      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

User · Answer

If MySQL 57   net start MySQL57   OR   net stop MySQL57

User · Answer

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

User · Answer

The Top Voted Answer is out of date  I just installed MySQL 5 7 and the service name is now MySQL57 so the new command is   net stop MySQL57

User · Answer

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

User · Answer

to stop the service   sc stop mysql56  and to start it   sc start mysql56  you might need to change the mysql56 to whatever your version is

User · Answer

just type exit  and u are out of mysql in cmd in windows

User · Answer

On windows 10   If you wanna close it open command prompt with work with admin  Write NET STOP MySQL80  Its done   If you wanna open again so you must write NET START MySQL80   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

User · Answer

Start Powershell as administrator and run   net start  MySQL-service-name    Find the service name    run  services msc   look for MySQL and click on properties

User · Answer

I got the same problem and here my solution    go to service msc and find mysql service  set it as start manually  go to task manager - processes tab and find mysqld  stop it  go to task manager - services tab find mysql service and stop it

User · Answer

To successfully stop MySQL Service on Windows    Check on services the name of the service for MySQL Run as administrator   net stop  MySQL Service name

User · Answer

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       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 Now that you have local OS admin access you can use  mysqld stop   which will simply return    IF YOU SEE THE FOLLOWING YOU ARE TRYING IT WITH A USER COMMAND PROMPT THAT DOES NOT HAVE THE CORRECT PRIVILEGES   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    If mysqld does not appear as a known system command  try adding it to your class path   Right click on My Computer Advanced System Settings Environment Variables System variables look for and left click select the variable named path 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

User · Answer

On Windows  If you are using windows Open the Command Prompt and type  To Stop MySQL Service  net stop MySQL    To Start MySQL Service  net start MySQL    On Linux  Expand Select Wrap Line Numbers     etc init d mysqld start    etc init d mysqld stop    etc init d mysqld restart   Fedora   Red Hat also support this    Expand Select Wrap Line Numbers    service mysqld start    service mysqld stop    service mysqld restart   I know this answer is late but i hope it helps for some one

User · Answer

If you are running windows try this    click start button on a keyboard  type task manager right click and click run as administrator  when the task manager opens  click on services then look for MySQL then right click on it then click stop then close task manager and you are done    to start it when you wand to use it  follow the same steps and click start this time

[mysql] Stop MySQL service windows

Examples related to mysql

Examples related to shutdown

Examples related to restart