{"id":8902,"date":"2019-09-17T19:05:51","date_gmt":"2019-09-18T02:05:51","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=8902"},"modified":"2023-12-18T06:17:35","modified_gmt":"2023-12-18T13:17:35","slug":"start-mysql-server","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/start-mysql-server\/","title":{"rendered":"Start MySQL Server"},"content":{"rendered":"\n

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

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

To start MySQL Server on Linux, you follow these steps:<\/p>\n\n\n\n

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

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

sudo systemctl start mysql<\/code><\/span><\/pre>\n\n\n
In this command, you need to replace the “mysql” with the actual service name if the MySQL service is different.<\/p>\n\n\n\n
Third, check the status and confirm that the service has started successfully, you run the following command:<\/p>\n\n\n
sudo systemctl status mysql<\/code><\/span><\/pre>\n\n\n
If the MySQL service has started successfully, you should see “Active: active (running)<\/code>“.<\/p>\n\n\n\n
Start MySQL Server on Windows<\/h2>\n\n\n\n
Typically, the MySQL installer installs the MySQL Server as a service on Windows and starts the MySQL Server automatically when the Windows operating system starts up. If this is not the case, you can start the MySQL Server using the following steps:<\/p>\n\n\n\n
First, open the Run<\/code> dialog by pressing Windows+R<\/code> keyboard shortcut.<\/p>\n\n\n\n
Second, type cmd<\/code> and press Ctrl+Shift+Enter<\/code> to run the Command Prompt as an administrator.<\/p>\n\n\n\n
Third, type the following command:<\/p>\n\n\n
sc query mysql<\/code><\/span><\/pre>\n\n\n
In this command, mysql<\/code> is the name of the MySQL service that you specified when setting up MySQL. You can replace it with the one on your server.<\/p>\n\n\n\n
This command shows the following output:<\/p>\n\n\n
SERVICE_NAME: mysql\n        TYPE               : 10  WIN32_OWN_PROCESS\n        STATE              : 1  STOPPED\n        WIN32_EXIT_CODE    : 0  (0x0)\n        SERVICE_EXIT_CODE  : 0  (0x0)\n        CHECKPOINT         : 0x0\n        WAIT_HINT          : 0x0<\/code><\/span><\/pre>\n\n\n
The STATE<\/code> line indicates that the MySQL Server is currently STOPPED<\/code>. <\/p>\n\n\n\n
Finally, use the net start<\/code> command to start the MySQL Server:<\/p>\n\n\n
net start mysql<\/code><\/span><\/pre>\n\n\n
It’ll show the following output:<\/p>\n\n\n
The MySQL service is starting.\nThe MySQL service was started successfully.<\/code><\/span><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the sudo systemctl start mysql<\/code> command to start MySQL server on Linux.<\/li>\n\n\n\n
  • Use the  net start <mysql_service><\/code> command to start MySQL Server on Windows.<\/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