title: The service 'wampmysqld64' is NOT started, EXIT error code 0
body: <p>I wanted to upgrade MySQL from 5.7.24 to 8.0.20, so I followed the steps <a href="https://www.nairaland.com/1565023/how-successfully-upgrade-mysql-wamp" rel="nofollow noreferrer">here</a>.</p>
  <p>TL;DR, I downloaded and extracted the MySQL 8 zip file in <em>C:/Wamp/bin/mysql</em>, and copied the old <em>data</em> folder, <em>my.ini</em>, and <em>wampserver.conf</em> into the new <em>mysql8.0.20</em> folder.
  I also changed all instances of '5.7.24' to '8.0.20' in <em>my.ini</em>, and ran the command <code>mysqld.exe --initialize-insecure</code>.</p>
  <p>This is my <em>my.ini</em> file without comments:</p>
  <pre><code>[client]
  port = 3306
  socket = /tmp/mysql.sock
  
  [wampmysqld64]
  default_authentication_plugin=mysql_native_password
  port = 3306
  socket = /tmp/mysql.sock
  key_buffer_size = 256M
  max_allowed_packet = 1M
  
  table_definition_cache = 600
  
  sort_buffer_size = 2M
  net_buffer_length = 8K
  read_buffer_size = 2M
  read_rnd_buffer_size = 2M
  myisam_sort_buffer_size = 64M
  basedir=&quot;C:/Wamp/bin/mysql/mysql8.0.20&quot;
  log-error=&quot;C:/Wamp/logs/mysql.log&quot;
  log_error_verbosity=2
  datadir=&quot;C:/Wamp/bin/mysql/mysql8.0.20/data&quot;
  
  lc-messages-dir=&quot;C:/Wamp/bin/mysql/mysql8.0.20/share&quot;
  lc-messages=en_US
  
  default-storage-engine=MYISAM
  
  secure_file_priv=&quot;C:/Wamp/tmp&quot;
  skip-ssl
  
  explicit_defaults_for_timestamp=true
  
  sql-mode=&quot;STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER&quot;
  
  skip-federated
  
  server-id = 1
  
  skip-slave-start
  
  early-plugin-load=&quot;&quot;
  
  innodb_data_file_path = ibdata1:12M:autoextend
  innodb_buffer_pool_size = 256M
  innodb_log_file_size = 256M
  innodb_log_buffer_size = 8M
  innodb_flush_log_at_trx_commit = 1
  innodb_lock_wait_timeout = 50
  innodb_flush_method=normal
  
  [mysqldump]
  quick
  max_allowed_packet = 16M
  
  [mysql]
  no-auto-rehash
  
  [isamchk]
  key_buffer_size = 20M
  sort_buffer_size = 20M
  read_buffer_size = 2M
  write_buffer_size = 2M
  
  [myisamchk]
  key_buffer_size = 20M
  sort_buffer_size_size = 20M
  read_buffer_size = 2M
  write_buffer_size = 2M
  
  [mysqlhotcopy]
  interactive-timeout
  
  [mysqld]
  default_authentication_plugin=mysql_native_password
  port = 3306
  </code></pre>
  <p>But when I run Wamp, the icon stays orange and it says only 2 of 3 services are running. If I check the state of services, it says:</p>
  <pre><code>The service 'wampmysqld64' is NOT started
  EXIT error code:0
  Help message for error code 0 is: The operation completed successfully.
  </code></pre>
  <p>Which means everything works correctly. And it does. I can use MySQL and open the console without any problem. So why is the icon still orange?</p>
  <p>If I go in services.msc and look for <em>wampmysqld64</em>, the service is not running, and I cannot start it:</p>
  <pre><code>The wampmysqld64 service on Local Computer started and then stopped.
  Some services stop automatically if they are not in use by other services or programs.
  </code></pre>
  <p>I also deleted the files <em>ib_logfile0</em>, <em>ib_logfile1</em>, and <em>ibdata1</em> from the <em>mysql8.0.20/data</em> folder.</p>
  <p>If I go back to the old MySQL version, the error still persists.</p>