Configuring XCP for non-default MySQL instance

[gregbaatard]

Hi,

I need to run a portable version of XAMPP in an environment which already has MySQL running as a service which cannot be stopped. I've set MySQL to use a different port and socket name in my.ini and set those as the defaults for mysql and mysqli in php.ini, but the XAMPP Control Panel is giving me problems.

When I open XCP, it shows that MySQL is already running, as a service. It is detecting the copy that is already on the computer, and since that cannot be stopped I can't start XAMPP's version of MySQL via XCP.

I've already created a xampp.ini file to set the non-standard default port, but it has not helped.

I need a way of making the MySQL button in XCP look for XAMPP's copy of MySQL, which will be running as a process (not a service) on a different port with a different socket name. (I'm not sure if the socket name is important - I changed it in case it helped to avoid conflicts)

Any ideas? I'm not averse to poking the program with a hex editor if possible to fix it like that...

[gregbaatard]

In case it helps at all...
Note that I CAN start and stop XAMPPs version of MySQL via the mysql_start and mysql_stop batch files. I assume those files or the programs they call DO take the configurations into account.

Unfortunately, this is a much clumsier and uglier way of doing it and that is not suitable for the purpose XAMPP needs to serve in this deployment.

[gregbaatard]

Huzzah! I seem to have figured it out on my own!

Used a hex editor (XVI32 is nice and lightweight) to open xampp-control.exe and change the following:



As you can see, I've just added a "2" to the end of "MySQL" in that area. As far as I can tell, this is the section of the code which tells XCP what process/service name to look for with regards to the Start/Stop MySQL button. Saved the file and changed the socket name from "MySQL" to "MySQL2" in my.ini (two instances near top of file) and php.ini (two instances - mysql and mysqli sections).

XCP works perfectly now - the MySQL Start/Stop button controls XAMPP's version of MySQL, and the version running on the PC is unaffected.

Hopefully this will help others!

[JonB]

Thanks for the very geeky, but still cool solution~

Happy Holidays