Installing MySQL on Microsoft Windows Using a  noinstall  ZIP Archive To start the server, enter this command: For a server that includes  InnoDB  support, you should see the messages similar to those following as it starts (the path names and sizes may differ): When the server finishes its startup sequence, you should see something like this, which indicates that the server is ready to service client connections: The server continues to write to the console any further diagnostic output it produces. You can open a new console window in which to run client programs. If you omit the  --console  option, the server writes diagnostic output to the error log in the data directory ( C:\Program Files\MySQL\MySQL Server 8.0\data  by default). The error log is the file with the .err  extension, and may be set using the  --log-error  option. The initial  root  account in the MySQL grant tables has no password. After starting the server, you should set up a password for it using the instructions in Section 2.10.4, “Securing the Initial MySQL Account” . The MySQL server can be started manually from the command line. This can be done on any version of Windows. To start the  mysqld  server from the command line, you should start a console window (or “DOS window” ) and enter this command: 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: If the MySQL  root  user account has a password, you need to invoke  mysqladmin with the  -p  option and supply the password when prompted. 146 Note 2.3.4.6 Starting MySQL from the Windows Command Line Note C:\>  "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --console InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 31457280 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 31457280 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 31457280 InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: creating foreign key constraint system tables InnoDB: foreign key constraint system tables created 011024 10:58:25 InnoDB: Started mysqld: ready for connections Version: ’8.0.25’ socket: ’’ port: 3306 C:\>  "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" C:\>  "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" -u root shutdown