{"id":8908,"date":"2019-09-17T19:51:44","date_gmt":"2019-09-18T02:51:44","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=8908"},"modified":"2023-12-23T19:48:50","modified_gmt":"2023-12-24T02:48:50","slug":"restart-mysql-server","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/restart-mysql-server\/","title":{"rendered":"Restart MySQL Server"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to restart MySQL Server on Windows and Linux.<\/p>\n\n\n\n

Restart MySQL Server on Windows<\/h2>\n\n\n\n

If you install MySQL as a Windows service, you can follow these steps to restart the MySQL Server.<\/p>\n\n\n\n

First, press the Windows+R<\/code> to open the Run<\/code> dialog.<\/p>\n\n\n\n

Second, type services.msc<\/code> and press Enter<\/code> to open the Services<\/code> window.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Third, in the Services<\/code> window, look for the MySQL service name, select it, and click the Restart the service<\/code> button as shown in the following picture:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you want to use commands, you can stop <\/a>and start <\/a>the MySQL service<\/a>.<\/p>\n\n\n\n

Restart MySQL Server on Linux<\/h2>\n\n\n\n

You use the following command to restart the MySQL Server on Linux:<\/p>\n\n\n\n

First, open the Terminal program.<\/p>\n\n\n\n

Second, run the following command to restart the MySQL service:<\/p>\n\n\n

sudo systemctl restart mysql.service<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this command, you need to replace the mysql.serivce<\/code> service name with the actual one in your server. <\/p>\n\n\n\n
Third, check the status and confirm the mysql service has restarted successfully, you run the following command:<\/p>\n\n\n
sudo<\/span> systemctl<\/span> status<\/span> mysql<\/span>.service<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
If the service has restarted successfully, you should see “Active: active (running)<\/code>“.<\/p>\n\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the Services<\/code> app to restart the MySQL Service on Windows.<\/li>\n\n\n\n
  • Use the sudo systemctl restart mysql<\/code> command to restart MySQL Service on Linux.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t