Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Stop MySQL service windows

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.

like image 793
jop Avatar asked Jun 04 '12 16:06

jop


People also ask

How do I restart MySQL server on Windows?

Restart MySQL Server on Windows First, open the Run window by using the Windows+R keyboard. Second, type services. msc and press Enter : Third, select the MySQL service and click the restart button.

How do I shut down MySQL?

The proper way to shutdown your MySQL server is to the use "mysqladmin shutdown" command. Other ways to shutdown your server include: Enter "mysqladmin -u root -ppassowrd shutdown" command with options in a command window. Use Windows Task Manager to end the process: "mysqld.exe".


1 Answers

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.

like image 173
vinothp Avatar answered Oct 11 '22 08:10

vinothp