How To Start MySQL via Command Line In Windows and Linux?

by

MySQL is a popular open-source database used in Windows and Linux operating systems. MySQL is used as a service that can be started, stopped, or restarted via the command line interface. By default, the MySQL service is set to start when the operating system boots. But we can also start the MySQL server via the command line interface if it is not started.

Start MySQL via Command Line In Windows

The MySQL service is managed with the mysqld command which can be used to start the MySQL database server. We can just call the mysqld command with the start parameter in order to start the MySQL server in Windows operating systems.

> mysqld start

In some cases, the mysqld path is not configured properly and the upper command may not work. We can start the MySQL server by using the complete path of the mysqld command like below. Keep in mind that we assume that the current installed MySQL version is 8.0 and is located in the specified path. 

> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" start

Start MySQL via Command Line In Linux

We can start the MySQL service via command line in Linux by using the systemctl command. The systemctl command is used to manage services in Linux operating systems and distributions. Most of the modern Linux distributions support the systemctl command. The MySQL service is named as mysqld and the start is used for the start action for the MySQL service.

$ sudo systemctl start mysqld

Leave a Comment