Progress thank god
First of all thanks to Jason for trying to help and to Mike his helpful comments thru the posts (dude you were spot on about the wasting time on admin thing that was the whole problem) and for sharing the tutorial from Adobe. I went thru it in full and think I have worked this out from that.
While admin/root is supposedly able to access all databases, it was only after I created my own restricted user and allowed that user access to the schemas that I was able to click "select" and finally I could see the schemas I needed to complete the tutorial. Thank christ
Jason please pass on my frustration to whomever takes on feedback, that the WA tutorial didn't give this info at all, I have even gone back just now to it again and all it asks to use the default admin access.
Look I just hope this is the last part of the WA tutorial that is a hurdle, because I bought this software based on it's key selling point you didn't need to be a code freak to use it. The WA tutorial should be more thorough if it has taken this long to diagnose it, as I have spent hours longer diagnosing this problem than the tutorial actually runs for which is beyond disappointing.
Sorry for the gripe I just hope that being honest will help improve it for other users if those issues get fixed. I look forward to finalising it and starting my own php site soon.
PS. For what it's worth there were a few questions to answer from Jason and Mike so bare with me:
The port is set to :80 because I reset it according to the Adobe tutorial (which seems to cover this stuff way clearer than WA articles/)
The reason I have called the site folder "Database-eLearning Folder" is because that is what the tutorial instructions tell me to do (unzip amd drag and drop the folder etc). Also the WA tutorial says the testing server in DW auto selects the correct URL prefix which is not even right, as I soon found out. I have now called my site "bluesky" all lowercase as per the many helpful hints in the adobe tutorial.