Start MySQL from Windows Command Line

To start the mysqld server from the command line, you should start the console window (or DOSwindow) and enter the command: C: ProgramFilesMySQLMySQLServer5.0binmysqld depending on the MySQL installation location in the system, the paths used in the preceding example are also different. In non-NT Windows, start mysqld in the background. That is,

To start the mysqld Server from the command line, you should start the console window (or DOS window) and enter the command: C: Program FilesMySQLMySQL Server 5.0 binmysqld according to the MySQL installation location in the system, the paths used in the preceding example are also different. In non-NT Windows, start mysqld in the background. That is,

To start the mysqld server from the command line, you should start the console window (or "DOS window") and enter the command:

C:> C: Program FilesMySQLMySQL Server 5.0 binmysqld

The path used in the preceding example varies depending on the MySQL installation location in the system.

In non-NT Windows, start mysqld in the background. That is, after the server is started, you should be able to see the following command prompt. If you use this method to start the server in Windows NT, 2000, XP, or 2003, the server runs on the front-end. No command prompt is displayed before the server exits. Therefore, when the server is running, you should open another console window to run the client program.

Run the following command to stop the MySQL server:

C:> C: Program FilesMySQLMySQL Server 5.0 binmysqladmin-u root shutdown

This command calls MySQL management tool mysqladmin to connect to the server and notify it to disable the service. This command uses the MySQL root User to connect. This is the default management account in the MySQL permission system. Note that users in the MySQL permission system are completely independent from those logged on to Windows.

If mysqld cannot be started, check the error log to see if the server has written any message indicating the cause of the problem. The error log is located in the directory C: Program FilesMySQLMySQL Server 5.1data. Is a file with a suffix. err. You can also start the server as mysqld -- console. In this case, you can obtain some useful information from the window to help solve the problem.

The final option is to start mysqld with -- standalone -- debug. In this case, mysqld writes the log file C: mysqld. trace, which should contain the reason why mysqld is not started.

Use mysqld -- verbose -- help to display all the options of mysqld.