Related Documentation Download this Excerpt

5.5.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.

Note

MySQL Notifier 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:\> "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:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown
Note

If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply the password when prompted.

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

Users in the MySQL grant system are wholly independent from any login users under Microsoft 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 in the 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 --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 that will help solve the problem.

The last option is to start mysqld with the --standalone and --debug options. In this case, mysqld writes a log file C:\mysqld.trace that should contain the reason why mysqld doesn't start. See The DBUG Package.

Use mysqld --verbose --help to display all the options that mysqld supports.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
  Posted by Jacob Nikom on July 24, 2011
Another way to see where the error log file is to look into
my.ini files which is in the server directory:
dir "C:\Program Files\MySQL\MySQL Server 5.5\my.ini"
Volume in drive C is 1USL16375
Volume Serial Number is 504C-D5B9

Directory of C:\Program Files\MySQL\MySQL Server 5.5

07/24/2011 04:43 PM 8,955 my.ini
1 File(s) 8,955 bytes
0 Dir(s) 37,051,760,640 bytes free

In my.ini file there is a line
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/"

This line shows the directory where error log file is going to be.

Jacob Nikom

  Posted by Russell Lott on November 13, 2016
Regarding use of CYGWIN terminal ...

for anyone trying to run mysql from a cygwin terminal on a Windows box ...
you many encounter an issue where the command line interface seems to hang when you login.
This is an issue with cygwin that appears to have existed for a very long time.
By default, the system will use the instance of mysql.exe located in the mysql bin directory.
Cygwin doesn't play nicely with the mysql interface.
If you want to the CLI under Cygwin, you have to use *their* instance of mysql.exe ... make sure you have their latest and greatest version.

I switched to Powershell.
Sign Up Login You must be logged in to post a comment.