Heya Moxy,
I have been following this thread and I reckon you are making things overly tricky for yourself
Xampp installs mysql for you, you don't need to know any syntax at this point. Some screenies from when I installed xampp - apologies for long post but pictures paint a thousand words and I'm not much of a typist;
First up I extracted the xampp package to D: drive, then I opened up my web browser and in the address bar type 127.0.0.1 You'll then get this;
Click on "Status" on Left hand side;
Good oh, all things a goer at the moment, now click on "Security" and this will open up a new window;
OK we now need to set our root password, click on the link that starts
http://localhost/security etc;
Type in your password twice and click the password changing button - now go back to the original xampp window and on the left hand side under the heading Tools, click on phpMyAdmin;
Type in your password ( the one you just set in the security screen) You will the be presented with below and this is where you create your database (in my case Malta)
Now you will see the database on the left with no tables, to add tables click on the import tab, then on the "Browse" button and navigate to where you have got all your sql files stored and in my case select the malta one and click the open button.
you will see that file in the location area, so now click the "Go" button
And Voila, database now has tables - that's pretty much the database/sql stuff out of the way.
Now the MP4 stuff;
I created a SEOW folder under the D:\xampp\htdocs folder and then extracted the MP4 package to it eg in my case I extracted to D:\xampp\htdocs\SEOW\MP4.
Doing this I need to edit the MP-configuration.php file in wordpad to reflect where the MP4 is - eg SEOW folder instead of the default Scorched Earth folder;
The top bit of this file looks like;
<?php
//
// declare constants to configure Mission Planner
//
$DEBUG=0; //Debug flag, zero for no debug, >0 to turn debugging output on, >10 REALLY verbose debugging
$SHOW_DB_DEBUG_INFO = false; //Show database connection info if any DB connection is invalid. Turn off for security.
$AdminPass = "
admin"; //Password for MP-Admin.php : modify password for your liking
$ShowServer = true; //Show server software versions on front page
$MPSkin = "iron"; //Skin scheme for the MP, values are "classic" or "green" or "iron".
//This MUST be a web server virtual absolute pathname - it CANNOT be a Windows pathname
$IconLocation="
/SEOW/MP4/uniticons/";
Change the bit in yellow, and while you are there you can change the admin password if you wish, (the blue stuff)
You should now be able to type in you mp-admin address (in my case 127.0.0.1/SEOW/MP4/Scripts/MP-Admin.php) in your browser and set the database connection as described by 4Shades
Hope this helps
Cheers
Goanna
