WampServer

I just upgraded my MySQL from 5.7 to 8.0 by using wampserver3_x64_addon_mysql8.0.36.exe.


The problem is that MySQL 8 is using the my.ini from MySQL 5.6.17. For the life of me, I cannot determine where you specify which .ini file to use. I've looked in the registry, the services, wampmanager.ini, etc.

How do I specify the correct my.ini for MySQL 8?

Each MySQL version uses its own my.ini file, located in its own folder.

MySQL 8.0.36 uses the my.ini located in wamp64\bin\mysql\mysql8.0.36\my.ini

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I'm using MySQL workbench. When I go to the "Server Status" page,. it says:

Version: MySQL 8.0.36 (MySQL Community Server - GPL)
Configuration File: c:\wamp\bin\mysql\mysql5.6.17\my.ini


There has to be a reason that it's finding it in that other folder. I have a my.ini in the 8.0.36 directory, but it's just not using it.

MySQL Workbench is not part of the Wampserver distribution.

Either incorrect Workbench settings or incorrect creation of an environment variable used by Workbench.

Wampserver does not create or use any environment variables.

In either case, it's a Workbench problem.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons