Documentation Home
MySQL 8.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.2Mb
PDF (A4) - 40.3Mb
Man Pages (TGZ) - 262.0Kb
Man Pages (Zip) - 367.6Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 8.4 Reference Manual  / ...  / Installing MySQL  / Installing MySQL on Microsoft Windows  / Configuration: Manually  /  Starting MySQL from the Windows Command Line

2.3.3.6 Starting MySQL from the Windows Command Line

The MySQL server can be started manually from the command line. This can be done on any version of Windows.

To start themysqld server from the command line, you should start a console window (orDOS window) and enter this command:

C:\> "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqld"

The path tomysqld may vary depending on the install location of MySQL on your system.

You can stop the MySQL server by executing this command:

C:\> "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqladmin" -u root shutdown
Note

If the MySQLroot user account has a password, you need to invokemysqladmin with the-p option and supply the password when prompted.

This command invokes the MySQL administrative utilitymysqladmin to connect to the server and tell it to shut down. The command connects as the MySQLroot user, which is the default administrative account in the MySQL grant system.

Note

Users in the MySQL grant system are wholly independent from any operating system users under Microsoft Windows.

Ifmysqld 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 in theC:\Program Files\MySQL\MySQL Server 8.4\data directory. It is the file with a suffix of.err, or may be specified by passing in the--log-error option. Alternatively, you can try to start the server with the--console option; in this case, the server may display some useful information on the screen to help solve the problem.

The last option is to startmysqld with the--standalone and--debug options. In this case,mysqld writes a log fileC:\mysqld.trace that should contain the reason whymysqld doesn't start. SeeSection 7.9.4, “The DBUG Package”.

Usemysqld --verbose --help to display all the options thatmysqld supports.