The MySQL server can be started manually from the command line. This can be done on any version of Windows.
The MySQL Notifier for Microsoft Windows GUI can also be used to start/stop/restart the MySQL server.
To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command:
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld"
The path to mysqld may vary depending on the install location of MySQL on your system.
You can stop the MySQL server by executing this command:
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown
If the MySQL
root user account has a
password, you need to invoke mysqladmin
-p option and supply the password
This command invokes the MySQL administrative utility
mysqladmin to connect to the server and tell
it to shut down. The command connects as the MySQL
root user, which is the default
administrative account in the MySQL grant system. Note that
users in the MySQL grant system are wholly independent from any
login users under Windows.
If mysqld doesn't start, check the error log
to see whether the server wrote any messages there to indicate
the cause of the problem. By default, the error log is located
C:\Program Files\MySQL\MySQL Server
5.7\data directory. It is the file with
a suffix of
.err, or may be specified by
passing in the
option. Alternatively, you can try to start the server as
mysqld --console; in this case, you may get
some useful information on the screen that may help solve the
The last option is to start mysqld with the
--debug options. In this case,
mysqld writes a log file
C:\mysqld.trace that should contain the
reason why mysqld doesn't start. See
Section 22.4.3, “The DBUG Package”.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices