I guess this is not a good setup to go with as it's been somewhat complicated to get to this point, but the main problem I'm now having is that I'm unable to install a new Joomla 3.x localhost site as it complains that it's unable to connect to the MySQL server with
Error Could not connect to the database. Connector returned number: Could not connect to MySQL server.
My problem is that I don't know how to point the Joomla installation to the XAMPP version of MySQL server. I assume that it's pointing to the other server without any configured Joomla database or user.
Is is doable or have I made a complex situation where I should really have stuck with a simple single instance of MySQL server. ...and that reverting back to the single SQL server setup means rebuilding just about everything on my development PC that references a SQL server (such as MP). I guess that I feel that apps like MP should be seperate to mydev environment and not be dependent on it just in case I have to change the MYSQL server sourced from say XAMPP to something else.
I did try configuring XAMPP to point to the MS MySQL server but it complained about expecting a XAMPP reference in the servers path.
In summary, my preferred requirement for a dev setup is for all Joomla dev to reference the XAMPP SQL server, and all other non-dev apps to reference the MS SQL server. I may have to repeat this post in a XAMPP forum to as it could (is?) more related to the XAMPP installation.