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.
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.
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".
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With