mysqlwampwampserver

The service 'wampmysqld64' is NOT started, EXIT error code 0


I wanted to upgrade MySQL from 5.7.24 to 8.0.20, so I followed the steps here.

TL;DR, I downloaded and extracted the MySQL 8 zip file in C:/Wamp/bin/mysql, and copied the old data folder, my.ini, and wampserver.conf into the new mysql8.0.20 folder. I also changed all instances of '5.7.24' to '8.0.20' in my.ini, and ran the command mysqld.exe --initialize-insecure.

This is my my.ini file without comments:

[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="C:/Wamp/bin/mysql/mysql8.0.20"
log-error="C:/Wamp/logs/mysql.log"
log_error_verbosity=2
datadir="C:/Wamp/bin/mysql/mysql8.0.20/data"

lc-messages-dir="C:/Wamp/bin/mysql/mysql8.0.20/share"
lc-messages=en_US

default-storage-engine=MYISAM

secure_file_priv="C:/Wamp/tmp"
skip-ssl

explicit_defaults_for_timestamp=true

sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"

skip-federated

server-id = 1

skip-slave-start

early-plugin-load=""

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

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:

The service 'wampmysqld64' is NOT started
EXIT error code:0
Help message for error code 0 is: The operation completed successfully.

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?

If I go in services.msc and look for wampmysqld64, the service is not running, and I cannot start it:

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.

I also deleted the files ib_logfile0, ib_logfile1, and ibdata1 from the mysql8.0.20/data folder.

If I go back to the old MySQL version, the error still persists.


Solution

  • There is a high probability that you are using another service such as workbench or something else that uses the mySQL server. From what I read in the forum for Wamp and my limited understanding of what is happening. The other service uses the port 3306. I shifted my port to 3308 and my service automatically started running. If you have the same problem as me, you can just change the port number. For other more detailed problems you can refer to the forum attached below. http://forum.wampserver.com/read.php?2,152310,152476