title: Start MySQL Server as a service (Win 8)
body: <p>I am trying out MySQL (Windows 8), with the workbench (gui) installed as well. </p>
  
  <p>I am still in the installation / configuration process. I would like to create a new database. So, on the workbench's welcome screen, I have selected <code>New Server Instance- Register a new Server instance to manage</code>. </p>
  
  <p>In order to do this, I have went through following configuration steps: </p>
  
  <ol>
  <li><p>Specify <code>localhost</code> as server host,</p></li>
  <li><p>Give it the username and password I am using.</p></li>
  </ol>
  
  <p>It then tests a database connection, and, in the next step, asks me to </p>
  
  <blockquote>
    <p>Select the Service to manage from the list below.
    It will also help find the configuration file.</p>
  </blockquote>
  
  <p><strong>However, the list of possible Services is empty and if I click [next], it says</strong> </p>
  
  <blockquote>
    <p>Error: In Order to manage a MySQL Service it must be installed as a Service. The wizard can not find any MySQL Service at the target machine, so the Server instance cannot be started.</p>
  </blockquote>
  
  <p>I think that I have to somehow start the MySQL Service, as it might already been installed when I had installed the whole MySQL Toolset. </p>
  
  <p>So: <strong>How would I start this MySQL Service under Windows 8?</strong> </p>
  
  <p><strong>Some things I've tried:</strong></p>
  
  <p>The <a href="http://dev.mysql.com/doc/refman/5.1/en/windows-start-command-line.html" rel="noreferrer">Manual</a> says to try:</p>
  
  <pre><code>C:\&gt; "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld"
  </code></pre>
  
  <p>in order to install it as a Service.  Yet, nothing happens and I get the following (some verbose [Note]s were removed):</p>
  
  <pre><code>2013-04-13 23:44:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
  ted. Please use --explicit_defaults_for_timestamp server option (see documentati
  on for more details).
  2013-04-13 23:44:22 2592 [Warning] Can't create test file c:\Program Files\MySQL
  \MySQL Server 5.6\data\gast.lower-test
  2013-04-13 23:44:22 2592 [Warning] Can't create test file c:\Program Files\MySQL
  \MySQL Server 5.6\data\gast.lower-test
  [...]
  2013-04-13 23:44:22 2592 [ERROR] InnoDB: read can't be opened in .\ibdata1 mode
  2013-04-13 23:44:22 2592 [ERROR] InnoDB: The system tablespace must be writable!
  
  2013-04-13 23:44:22 2592 [ERROR] Plugin 'InnoDB' init function returned error.
  2013-04-13 23:44:22 2592 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN
  E failed.
  2013-04-13 23:44:22 2592 [ERROR] Unknown/unsupported storage engine: InnoDB
  2013-04-13 23:44:22 2592 [ERROR] Aborting
  
  2013-04-13 23:44:22 2592 [Note] Binlog end
  [...]
  2013-04-13 23:44:22 2592 [Note] mysqld: Shutdown complete
  </code></pre>
  
  <p>To install the server as a service, I've used this command (<a href="http://dev.mysql.com/doc/refman/5.1/en/windows-start-service.html" rel="noreferrer">per the manual</a>).</p>
  
  <pre><code>C:\&gt; "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --install
  </code></pre>
  
  <p>Again, "nothing" happens, I get (again, most of the verbose [Note]s are removed):</p>
  
  <pre><code>Install/Remove of the Service Denied!
  
  c:\Program Files\MySQL\MySQL Server 5.6\bin&gt;mysqld -p --install
  2013-04-13 23:43:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
  ted. Please use --explicit_defaults_for_timestamp server option (see documentati
  on for more details).
  2013-04-13 23:43:24 3764 [Warning] Can't create test file c:\Program Files\MySQL
  \MySQL Server 5.6\data\gast.lower-test
  2013-04-13 23:43:24 3764 [Warning] Can't create test file c:\Program Files\MySQL
  \MySQL Server 5.6\data\gast.lower-test
  [...]
  2013-04-13 23:43:24 3764 [ERROR] InnoDB: read can't be opened in .\ibdata1 mode
  2013-04-13 23:43:24 3764 [ERROR] InnoDB: The system tablespace must be writable!
  
  2013-04-13 23:43:24 3764 [ERROR] Plugin 'InnoDB' init function returned error.
  2013-04-13 23:43:24 3764 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN
  E failed.
  2013-04-13 23:43:24 3764 [ERROR] mysqld: unknown option '-p'
  2013-04-13 23:43:24 3764 [ERROR] Aborting
  
  2013-04-13 23:43:24 3764 [Note] Binlog end
  [...]
  2013-04-13 23:43:24 3764 [Note] mysqld: Shutdown complete
  </code></pre>