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.

ACtually, why do you even need to stop a server to refresh your data? — Sebas, Sep 19 '14 at 14:42
To start : net start mysql Type in CMD with run as administrator: net stop mysql — Vijay, Mar 10 '22 at 06:14

score 70 · Answer 1 · edited May 30 '21 at 03:30

70

On Windows

If you are using Windows Open the Command Prompt and type

To Stop MySQL Service:

net stop MySQL80

To Start MySQL Service:

net start MySQL80

On Linux

# /etc/init.d/mysqld start
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld restart

Fedora / Red Hat also support this:

# service mysqld start
# service mysqld stop
# service mysqld restart

Also Systemd based distrubutions (like Ubuntu or Arch Linux) support this:

# systemctl start mysql
# systemctl stop mysql
# systemctl restart mysql

I know this answer is late but i hope it helps for some one.

edited May 30 '21 at 03:30

Sebastian

142
2
7

answered Jan 11 '13 at 17:24

vinothp

9,939
19
61
103

If on CENTOS7 the service command is replaced by systemctl start/stop/restart – Evan Bechtol Feb 08 '15 at 15:40
7

`The service name is invalid. More help is available by typing NET HELPMSG 2185` – Green Jul 02 '16 at 08:07
11

On Windows for version 5.7 specific it is MySQL57 – Anirudha Gupta Jan 14 '17 at 12:53
10

On Windows 10 with MySQL 8.0 it is MySQL80. Run from terminal: NET STOP MySQL80, then NET START MySQL80 – Andrew Krizhanovsky May 18 '18 at 08:47
1

For me the service name is just "mysql" – isimmons Oct 09 '22 at 23:57

Nishu Tayal · Answer 2 · 2016-12-21T12:06:10.880

46

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"

edited Dec 21 '16 at 12:06

answered Jun 04 '12 at 17:12

Nishu Tayal

20,106
8
49
101

score 16 · Answer 3 · answered Dec 29 '15 at 19:39

16

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

answered Dec 29 '15 at 19:39

Matthew Verstraete

6,335
22
67
123

3

This worked for me and I had to run mine as admin, just a note to whomever it may help. – Omar Ayala Apr 14 '16 at 21:15
It depends on what version you install and it is also possible to give the service a custom name. – Gary Carlyle Cook Oct 11 '16 at 23:43
dont forget to run console as admin – Drahoš Maďar Apr 23 '19 at 11:18

Bar Horing · Answer 4 · 2017-11-14T09:30:08.127

13

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

edited Nov 14 '17 at 09:30

answered Nov 14 '17 at 08:54

Bar Horing

5,337
3
30
26

score 7 · Answer 5 · answered Oct 02 '17 at 04:32

7

If MySQL 57.

net start MySQL57

OR

net stop MySQL57

answered Oct 02 '17 at 04:32

Vitalie Bancu

171
1
11

1

This worked for me with powershell as an administrator on my windows development server. – klewis Apr 04 '18 at 17:06

Sebas · Answer 6 · 2013-04-12T14:39:04.830

6

net stop MySQL*

or

mysqld stop

or

mysql stop

in the window's command line prompt.

<*> 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.

edited Apr 12 '13 at 14:39

answered Jun 04 '12 at 16:55

Sebas

21,192
9
55
109

3

Neither stops the server on XP. 1) `net stop MySQL` => "system error 1060.". 2) `mysqld stop` => "2013-04-12 17:22:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_times tamp server option (see documentation for more details)". The server is still running. 3) `mysql stop` => "ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'stop'". The server war started with "mysqld --console". – Green Apr 12 '13 at 14:24
@Green. Exactly my experience running those three commands! I used Windows 8. That being said, running `net stop ` does work when the command window was opened 'As Administrator'. – Ifedi Okonkwo Oct 02 '14 at 14:13
looks like, starting command line with "Run as Administrator" mode worked for me – Manohar Reddy Poreddy May 08 '16 at 09:18

score 6 · Answer 7 · answered Dec 28 '12 at 20:05

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

score 6 · Answer 8 · answered Apr 12 '13 at 15:05

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>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 :)

score 3 · Answer 9 · answered Jul 21 '15 at 08:15

3

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.

answered Jul 21 '15 at 08:15

Yar

7,020
11
49
69

score 3 · Answer 10 · answered Jan 17 '20 at 14:01

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.

score 3 · Answer 11 · answered Feb 25 '21 at 01:49

This is a newer and easier answer.

Run cmd as admin
Type "net start mysql" then the version number, in my case "net start mysql80" 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'

score 2 · Answer 12 · edited Feb 28 '17 at 17:20

2

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

edited Feb 28 '17 at 17:20

hering

1,956
4
28
43

answered Feb 28 '17 at 15:02

Relexk

29
1

score 1 · Answer 13 · answered Feb 08 '15 at 15:32

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

score 1 · Answer 14 · answered Apr 03 '20 at 13:01

1

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]

answered Apr 03 '20 at 13:01

Ion Scorobogaci

147
2
5

score 0 · Answer 15 · answered Sep 02 '19 at 05:38

0

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

answered Sep 02 '19 at 05:38

abd aziz

65
5

Gopinathsgn · Answer 16 · 2022-05-10T09:15:31.900

As people already explained,

In windows, open Command Prompt as Administrator
if you're using MySQL 8.0

net start mysql80 - to start MySQL

net stop mysql80 - to stop MySQL

(if you're using MySQL 5.7 then net stop mysql57, similar for other versions)

(Additional method) - via bat file

just in case, if you forget the command often and want to do it via few clicks instead of opening command prompt and typing command every time,

open notepad type,

cmd /k net stop mysql80
save as stop_mysql.bat
right click on file 'stop_mysql.bat', run as Administrator to run the MySQL stop command. This will run above stop command to stop MySQL
You can also create another bat file for starting MySQL with the other command

Thanks.

score -1 · Answer 17 · answered Jan 14 '17 at 12:37

-1

just type exit

and u are out of mysql in cmd in windows

answered Jan 14 '17 at 12:37

Usama Chitapure

1

Stop MySQL service windows

17 Answers17

Linked