title: MySQL: Cannot start Service, Windows 10
body: <p>I am aware that this question has been asked many times before, but all solutions I tried out did not work for me.</p>
  
  <p>So, I installed MySQL Workbench and server. I log into Workbench as root. In the toolbar I click on <strong>Server</strong> then <strong>Startup/Shutdown</strong> and there I click on the button <strong>Start Server</strong>. But whenever I do this, I get following log:</p>
  
  <blockquote>
    <p>018-05-14 21:09:59 - Starting server...<br>
    2018-05-14 21:10:07 - Server start done.<br>
    2018-05-14 21:10:09 - Checking server status...<br>
    2018-05-14 21:10:09 - Trying to connect to MySQL...<br>
    2018-05-14 21:10:09 - Can't connect to MySQL server on 'localhost' (10061) (2003)<br>
    2018-05-14 21:10:09 - Assuming server is not running</p>
  </blockquote>
  
  <p>Addiotionally a popup appears which says:</p>
  
  <blockquote>
    <p><strong>Connect Error</strong></p>
    
    <p>Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061)(code 2003)</p>
  </blockquote>
  
  <p>One solution I found suggested installing the server manually. So I went into cmd as admin and typed:</p>
  
  <pre><code>C:\&gt; "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --install
  </code></pre>
  
  <p>It gave following output:</p>
  
  <blockquote>
    <p>Service successfully installed.</p>
  </blockquote>
  
  <p>But in Workbench the Server is still stopped and when trying to start it like mentioned above the same logs with the same popup and error appears.</p>
  
  <p>Another solution I found suggested installing MySQL Notifier and using it to start and stop the server and use it to manage monitored items. But quite frankly, once I restart workbench and try to log in as root, it wont even log in but give following pop up error:</p>
  
  <blockquote>
    <p><strong>Cannot Connect to Database Server</strong></p>
    
    <p>Your conection attempt failed for user 'root' from your host to server at localhost:3306:<br>
    Authentication plugin 'catching sha2 password' cannot be loaded: Das angegebene Modul wurde nicht gefunden.</p>
    
    <p>Please:<br>
    1 Check that mysql is running on server localhost<br>
    2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)<br>
    3 Check the root has rights to connect to localhost from your adress (mysql rights define what clients can connect to the server from which machines)<br>
    4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host adress you're connecting from</p>
  </blockquote>
  
  <p>So now this <em>"Authentication plugin 'catching sha2 password' cannot be loaded:"</em> looks suspicious and I tried looking that up. I found <a href="https://stackoverflow.com/a/50209363/7964981">this solution</a>, which requires me to log into MySQL from cmd, but when I type <code>C:\Program Files\MySQL\MySQL Server 8.0\bin&gt;mysql -u root -p</code> and execute it, it asks for the password which I provide, but then it answers with</p>
  
  <blockquote>
    <p>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)</p>
  </blockquote>
  
  <p>Now I hit a wall and I don't know how to continue. The MySQL server still doesn't work and I am desperate.</p>